Office Witch's Excel Recipe - Why Don't You Know It?

Are you working overtime because of Excel? Or are you having trouble getting your work done because of an error? For you, I have prepared 10 really, really useful tips for using Excel!

What do you do with Excel? Sorting and filtering the data that pours in? What do you do when your team leader suddenly wants data? You want a lot of data, and you are always busy and waste time, right? Have you heard of pivot tables? You may have even used them. But! Pivot tables are easier than you think, and there are more hidden functions. Here is a secret that will drastically reduce the time you spend handling, analyzing, and organizing data.

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 not a course focused on VBA grammar. This is a course that will help you understand the entire structure of VBA at a glance.

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.

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~!

Python + xlwings Work Automation Course Summary 1. Basic Section: Excel Control Fundamentals Cell Handling / Format Application / Image & Chart Insertion 2. Application Section: Automation Scenarios Automatic Email Sending / Report Summary Automation (LLM) / Image Classification Tasks (Teachable Machine)

Now you can use Python in Excel! A light lecture to try out the latest features!

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

Analyzing customers, markets, and revenue patterns—you no longer need to learn it yourself. Just ask AI, and expert-level analysis and strategies are completed in an instant!

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

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

Efficiently tackle the typical office tasks that keep employees working late—such as recurring monthly report writing and large-scale data organization—with the AI assistant Claude. Learn practical techniques for freely designing and enhancing long-form text visualizations and slides while preserving the unique formatting and layout of your company’s templates. Through this process, you can perfectly complete the manual documents that accumulate over time within the allotted deadline.

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.

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.

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)

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.

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