Class introduction

Are you still struggling and overwhelmed with data processing?

Difficult to handle as a function Data can be solved very easily using Power QueriesI can do it, but there are so many students who have a preconceived idea that power queries are difficult.

In this class, something like that Addressing preconceptionsWe are introducing usage through examples so that it can be easily applied to the business. In addition to this, use power queries Process dataand pivot table, pivot chart reportThe one that works dynamically after writing Complete the dashboard You can even learn what you do.

Hallo Dear classmates! This is a short course.

Five years after the launch of the “Easy and Fast, Ready-to-Use Excel for Practitioners” class at CLASS101 in the second half of 2019, we launched an upgraded Excel class.

<Most Popular Productivity>

Excel is used every day for work, but the way Excel is being used is evolving little by little as the years go by. It provides more convenient functions and more diverse functions! But don't be burdened with learning too much. You can supplement your ability to use Excel when needed.

You can learn how to analyze and visualize data using power queries in a class consisting of 3 modules.

✅ Part 1. Three representative Excel functions that are essential for practice (Go to class)

✅ Part 2. Practical compression course for Excel beginners (2021, M365 ver.) (Go to class)

✅ Part 3. Data analysis and visualization using Excel power queries

Course effect

• The ability to refine data and process it into the required format has been improved, making it possible to extract useful information from various data sets.

• Data processing tasks can be automated to minimize repetitive tasks.

• Multiple data sources can be effectively integrated to perform comprehensive analysis, and Excel functions can be complemented and extended when working with data.

• You can summarize data through pivot tables, and effectively organize dashboards by dynamically manipulating data through slicers and time bars.

Recommended target

• Everyone who uses Excel for office work

• Job-ready students or new hires

• Self-employed and small businesses

Notes before taking the course

• This class uses M365 and users of Excel 2016 and above can take it without any inconvenience.

• [It becomes! Practical Excel PowerPoint Word & Hangul] Want to buy a book? 👉 Go buy

• [It becomes! 7 Day Practice Excel] Want to buy a book? 👉 Go buy

3 reasons this class is special

❶ A method that can be used immediately in practice!

This class covers techniques specialized in data processing using power queries so that anyone can easily learn them, and introduces classmates how they can be used directly in practice.

Through expert guidance on how to extract data from various data sources and perform complex conversion tasks, Excel users are provided with strong capabilities for data tasks that actually occur in the business.

It provides an active practical learning environment that addresses not only theory but also data processing problems that occur in the field.

Through practice, classmates can respond to various data scenarios they may encounter in actual work and find solutions through Power Query.

❷ Technology to present data visually!

It deals in depth with techniques to visually express data using Excel conditional formatting, etc.

You'll also be taught how to create different types of pivot charts and use conditional formatting to highlight specific patterns or exceptions in data. By learning various data manipulation techniques through pivot tables and slicers, you can learn how to effectively discover data patterns and insights and reflect them on dashboards.

❸ CLASS 101 BEST EXCEL CLASS

The popular “Short Course” creator with 13,000 lessons and productivity is back with an upgraded 2023 Excel class. Throughout Parts 1, 2, and 3, representative functions required for practice, practical compression lessons for Excel beginners, and data analysis and visualization classes using Excel power queries for intermediate to advanced students will all be revealed.

✅ Part 1. 3 representative Excel functions that are essential for practice

✅ Part 2. Practical compression course for Excel beginners (2021, M365 ver.)

✅ Part 3. Data analysis and visualization using Excel power queries