Excel Craftsman's Macro

For office workers who are tired of repetitive Excel tasks, we will teach you coding, and for those who only know Excel in a simple way, we will teach you its power and infinite possibilities!

In the basic course, you will learn how to use Power Automate Desktop and become familiar with it by following along. Now, in the essential course, you will learn about variables and frequently used grammar so that you can use it better and automate more.

A course that covers how to conveniently handle work using the macro recorder without the burden of VBA coding! You can understand how to utilize macros in various ways through practice of simply converting data accumulated in the company into an Excel database and building a search system to find it.

You can create an online reservation system through Microsoft Bookings where customers can see our company's services at a glance, select a schedule, time, and person in charge, and make a reservation right away. Everything from reservations to reservation confirmation emails and advance notifications is automated, and customers can easily make reservations and change their schedules. Now manage your reservations smartly!

We will practice automating repetitive tasks using Power Automate Desktop, a free RPA tool from MS. Through this process, we will learn to understand automation and apply it to our actual work.

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.

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.

ITQ PowerPoint national certification key summary lecture that can be obtained by utilizing two days of the weekend! 4 mock exams and real-time mock exam solution videos provided

Through this course, students will master the core functions of NotebookLM step-by-step and learn how to delegate repetitive office tasks—such as report writing, meeting minute summaries, and data analysis—to an AI assistant. Moving beyond simple conceptual learning, the course provides actual work routines and checklists, equipping students with practical skills that can be applied to their jobs immediately after completion.

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

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)

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

1. You may experience the side effect of thinking about VBA codes while sleeping. 2. You may become a workaholic by choice due to the desire to automate repetitive Excel tasks one by one.

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)

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 the [Beginner's] Data Visualization with Power BI course, you will learn how to edit data using the query editor, visualize data using various tools, and check and share the analyzed results.

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.

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.

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