inflearn logo

Create AI-powered Excel macro workflow automation without knowing how to code

You can start automating Excel without learning to code. Through practical examples, you’ll learn how to describe the tasks you want to AI, run the macros it creates, fix errors, and even add features. By the end of the course, the goal is for you to be able to create macros for new repetitive tasks on your own with AI.

9 learners are taking this course

Level Beginner

Course period Unlimited

Excel
Excel
VBA
VBA
AI
AI
ChatGPT
ChatGPT
Excel
Excel
VBA
VBA
AI
AI
ChatGPT
ChatGPT

Reviews from Early Learners

5.0

5.0

굿뉴스

100% enrolled

After watching the first lesson, I wasn’t sure whether to continue, but I think the explanation of how to receive and use information through ChatGPT using prompt formulas is very good. In fact, it seems like this could be used immediately for work. Of course, even beyond Excel macros, I think the methods for making requests could be applied in other areas as well.

What you will gain after the course

  • How to Automate Repetitive Excel Tasks with Macros and AI

  • How to Organize the Task I Want and Request It Accurately from AI

  • How to Apply and Run AI-Generated VBA Code in Excel

  • How to use AI to identify the cause of an error and fix the code

  • How to Change the Conditions of an Existing Macro or Add New Features

  • How to create the macros you need on your own when a new recurring task arises

The Excel code provided by ChatGPT,

Are you stuck running the code?


This course is for working professionals who are familiar with Excel but new to VBA.


Describe your task, run the generated code,

You’ll practice step by step how to fix errors and adapt it to fit your work.

✓ No Python installation required

✓ No prior knowledge of VBA required

✓ No paid ChatGPT subscription required

Practice environment: Windows PC · Desktop Excel required

We don’t start by memorizing coding syntax.
You will build automations for repetitive formatting, data cleanup, conditional filtering, sheet separation, file creation, and processing multiple files yourself.

And it doesn’t stop at running the code you’ve created;
it also covers how to fix errors, modify existing code, and add the features you need.

From the basics to practical automation, master it in 6 steps.


Section 1 - Preparing for Practice

Download the example files used in the course and prepare your practice environment.

Section 2 - Running Your First Macro

From the basic setup of Excel macros to your first automation using the macro recorder, you’ll try everything hands-on.

Section 3 - Creating Macros with AI

Describe the task you want to perform to the AI, apply the generated VBA code in Excel, and run it in practice.

Section 4 - Automating repetitive tasks

Automate real-world tasks such as applying repetitive formatting, organizing data, extracting data based on conditions, and splitting worksheets.

Section 5 -Fixing errors and modifying macro functionality

Send errors to the AI for correction, change conditions in existing code, or add new features.

Section 6 - Completing the Comprehensive Project

Connect multiple functions into one to complete an automation that creates a report from the source data.

We will actually create a macro like this.

Using examples actually used in the course,
you will create macros for repetitive tasks together with AI.
Rather than stopping at explanations, you will run them yourself and verify the results.

Point 1. Automating repetitive formatting

Apply repetitive formatting tasks all at once.


Point 2. Automated data cleaning

Automatically cleans up duplicate, blank, and messy data.


Point 3. Data extraction by condition

Automatically selects only the data that matches your desired conditions.


Point 4. Automatic sheet and file separation

Automatically creates sheets and files by department or branch.



Point 5. Batch processing of multiple files

Process multiple Excel files in a folder all at once.



Point 6. Automated report and chart generation

It organizes the raw data and even creates reports containing tables and charts.


Repetitive Excel tasks,

Are you still doing it manually?


This course is not for people who are “good at Excel,”

Created for those who want to reduce repetitive tasks.

You can get started even if you’ve never created a macro before


✔️ For those who want to reduce repetitive Excel tasks

  • Those who find repeatedly organizing formats and extracting data cumbersome

  • Those who want to process files by department and branch all at once

  • Those who want to reduce the time spent on repetitive tasks and focus on more important work

✔️ Those who want to create it themselves without coding

  • For those who find VBA syntax difficult but want to use macros

  • Those who want to create macros by explaining the tasks they need to AI

  • Those who want to run the generated code themselves and check the results

✔️ Those who want to continue using the macros they created

  • Those who want to fix errors together with AI

  • Those who want to change the conditions in existing code or add functionality

  • Those who want to expand an automation they have created to other tasks as well


Learning VBA is not the goal.
The goal is to create and use macros tailored to your work.

Notes Before Taking the Course


Practice Environment

  • Practice is conducted on a Windows PC.

  • Desktop Excel installation is required.

  • The screens and menu locations may differ slightly depending on the Excel version, but the practice process is the same.

Prerequisites and Notes

  • No coding or VBA experience is required.

  • It is helpful to have a basic understanding of how to use Excel.

  • Experience asking questions to AI chatbots such as ChatGPT is required.

  • Macro execution may be restricted on company PCs due to security policies.

Learning materials

  • Lecture materials and example files are provided together.

  • Create and run macros yourself using the example data.

  • We also practice correcting errors, modifying code, and adding features.


Practice Tip
Start by following along with the provided examples, and once you become familiar with them, try applying them to your own repetitive tasks. We recommend backing up important files before running a macro.

Recommended for
these people

Who is this course right for?

  • Those who want to reduce repetitive Excel tasks but found VBA or coding difficult

  • Those who want to create Excel macros themselves using AI like ChatGPT

  • For those who have used the macro recorder but found it difficult to create the automation they wanted themselves

  • An office worker who wants to automate repetitive data organization, extraction, and file-related tasks

  • Those who want to quickly create and use the automation they need rather than study VBA syntax.

Need to know before starting?

  • You just need to know how to use Excel basics.

  • Experience asking questions and receiving answers from AI chatbots such as ChatGPT is required.

  • No VBA syntax or programming experience is required.

  • A paid ChatGPT subscription is not necessary.

Hello
This is fasthome

Career Verified

Reduce repetitive tasks and leave work a little earlier.

Hello. This is the Early Leave Automation Lab.

With about 15 years of hands-on software experience, I have continually wondered,
“Is there a way to do this task faster and more easily?”

Here, we focus on AI and office automation
and cover practical automation methods using Excel, VBA, Python, Word, PowerPoint, and Outlook.

Rather than complex theory,
we focus on building things yourself, running them, and applying them to your work..

From automation you can start without knowing how to code
to hands-on projects that connect multiple tasks into a single workflow,
I will create courses that can genuinely reduce your work time.

Not automation you simply learn, but automation you actually use.
This is the Early Leave Automation Lab.


YouTube: https://www.youtube.com/@fasthome8282

Blog: https://blog.naver.com/fasthome

More

Curriculum

All

19 lectures ∙ (3hr 6min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

fasthome's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$28.50

25%

$38.50