강의

멘토링

로드맵

NEW
Productivity

/

Task Automation

Business Automation with Python and Excel

Python + xlwings Work Automation Course Summary 1. Basic Section: Excel Control Fundamentals Cell Handling / Format Application / Image & Chart Insertion 2. Application Section: Automation Scenarios Automatic Email Sending / Report Summary Automation (LLM) / Image Classification Tasks (Teachable Machine)

27 learners are taking this course

  • hjk1000
실습 중심
파이썬활용
엑셀자동화
Python
Excel

What you will learn!

  • Excel Control Using Python

  • Email sending / Report summarization / Image classification tasks and other applications

1. Basics: Excel Control Fundamentals

  • Working with Cells

    • Reading / Writing Cell Values

    • Range Specification and Data Processing

  • Apply Formatting

    • Font, color, border settings

  • Insert Images & Charts

    • Loading Images into Excel

    • Data-driven Chart Generation


2. Application: Automation Scenarios

  • Automatic Email Sending

    • Integration with Gmail

    • Add attachment

  • Report Summary Automation

    • LLM (e.g., GPT) Utilization

    • Excel Data → Summary Report Generation

  • Teachable Machine Integration

    • Using a Trained Image Classification Model

This course covers the process of automating Excel tasks using Python and xlwings. Starting with the basics of reading and writing cell values, you'll learn fundamental Excel control skills including image insertion and chart creation, followed by practical automation cases such as automated email sending and report summarization using LLM. Furthermore, you can experience AI-based extended applications through image classification using Teachable Machine and Excel integration. Therefore, this course is suitable for office workers who want to automate repetitive daily Excel tasks, beginner to intermediate users who want to apply Python to practical work, data analysis beginners, and practitioners who want to integrate AI into their actual work. In other words, this is a practical course useful for anyone who wants to break free from simple repetitive tasks and increase productivity through "Excel + Python + AI".

🎯 Target Audience

  1. Office workers tired of repetitive Excel tasks

    • Those who want to automate daily repetitive tasks like data organization, report creation, and email sending

    • Someone who thinks "I use Excel well, but isn't there a more efficient way?"

  2. Beginners and intermediate learners who want to use Python for work

    • Someone who knows basic Python syntax but doesn't know how to apply it in real-world work

    • Those who want to achieve immediate results through "Python → Excel" integration practice

  3. Business Automation Specialist / Data Analysis Beginner

    • A staff member in the department responsible for reports, data management, and email delivery

    • People who want to automatically handle simple data analysis and visualization

  4. Professionals interested in AI utilization

    • People who want to apply AI technologies like ChatGPT/LLM and Teachable Machine to their work

    • People who want to experience differentiated automation using "AI + Excel"

Recommended for
these people

Who is this course right for?

  • Office workers exhausted by repetitive Excel tasks

  • Beginner to intermediate users who want to utilize Python for work

  • Business Automation Specialist / Data Analysis Beginner

Need to know before starting?

  • It would be good to know the basics of Excel and Python.

Hello
This is

1,477

Learners

36

Reviews

8

Answers

4.7

Rating

10

Courses

안녕하세요

비전공자로 딥러닝을 열심히 공부하는 직장인입니다.

공부하면서 느낀 점들을 여러분들과 함께 공유하고 싶습니다

감사합니다.

Curriculum

All

11 lectures ∙ (3hr 7min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

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

$4.40

hjk1000's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!