강의

멘토링

커뮤니티

NEW
Productivity

/

Task Automation

Non-majors can also create websites with Excel automation + streamlit for at-a-glance viewing by Python Vibe Coding

# The Secret to Finding Your 'Quitting Time' Ever stayed up all night because one Excel formula broke, or had an entire report ruined by a single typo? If you're an office worker, you've probably experienced this at least once. This course was designed to break free from that 'repetitive pain.' You don't need to memorize complex coding syntax. We'll use Cursor AI, a tool powered by artificial intelligence that writes code when you give it text commands, and Streamlit, which lets anyone easily create websites. I've captured the process of solving real workplace pain points I've personally experienced (merging files by branch, automatically categorizing repair items, infinitely generating PDF confirmation documents, etc.) through 'conversational dialogue' without writing a single line of Python code yourself. After completing this course, you'll transform from a simple office worker into a 'digital transformation expert' who revolutionizes your team's work efficiency.

1 learners are taking this course

  • codebridge
실습 중심
AI 코딩
AI 활용법
사무자동화
엑셀
Python
Vibe Coding
Excel

What you will gain after the course

  • AI Utilization Skills: Master the 'vibe coding' technique of obtaining desired automation programs by giving precise prompts to Gemini without writing code directly.

  • Own your own web service: Instead of an Excel file that only runs on your computer, deploy a proper 'inventory management web app' that your colleagues can actually access and use.

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


Excel Work,AIComplete It With

Break free from repetitive Excel tasks using AI
Become a digital transformation expert who revolutionizes work efficiency


You're familiar with pulling all-nighters because Excel formulas keep breaking, or having to rewrite an entire report due to a single typo, right?

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

If you're an IT asset manager or general affairs team member who works overtime every month collecting inventory data from branches nationwide, you can immediately apply 5 automation scripts to your work that enable data collection, conditional filtering, and automatic PDF generation.

Break free from the frustrating work methods of the past, and with AI, you too can grow into an expert who changes the game in your work.


Automate Excel and build your own web app
all at once using Cursor AI and Streamlit!

Break free from the pain of repetitive Excel tasks,
and become a digital transformation expert for your team.

By the end of this course, you will


You can completely automate repetitive tasks by coding with AI.

  • You'll no longer experience 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 simply by giving text commands without complex coding. You'll learn how to solve various real-world problems—such as consolidating files by branch, automatically categorizing items for repair, and generating unlimited PDF confirmation documents—as naturally as 'having a conversation.'

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

  • It doesn't stop at just automating Excel files that run only on your computer. You'll gain hands-on experience building and deploying an 'inventory management web app' that your colleagues can actually access and use. Through this, you can transform into a 'digital transformation expert' who revolutionizes your team's work efficiency.

You will own a set of 5 Python automation scripts that can be immediately deployed in actual work.

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

Master the 'Vibe Coding' technique that utilizes AI without memorizing syntax.

  • Even non-majors who gave up on coding after struggling with Python grammar are welcome. Learn the 'vibe coding' technique of giving precise prompts to AI like Gemini to obtain the automation programs you want, allowing you to create powerful automation tools without writing code directly. You'll learn how to directly translate AI utilization skills into work performance.




✔️

No more Excel work stress!

Solving Repetitive Excel Pain
with AI

Are you wasting time on repetitive Excel tasks? This course teaches you how to automate complex work and create web services that can be immediately applied to your work, without having to write Python code directly, by utilizing Cursor AI and Streamlit.

Automate Excel content into charts

Creating Custom Work Automation & Web Apps

You'll learn how to solve various real-world problems by verbally explaining them to Cursor AI, such as consolidating inventory files by branch, automatically categorizing devices that need urgent repair, combining user information, and automatically issuing PDF equipment return confirmations. Additionally, you'll gain hands-on experience creating and deploying an inventory management web app that you can use with your colleagues using the automated code you've developed.

My Own Office Automation Website

5 AI-Powered Automation Scripts

Through the course, you can master 5 automation Python scripts that are immediately applicable to real work, including data merging, conditional filtering, MAC address preprocessing, and automatic PDF document generation. Step-by-step guidance is provided from Cursor AI installation to essential settings, allowing you to participate in hands-on practice right away.


📚

Building an Automation Pipeline with AI

Setting Up the Practice Environment and Cursor AI Configuration

Section 1

Setting Up the Practice Environment and Cursor AI Configuration

You will install the Cursor AI code editor and complete essential settings. You'll connect your Google account, understand the features of free and paid plans, and prepare a development environment utilizing AI. Through this, you'll be ready to create automation programs by conversing with AI without writing code directly.


Computer Equipment Inventory Data Automation

Section 2

IT Equipment Inventory Data Automation

Consolidate scattered inventory files from each branch and automatically extract devices that need repair. Combine with HR data to update actual user information, automatically generate equipment return confirmation PDFs, and standardize serial number and MAC address formats by implementing 5 types of practical automation scripts.


Office Automation Website

Section 3

Building an Inventory Management Website with Streamlit

Build an inventory management website using Streamlit where you can check and visualize data immediately upon upload. Integrate Python automation code to complete your own web dashboard that can generate 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 overwhelmed by AI utilization skills

Those who are working repetitive overtime due to Excel function errors or data cleanup,
or even sacrificing their weekends

📌

Non-majors with no coding experience whatsoever

Those who know Python is good for work automation, but have repeatedly given up before even starting
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 compilation




Notes Before Enrollment


Practice Environment

  • Windows or macOS operating systems are supported.

  • Python 3.x version installation is required.

  • Cursor AI code editor is required.

  • A smooth internet environment is more important than a relatively high-spec PC.

  • Python, Vibe Coding, Excel

Prerequisites and Important Notes

  • Knowing basic Python syntax will help with learning.

  • Even without coding experience, you can follow along with 'vibe coding'.

Learning Materials

  • Use the lecture notes provided in the course.

  • Please refer to the Cursor AI installation and setup guide materials.

  • Let's look for resources related to implementing web apps with Streamlit together.


Recommended for
these people

Who is this course right for?

  • A professional high-achiever wannabe who feels lost about how to use AI at work but wants to immediately create visible 'results'

  • Non-CS majors who gave up on coding (coding dropouts) after only studying Python syntax, even though they knew Python was good

  • IT asset managers and general affairs team members who work overtime for several days each month aggregating inventory data from branches nationwide

Need to know before starting?

  • I'll guide you step by step starting from how to install Python.

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

Hello
This is

431

Learners

51

Reviews

16

Answers

4.7

Rating

9

Courses

플랫폼 사이의 경계를 허무는 개발에 매력을 가지고 관련 강의를 제작하고 있습니다. 잘 부탁드립니다!

경력

현) IT 대기업 개발자

서울 4년제 컴퓨터 공학 졸업

 

[Eng]

I am fascinated by development that breaks down barriers between platforms and am creating related lectures. Thank you for your support!

YouTube: https://youtube.com/channel/UChmHjzyYedu9yYb3YmnOOog?si=xM1HueA3TJ4BjnV3

Contact: codebridge747@gmail.com

Experience

Current) Developer at a major IT corporation

Bachelor's degree in Computer Engineering from a Seoul 4-year university

Curriculum

All

14 lectures ∙ (1hr 31min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

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

Limited time deal

$4,955.00

28%

$42.90

codebridge's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!