Even for computer novices? A 25-year veteran instructor's guaranteed roadmap to ITQ Excel Grade A

"Master Excel from the basics to workflow automation in just 25 days. This course is designed to help you become a high-performer by mastering core practical functions like VLOOKUP, Pivot Tables, and Macros to reduce repetitive tasks, while also gaining the skills to create dashboards that visualize data at a glance."

This course is for those who are new to Excel or want to upgrade from basic to advanced level.

A practical formula lecture that will help you become an Excel master! Get your hands on the secret weapon you can use right away in your work.

Expanding Excel's data processing capabilities and enhancing data handling performance through integration with external systems (SQL Server, Access, etc.) - Utilizing core Excel features such as Power Pivot (Excel Data Model) - Ultimately extending usability beyond the various limitations and inefficiencies of Excel

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

Google Sheets and Apps Script work automation that even those with no coding experience can do! I will teach you in the easiest way possible by creating examples that can be used in actual work.

Even complex data becomes clear at a glance with Tableau! From a single drag to a finished dashboard, master data visualization for real-world business.

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

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.

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.

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.

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.

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.

You can start automating Excel without learning to code. Through practical examples, you’ll learn how to describe the tasks you want to AI, run the macros it creates, fix errors, and even add features. By the end of the course, the goal is for you to be able to create macros for new repetitive tasks on your own with AI.

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 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.

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)

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. :)

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)

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