inflearn logo

AI office automation you can create without knowing how to code

Automate repetitive Excel, Word, Outlook, and PowerPoint tasks with AI—without coding.

2 learners are taking this course

Level Beginner

Course period Unlimited

Python
Python
Excel
Excel
PowerPoint
PowerPoint
Word
Word
Outlook
Outlook
Python
Python
Excel
Excel
PowerPoint
PowerPoint
Word
Word
Outlook
Outlook

What you will gain after the course

  • E-book + prompts + practice materials

  • Learn how to ask AI to automate tasks.

  • Learn how to run and modify code created by AI.

  • Create your own Excel, Word, Outlook, and PowerPoint automation.

  • Even when errors occur, you’ll be able to resolve them with AI.

  • You’ll be able to connect multiple Office tasks into a single automation system.

Reduce repetitive office tasks
and build your own automation system with AI

Excel → Word → PDF → Outlook → PowerPoint

Connect Excel, Word, Outlook, and PowerPoint (microsoft-office) tasks.


Turn work requests into steps that AI can execute, receive and run code, and troubleshoot errors together.
From organizing data to creating documents and emails, automate the tasks you used to repeat every day yourself.


Office automation that starts without coding
Reduce repetitive tasks with AI.

Using ChatGPT, Python, Excel, Word, Outlook, and PowerPoint, you will implement
data organization, file consolidation, report generation, document conversion, and email draft creation.
Without writing code from scratch, you will make precise requests to AI,
execute the generated code, and directly modify the parts you need.



This goes beyond a simple introduction to the features.
From repetitive Excel organization to Word document and email processing,
you will complete an automation system based on real-world workflows.
We also cover the process of explaining the cause of errors to AI and resolving them.



Integrate multiple Excel files and automatically generate reports,
create Word documents based on templates and convert them to PDF,
generate email drafts with attachments,
and organize received emails and save processing records.
Finally, connect multiple office tasks into a single workflow.

Find repetitive tasks and
automate them with AI

Section 1 -Download Materials and Prepare the Environment

Download the class materials, e-book, prompt set, and environment configuration files needed for the exercises. Instructions are provided on how to use the attached materials and prepare for the exercises.


Section 2 - Orientation and Automation Basics

Understand the course’s learning direction and identify tasks for automation in repetitive office work. After setting up the Python development environment, run simple code to learn the basic workflow of automation practice.


Section 3 - Automation Prompt Framework

Learn how to turn work tasks into specific automation requirements and write prompts that request the desired code from artificial intelligence. Understand the basic structure of the generated code and learn how to identify and fix the causes of errors together with artificial intelligence.


Section 4 - Excel automation with AI

Request Excel automation code using artificial intelligence, organize data, and consolidate multiple Excel files. This section also covers how to automatically generate practical Excel reports based on the organized data.


Section 5 - Word Automation with Artificial Intelligence

Automatically generate documents by entering data into a Word template, and dynamically configure tables according to the number of data entries. Implement a workflow that automatically converts completed Word documents into PDF files.


Section 6 - Outlook Automation with Artificial Intelligence

Learn how to ask artificial intelligence for code to automate Outlook emails and generate email drafts with files automatically attached. Learn how to organize received emails according to set criteria and record the processing details in a log.


Section 7 - PowerPoint Automation with Artificial Intelligence

Learn how to request PowerPoint automation code using artificial intelligence. This section covers the basic principles and hands-on workflow for automating the presentation creation process based on business materials.


Section 8 - Capstone Project and Automation Expansion

Define the requirements for an automation system that connects multiple Office programs and ask artificial intelligence to implement it. Summarize how to fix errors discovered during execution, apply the completed system to actual work, and expand it.

Automate clocking out on time!

Point 1. Automate repetitive tasks

Automate Excel data organization, the consolidation of multiple files, and report generation to reduce repetitive work. Build automation systems yourself that can be used immediately in line with actual work processes.


Point 2. Requesting Code from AI

Learn how to turn business processes into automation requirements and make specific requests to AI for the code you need. Even when errors occur, you’ll learn to explain the cause and find the right direction for fixing them together.


Point 3. Connecting Office Documents

Use Excel data to create Word documents and PDFs, and connect them with Outlook emails and PowerPoint tasks. Organize work that was previously handled separately in each program into a single workflow.


Point 4. Hands-on practice without the burden of coding

You can run and modify Python code with AI without having to write it all yourself from scratch. Follow along step by step, from downloading materials to completing the capstone project, and expand it to fit your own work.


Daily repetitive Excel and document tasks,
are you still handling them yourself?
This course was created specifically for people like you.


✔️ Office workers who want to reduce repetitive administrative tasks

  • ✔️ Those who want to automate organizing Excel data and consolidating files

  • ✔️ Those who want to automate Word report and PDF document creation without repeating the same tasks

  • Those who want to streamline their workflow, from writing emails to handling attachments

✔️ Non-developers who want to start automating their work with AI

  • Those who want to ask AI to automate tasks without designing the code themselves

  • ✔️ Those who want to run code created by AI and modify it to suit their work needs

  • ✔️ Those who want to identify and resolve the cause of errors together with AI

✔️ For those who want to connect multiple Office programs to create a work system

  • Those who want to automatically generate Word documents and reports based on Excel data

  • Those who want to automate Outlook emails and attachment processing according to their business rules

  • Those who want to connect PowerPoint as well and implement a workflow that processes everything at once


Reduce repetitive tasks one by one yourself.
With artificial intelligence, create an automation system tailored to your work—from Excel to documents and email.

Notes Before Taking the Course


Practice Environment

  • A Windows operating system environment is recommended.

  • Excel, Word, and Outlook are required.
    PowerPoint and Python are also used.
    At least 8 GB of memory is recommended.

Prerequisites and Notes

  • You can get started even without coding experience.
    Basic familiarity with handling files and folders is sufficient.

  • Basic experience using office software is required.
    You will create and fix code with ChatGPT.
    Troubleshooting is conducted through hands-on practice.

Learning materials

  • We provide the course materials as a PDF.
    We also provide an e-book and a set of prompts.

  • Use configuration files and instructional materials.
    Using Excel, Word, and Outlook practice materials,
    you will build automated workflows for repetitive tasks yourself.


Recommended for
these people

Who is this course right for?

  • Office worker looking to reduce repetitive tasks.

  • Those who want to use AI for work automation

  • Those who asked AI for code but had difficulty getting the desired results

  • Those who want to connect and automate multiple Office programs

  • Those who want to create their own automations tailored to their work

Need to know before starting?

  • No advanced programming knowledge is required.

  • Basic experience using PCs and Office is sufficient.

  • You need the Microsoft Office desktop app for Windows.

  • A Python execution environment is required (how to set up the development environment and run it will be covered in the course).

  • I don’t need a paid AI subscription, but I have experience using it on the web.

Hello
This is fasthome

Career Verified

Hello. This is the On-Time Departure Automation Lab.

Having worked in SW practice for about 15 years,
I have been contemplating "ways to reduce repetitive tasks and bring forward the time to leave work."

In this course,
we focus on automation techniques that can be applied immediately in real-world tasks, rather than just theory.

Rather than complex explanations,
we focus on the flow of "Why it's needed → How to use it → Immediate application."

We will save you time through Excel, Word, and various task automations.

More

Curriculum

All

25 lectures ∙ (5hr 5min)

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!

Limited time deal

$1,947.00

68%

$38.50