lesson1Title

lesson2Title

lesson3Title

lesson4Title

lesson5Title

lesson6Title

lesson7Title

lesson8Title

lesson9Title

lesson10Title

automationIntroOtChapter1Title

# No need to understand the code just yet!
# Click the 'Run' button on the right and check the 'Results' 🙂

import openpyxl
from pptx import Presentation
from io import BytesIO
from pptx.enum.shapes import MSO_SHAPE_TYPE

# Load the PowerPoint file
presentation = Presentation("input_file.pptx")

# Load the Excel file
wb = openpyxl.load_workbook("input_file.xlsx")
sheet = wb.active

# Create a list to store data
data_sets = []
for row in sheet.iter_rows(min_row=2, values_only=True):
 data = {
 "AWARD_NAME": row[0],
 "NAME": row[1],
 "CONTENT": row[2],
 "DATE": row[3],
 "ORGANIZATION": row[4],
 }
 data_sets.append(data)

# Use the first slide as the template
template_slide = presentation.slides[0]

# Copy slide elements
for data in data_sets:
 new_slide = presentation.slides.add_slide(template_slide.slide_layout)

 for shape in template_slide.shapes:
 # Handle group shapes
 if shape.shape_type == MSO_SHAPE_TYPE.GROUP:
 for sub_shape in shape.shapes:
 if sub_shape.shape_type == MSO_SHAPE_TYPE.PICTURE:
 image_stream = sub_shape.image.blob
 new_slide.shapes.add_picture(
 BytesIO(image_stream), sub_shape.left, sub_shape.top, sub_shape.width, sub_shape.height
 )
 # Handle picture shapes
 elif shape.shape_type == MSO_SHAPE_TYPE.PICTURE:
 image_stream = shape.image.blob
 new_slide.shapes.add_picture(
 BytesIO(image_stream), shape.left, shape.top, shape.width, shape.height
 )

 # Handle shapes with text
 elif shape.has_text_frame:
 new_shape = new_slide.shapes.add_textbox(shape.left, shape.top, shape.width, shape.height)
 new_shape.text_frame.clear()
 for paragraph in shape.text_frame.paragraphs:
 new_paragraph = new_shape.text_frame.add_paragraph()
 new_paragraph.text = paragraph.text
 new_paragraph.alignment = paragraph.alignment
 if len(paragraph.runs) > 0:
 new_paragraph.font.size = paragraph.runs[0].font.size
 new_paragraph.font.bold = paragraph.runs[0].font.bold
 new_paragraph.font.italic = paragraph.runs[0].font.italic

 # Handle auto shapes
 elif shape.shape_type == MSO_SHAPE_TYPE.AUTO_SHAPE:
 new_shape = new_slide.shapes.add_shape(
 shape.auto_shape_type, shape.left, shape.top, shape.width, shape.height
 )
 if shape.has_text_frame:
 new_shape.text = shape.text

 # Replace text with data
 for shape in new_slide.shapes:
 if shape.has_text_frame:
 for paragraph in shape.text_frame.paragraphs:
 if "<AWARD_NAME>" in paragraph.text:
 paragraph.text = data["AWARD_NAME"]
 elif "<NAME>" in paragraph.text:
 paragraph.text = data["NAME"]
 elif "<CONTENT>" in paragraph.text:
 paragraph.text = data["CONTENT"]
 elif "<DATE>" in paragraph.text:
 paragraph.text = data["DATE"]
 elif "<ORGANIZATION>" in paragraph.text:
 paragraph.text = data["ORGANIZATION"]

# Remove the template slide (the first slide)
presentation.slides._sldIdLst.remove(presentation.slides._sldIdLst[0])

# Save the final result to a file
presentation.save("output_file.pptx")

# Python for Workflow Automation: An Introduction

**The economic value of a career** depends on how much one can accomplish in a given amount of time.

Do you spend hours merging Excel files or repeatedly inserting content into the same PowerPoint template?

Are you manually visiting hundreds of web pages, copying, and pasting information to collect data?

Tasks that would take years manually can be completed in seconds with Python automation.

 

## Course Overview

The **Automate Workflows with Python and AI** course follows this sequence:

 

### Course 1: Introduction

Get a preview of how this course applies to real-world tasks and what exercises you’ll complete.

No coding experience needed! Click the green `Run` button to preview your learning journey :)

 

### Course 2: Python Basics for Non-Programmers

To automate repetitive tasks, you need to learn `Python`.

This course begins with an introductory Python course for those who have never programmed before, so you can start without any prior experience.

If you're already familiar with Python, skip ahead to Course 3: `Essential Automation for Productivity`.

 

### Course 3: Essential Automation for Productivity

With Python automation, tasks that once took days can now be completed in minutes.

In this course, you will learn fundamental automation techniques for business tasks, including:

1. How to manipulate and automate the editing and analysis of `xlsx` (Excel) data.

2. How to create `pptx` (PowerPoint) slides and visualize data.

3. How to generate `docx` (Word) documents and create tables programmatically.

4. How to automate the process of collecting information from the internet through `web scraping`.

5. How to send `emails` using Python code.

 

Does coding still feel intimidating?

> Don’t worry! Let AI handle the coding for you. 🤔

You just need to understand the `concepts`.

In the code editor's `Code Generation` tab, you can generate new code from scratch or improve existing code based on your needs.

 

### Course 4: AI-Assisted Coding Mastery

Even if you're new to programming, AI can help you automate repetitive tasks.

This course covers `AI fundamentals` and `prompt engineering` techniques for generating and refining code.

 

### Course 5: Practical Automation with Python + AI

Put your knowledge into action by automating real-world tasks with AI-driven code improvements.

Example tasks include:

1. Automatically generating `multiple slides` in a certificate PowerPoint template.

2. Converting sales report Excel data into `Word documents`.

3. Extracting stock market data like the S&P 500 index in `real-time`.

4. Collecting founding years and founder information of hundreds of global companies via `web scraping`.

 

## Try It Yourself: Preview Exercises

No need to analyze the code in detail—just click the green `Run` button to get started.

Preview the exercises and get a glimpse of what you will learn in the full course. 🙂

Once you’ve run the code, click `Complete` to proceed to the next lesson! 🚀