Master Excel 2019 Macro VBA from the Basics

Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!

Excel automation is possible without uploading company data? Revealing AI secrets that maintain security while reducing work hours!

This is a practice-oriented course designed to increase work efficiency by automating repetitive Excel tasks with Python. You will learn how to automate the entire workflow—from opening files to data processing, inspection, consolidation, and saving—and will also be provided with practical automation code using pywin32.

Learn about tasks that can be done using Excel VBA. Learn about the basic syntax of VBA and objects, collections, properties, methods, and events, and create and use Visual Basic functions, Excel functions, and user-defined functions.

Forget boring theories! We're going straight into practice from the beginning of the lecture. Once you start, you'll be captivated by the charm of Excel Macro VBA that you won't be able to stop~!

Even when using AI, the reason you’re still busy lies not in the tools, but in how the work is arranged. By asking four questions—roles, flow, handoffs, and exceptions—you can turn your work into a single blueprint, separate what can be handled by rules from what requires judgment, and reduce how often you need to call on AI in the first place. Use an Excel file containing 1,000 transactions to lock the standards into the tool and generate reports, break tasks down with sub-agents, and hand off what can’t be done to another AI, receiving only the results and carrying on. Finally, connect a messenger as the entry point and add four safety measures, completing the conductor’s role of calling on AI only where needed rather than handing everything over across eight installments, including the OT.

AI Excel that automates perfectly for your tasks without any company security concerns. From data preprocessing to visualization, everything is OK in just a few minutes—without any coding knowledge!

This is not a course focused on VBA grammar. This is a course that will help you understand the entire structure of VBA at a glance.

A flexible workflow pipeline that connects information search, analysis, and organization! A practical search-based automation curriculum completed with Felo

A class on analyzing customer/sales data with Excel, even without R or Python!

Coding Excel data with Python?! It's not that hard~ Becoming a cutting-edge professional is only a matter of time!

In just one hour a day for three days, you will learn the most important and frequently used parts that will allow you to fully master the basics of Excel.

Data is piling up, but are you feeling lost about who to target? Find your key customers through data summarization and design the optimal targeting logic.

With the advancement of technology since the Fourth Industrial Revolution, industry boundaries are collapsing and digitalization is accelerating, opening the era of business process automation through RPA software robots. Through UiPath, I hope you can automate repetitive, simple, and complex tasks with one robot per person, allowing individuals to spend their time on higher-value work. Increase the efficiency of digital labor through RPA and implement automation that is free from the constraints of working hours!

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

If you follow OpenClaw Parts 1 and 2, you eventually end up making a single agent do everything. As you do this, there comes a moment when prompts get tangled, memory gets mixed up, folders get messy, and you feel stuck, not knowing how to organize things anymore. This lecture is the "Introduction to Multi-Agents (Part 2.5)," designed to help you move one step further from that point. While maintaining a single bot, we will separate roles into two agents—planner and editor—and connect each agent to different workspaces and Telegram forum topics. You will personally build a structure where "different agents respond depending on which room you speak in." By following the hands-on practice, you will have the following in your environment: - A configuration file defining two agents: `content_planner` and `content_editor`, - A content folder structure where planning and drafting are separated, - A Telegram group chat where different agents are attached to specific forum topics, - And one actual draft of an Inflearn course introduction created through the collaboration of the two agents. In short, this is a practical class that helps you design the first step of upgrading your Telegram bot from a "single AI assistant" into a "small AI team with divided roles."

This is a practice-oriented course designed to increase work efficiency by automating repetitive PowerPoint tasks using Python. You will learn how to automate the entire document creation process—from creating slides to entering text, inserting images, generating tables, controlling shapes, and saving files. Practical PowerPoint automation code using pywin32 is also provided.

Even if you don't know coding, you can read data - everything about no-code AI analysis that makes perfect sense! If you can use Excel, PPT, and Google Sheets, AI will now handle data analysis for you.

Stop getting student-record planning. I’ll reveal the entire consulting playbook used by a college admissions consultant with 30 years of experience.

KakaoTalk Bot Automation Course & Study Group Opening Announcement ​ We are opening a course and study group where you can learn how to automate KakaoTalk Open Chat room operations, create Iris-based bots, and build AI Agents using n8n/OpenClaw. ​ In this course, you will go beyond creating simple command bots and build automation features that can be used directly in real Open Chat rooms. If you get stuck while building, a dedicated mentor will personally assist you. ​ 1. Course Content ⊙ Basics of Iris-based KakaoTalk bots ⊙ Creating basic command bots ⊙ Creating a stock lookup AI Agent ⊙ Creating an AI Agent for news searches and summaries ⊙ Sending automated daily morning news reports ⊙ Creating an image-generation AI Agent ⊙ Hands-on automation practice integrating n8n/OpenClaw