Skip to main content
Practice

Introduction to Python for Automating Workflows

The economic value of a career depends on how much value is created within the same amount of time.

Are you wasting time merging numerous Excel files every day or inserting content into the same PPT template over and over?

Do you manually visit hundreds of web pages and copy/paste information when collecting data from the internet?

Tasks that take years to complete manually can be finished in just a few seconds with a Python program through automation.


Course Structure​

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


Course 1. Orientation​

You can get a preview of how the content in this course will be applied in practice and what exercises you will be doing.

No coding experience is necessary! Just click the green Run button to see what you will be learning :)


Course 2. Python Coding for Non-Programmers​

To automate repetitive tasks with a program, you need to learn how to use Python.

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

If you are already familiar with Python, you can skip ahead to the third course, Essential Automation Knowledge for Boosting Productivity.


Course 3. Essential Automation Knowledge for Boosting Productivity​

By automating the tasks that you previously had to do manually with Python, you can finish work that would take days in just a few minutes.

In this course, you will learn the basic knowledge needed for automating 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 seem intimidating? 🤔

Don't worry! Leave the code writing to AI.

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. Mastering AI-Assisted Coding​

Even if you're not yet comfortable with programming, you can still generate code with AI to automate repetitive tasks.

This course includes basic AI theoretical knowledge as well as prompt engineering techniques for generating and improving code.


Course 5. Applying Python + AI for Work Automation​

Combine everything you've learned so far and automate repetitive tasks in practical scenarios, using AI to improve your code and complete the automation tasks.

Example tasks include:

  1. Automatically generating multiple slides in a certificate PPT 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.


Preview Exercises​

You don't need to make an effort to understand the code during the orientation lesson; just click the green Run button.

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

After running the code, click the complete button to move on to the next lesson! 🚀