Automating VBA tasks using Excel

This is a course that allows you to quickly learn the essential Excel tasks that office workers must encounter, using the latest features.

Stop dealing with messy, complicated data! 💥 Now, organize your data clearly in Excel and become a true productivity pro 😉

From basic functions to high-level practical documents used in the field, to new features exclusive to Excel 2016! Give wings to your documents with Excel 2016!

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.

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 have completed the basic and essential lectures to understand Power Automate Desktop, now you will learn the most frequently used Excel automation flow in your work through hands-on practice so that you can automate more in your actual work.

You know the importance of 🔥Big Data🔥 in business, but have you given up before even starting because of difficult-sounding data analysis tools like Python, R, and SQL? Don't worry anymore😉 This is a course for beginners to learn how anyone can analyze data and discover valuable insights using the highly accessible Excel!🎁

This covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn how to create Excel formulas needed for practical work, easily understand Excel functions, and even write macros and VBA coding using ChatGPT.

Data-driven decision-making, an essential skill in the era of digital transformation! As companies are going all out to find talent with digital capabilities, develop your BA skills to successfully solve organizational problems through this course!

Forget about the difficult Korean language automation that has been going on so far! Just follow along and you will complete the automation program.

Automate repetitive Excel, Word, Outlook, and PowerPoint tasks with AI—without writing code yourself.

This is a practical lecture designed for passing the ITQ Excel Grade A exam in a short period. You will master the four-step process—from data entry to pivot tables and charts—and learn time-saving skills to finish with 15 minutes remaining in the 60-minute exam. Rather than rote memorization, you will understand functions through intuitive pattern matching and complete your Excel skills to be immediately applicable in real-world tasks.

If you’ve been leaving work late because you had to handle everything alone—from organizing meeting minutes, announcements, proposals, presentation materials, and Excel files to customer inquiries—now leave it to Claude. I’ll show you how to complete 11 practical tasks one by one, save them as skills, and automate your daily work, using the exact way I use it myself as a non-developer.

This is a practice-oriented course designed to increase work productivity by automating repetitive Outlook email tasks using Python. From composing emails and saving drafts to accessing the inbox, searching for emails, handling attachments, categorizing emails, and creating calendar events and contacts— you will learn how to automate frequently repeated Outlook tasks using Python and pywin32. Rather than just explaining simple functions, this course is structured to help you build your own reusable Outlook automation programs through automation code ready for immediate practical use and real-world project examples.

Through this course, learners will be able to acquire the skills necessary to obtain a Computer Application Skills certification. This course is structured according to the examination standards for obtaining the Computer Application Skills certification. You can learn and apply fundamental knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Practical - Spreadsheet Practice)

This is a practical course where you will learn how to directly control and automatically generate Word documents using Python and pywin32. You will understand the workflow of generating documents through code rather than manual writing, with the goal of creating an automation structure that can handle reports and documentation tasks with a single click.

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

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.