Excel Task Automation for Non-Majors in Just 2 Hours - Even Web Apps with Cursor AI

How did Assistant Manager Kim, who worked overtime every day, become a "leave-on-time pro" in just 1 hour? The secret to reclaiming your "clock-out time" Staying up all night because an Excel formula broke, or having an entire report ruined by a single typo—every office worker has experienced this at least once, right? This course was designed to put an end to that "recurring pain." You don't need to memorize complex coding syntax. We utilize Cursor AI, an AI-powered tool that writes code based on text commands, and Streamlit, which allows anyone to easily create websites. I have captured the entire process of solving the "pain points" I personally faced in the field—such as merging files by branch, automatically classifying items for repair, and generating infinite PDF certificates—all by "conversing" with AI without typing a single line of Python code yourself. By the end of this course, you will be reborn not as a mere office worker, but as a "Digital Transformation Expert" who revolutionizes your team's work efficiency.

(4.7) 3 reviews

37 learners

Level Beginner

Course period Unlimited

Python
Python
Excel
Excel
Vibe Coding
Vibe Coding
Python
Python
Excel
Excel
Vibe Coding
Vibe Coding

Reviews from Early Learners

4.7

5.0

tata

100% enrolled

The lecture wasn't too long, so it was easy to watch quickly after work. It covered just the essential points I needed, and I'm already applying them to my work. I recommend it.

What you will gain after the course

  • AI Proficiency: Master the 'Vibe Coding' technique to obtain the automation programs you want by providing precise prompts to AI, even without writing the code yourself.

  • Own your own web service: Instead of an Excel file that only runs on your computer, you will personally deploy a proper 'Inventory Management Web App' that your colleagues can actually access and use.

  • Practical Automation Package: You will own a set of 5 Python automation scripts ready for immediate practical use, including data merging, conditional filtering, MAC address preprocessing, and automated PDF document generation.


Excel tasks,AI finishes it all

Escape repetitive Excel tasks by utilizing AI
and become a digital transformation expert who innovates work efficiency..


Are you familiar with the experience of working through the night because of Excel formulas that break every time, or having to rewrite an entire report due to a single minor typo?

You will experience the process of creating complex business automation programs by asking questions to Cursor AI as if giving commands, without writing a single line of code yourself.

If you are an IT asset manager or a general affairs team member who works overtime every month to aggregate inventory data from branches nationwide, you can immediately apply five types of automation scripts to your practical work—covering everything from data aggregation and conditional filtering to automatic PDF issuance.

Break away from the frustrating work methods of the past; with AI, you too can grow into a game-changing expert.


From Excel automation to building your own web apps all at once, using Cursor AI and Streamlit!

Escape the pain of repetitive Excel tasks and transform into your team's digital transformation expert.
.

By the end of this course, you will


You can completely automate repetitive tasks by coding with AI.

  • No more staying up all night due to Excel formula errors or having an entire report ruined by a single typo. Using Cursor AI and Streamlit, you can easily create the automation programs you want by simply giving text commands without complex coding. You will learn how to solve various real-world problems—such as aggregating files by branch, automatically classifying items for repair, and infinitely generating PDF certificates—by simply "conversing" with the AI.

You can personally create and operate your own work automation web service.

  • It doesn't stop at just automating Excel files that run only on your own computer. You will experience building and deploying a 'Inventory Management Web App' that your colleagues can actually access and use. Through this, you can transform into a 'Digital Transformation Expert' who innovates the team's work efficiency.

You will own a set of 5 Python automation scripts that can be immediately applied to real-world tasks.

  • You will directly create and acquire Python automation scripts that solve problems frequently encountered in actual business settings, such as data merging, conditional filtering, MAC address preprocessing, and automatic PDF document generation. These scripts will immediately enhance your work productivity.

Master 'Vibe Coding' techniques that utilize AI without memorizing grammar.

  • It's perfectly fine even if you are a non-major who once gave up on coding after struggling with Python grammar. By mastering 'Vibe Coding'—the skill of feeding precise prompts to AI like Gemini to get the automation programs you want—you can create powerful automation tools without writing a single line of code yourself. You will learn how to directly translate AI utilization skills into work performance.




✔️

Stop the stress of Excel work now!

Solving Recurring Excel Pain
with AI

Are you wasting time on simple, repetitive Excel tasks? This course teaches you how to use Cursor AI and Streamlit to automate complex tasks and create web services ready for immediate practical use—all without writing Python code yourself.

Automating Excel content into charts

Practical Automation & Web App Development

You will learn the process of solving various real-world problems—such as aggregating inventory files by branch, automatically classifying devices in urgent need of repair, merging user information, and automatically issuing PDF device return confirmations—by explaining them in plain language to Cursor AI. Furthermore, you will gain hands-on experience in building and deploying an inventory management web app that you can use with your colleagues, utilizing the automated code you've created.

My Own Office Automation Website

5 Types of AI-Powered Automation Scripts

Through this course, you can master five practical Python automation scripts ready for immediate workplace application, including data merging, conditional filtering, MAC address preprocessing, and automated PDF document generation. We provide step-by-step guidance from Cursor AI installation to essential settings, allowing you to jump straight into the hands-on practice.


📚

Building an Automation Pipeline with AI

Setting up the practice environment and configuring Cursor AI

Section 1

Setting Up the Practice Environment and Configuring Cursor AI

Proceed with the installation and essential configuration of the Cursor AI code editor. Understand the Google account integration and the features of free and paid plans, and prepare a development environment utilizing AI. Through this, you will be ready to create automation programs by conversing with AI without writing code directly.


Automation of IT Equipment Inventory Data

Section 2

IT Equipment Inventory Data Automation

We will implement five types of practical automation scripts that aggregate scattered inventory files by branch and automatically extract devices requiring repair. These scripts will update actual user information by combining inventory data with HR data, automatically issue device return confirmation PDFs, and standardize serial number and MAC address formats.


Office Automation Website

Section 3

Building a Streamlit-based Inventory Management Website

We will build an inventory management website using Streamlit that allows you to check and visualize data immediately upon upload. By integrating Python automation code, you will complete your own web dashboard capable of generating charts with a single click and deploy a web service that your colleagues can actually use.


We can solve the concerns
of people like this!

📌

Professionals who feel lost regarding their AI utilization skills

Those who are experiencing repetitive overtime or even giving up their weekends
due to Excel function errors or data organization issues

📌

Non-majors with absolutely no coding experience

Those who know that Python is great for task automation, but have given up every time because they couldn't even get started due to complex syntax

📌

Leaders who want to improve their team's work efficiency

Those who are concerned about efficient digital transformation methods while watching team members spend time on repetitive paperwork or data collection




Notes before taking the course


Practice Environment

  • Windows or macOS operating systems are available for use.

  • Python 3.x version installation is required.

  • The Cursor AI code editor is required.

  • A stable internet connection is more important than having a high-spec PC.

  • Python, Vibe Coding, Excel

Prerequisite Knowledge and Important Notes

  • Knowing basic Python syntax will be helpful for learning.

  • Even if you have no coding experience, you can follow along with 'Vibe Coding.'

Learning Materials

  • Use the lecture notes provided in the course.

  • Refer to the installation and setup guide for Cursor AI.

  • Look for materials related to web apps implemented with Streamlit.


Recommended for
these people

Who is this course right for?

  • Aspiring high-performers who feel lost on how to use AI at work but want to produce immediate, tangible 'results'

  • Non-majors who know Python is great but gave up after only studying the syntax.

  • IT asset managers and general affairs staff who work overtime for several days every month to consolidate inventory data from branches nationwide

Need to know before starting?

  • I will guide you step-by-step, starting with how to install Python.

  • Instead of complex algorithms, we focus on how to talk to AI (prompt engineering).

Hello
This is codebridge

Inflearn Verified

Career Verified

1,653

Learners

142

Reviews

35

Answers

4.8

Rating

16

Courses

I share knowledge by combining the know-how gained through direct challenges with new trends.

Experience

  • Master's program in AI in Silicon Valley, USA

  • Developer at a major domestic IT corporation (6+ years)

  • Currently developing and operating 14 Android apps, 7 iOS apps, and websites

     

 

[Eng]

Based on my existing experience and expertise, I'm sharing know-how and tips I want to share while following world trends. Thank you for your cooperation!

Experience

Developer at a major IT corporation in South Korea (6y +)

Bachelor's degree in Computer Engineering

More

Curriculum

All

14 lectures ∙ (1hr 31min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

3 reviews

4.7

3 reviews

  • tata님의 프로필 이미지
    tata

    Reviews 10

    Average Rating 5.0

    5

    100% enrolled

    The lecture wasn't too long, so it was easy to watch quickly after work. It covered just the essential points I needed, and I'm already applying them to my work. I recommend it.

    • codebridge
      Instructor

      Thank you for taking the course. ☺️ I will continue to create many more informative lectures in the future.

  • kyounghunkim13828님의 프로필 이미지
    kyounghunkim13828

    Reviews 1

    Average Rating 5.0

    5

    31% enrolled

    • yesgirin5164님의 프로필 이미지
      yesgirin5164

      Reviews 1

      Average Rating 4.0

      4

      62% enrolled

      codebridge's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!