One thing I can definitely promise you.

If you take this class, your perspective on data through Excel will change.

The reason I can be sure,

This is because of the student's vivid review.

• 20 years of experience in Finance
• Currently working as a finance manager at a foreign manufacturing company (many in-house trainings)
• Offline lectures on Excel data analysis and visualization (2019-)
• Korea Investment Corporation, SK Store, ServerOne Excel Data Utilization Lecture (2021-)

There wasn't a single person who took my class and said, “Excel is easy.”

However, “Excel can also be used like this, and if you use this function, the time will be shortened like this, because Excel had such a function!” I was able to see a lot of surprised responses without being able to hear them.

Beyond the basic functions of Excel If you want to know how to generate and manage data in a more efficient way, we will reward you with the best contentI'll do it.

▶ A situation that can happen in a company

I drew a picture of a situation that might happen in the company. Does the situation sound like a weekend drama? If something like this actually happened, how should you guys have done it?

How much do you know about the functions and functions of Excel

It's not a fundamental solution to this situation.

Why don't you start working in the following order from now on? By doing this, you can immediately respond to many situations required in daily work.

1. Think about what data is required for the report
2. Check more information that can be added to the basic data and expand the data.
3. Use pivot tables to summarize data.
4. Visualize summarized data with various charts.

20 years of experience in Finance,

I only deal with Excel all day

It contains all of my practical Excel work.

▶ Class curriculum

It's not just a class that explains basic Excel functions and functions. Definitely, this class contains the most functions and is the most difficult of the Excel courses in class 101.

It's clear why the classes are structured with challenging content.

This is because I only focused on “practical use.”

1 ️ You can easily find out the basic functions of Excel by searching on the Internet.

However, in order to handle raw data that we use in practice, we don't need just one function. It is necessary to create a single dashboard by using complex functions in an overlapping manner, working with raw data as management data, and visualizing it.

In this process, we are not the information that comes up when we search the Internet, Because I need to know how to learn how to manage and process data in practiceIt's.

2 ️ The data we are dealing with cannot be processed correctly using only one function.

How good would it be if the source of the data to be used in practice was also processed so that it looks good? However, since we have received complex raw data, we must first process the data in a form that is suitable for analyzing it before doing the analysis. When dealing with thousands of rows and dozens of files and sheets, we can't process all of the data with just a simple function.

So we learn Power Pivot, Power Query, and DAX functions. Many people don't know, Because I focused on developing skills that can handle large amounts of data without difficulty with Power Pivot and Power Query, which can be a really powerful room if you know how to use themIt's.

3 ️ The reason we use Excel is to find insights from data.

We don't use Excel to write functions smartly, to work quickly with shortcuts. The reason I use Excel in practice is to manage vast amounts of data in a presentable manner and to find insights from them.

thus I will show you the process of creating a dashboard and experience “Excel can even do such a powerful function”I'll let you do it.

“VLOOKUP, SUMIF, etc.. Do I use Excel well? '

If you think so, you've come to the right place.

I will introduce Power Query and Power Pivot, which will simply change the complicated Excel tasks you used to do.

1. Use Excel functions and Power Query to easily convert data suitable for pivot tables
2. Use Power Pivot to establish relationships between data, extend the information with measures, and generate additional information that can be obtained from the original data.
3. Create a crosstab report, generate the required chart, and connect a slicer to create a dashboard to complete it.

We'll make it

Dashboard deliverables

The functions we'll cover in the class

List of functions extracted from data - I plan to work on the image

“This function has this syntax.” I don't explain it with that content. I will explain why you should use this function in the process of processing and analyzing data, and show you how to use the function.

▶ I recommend it to people like this!

Don't waste your precious time.

Show me the results of your work.

Seize opportunities for growth

Excel is a steamed spec.

I want you to approach Excel as if you were learning to ride a bicycle for the first time. If you fall, you must get up and press the pedals again. Only then will you get used to it quickly and you will soon be centered. Then you won't fall.

I can't tell you that Excel isn't difficult. It is important that you get used to it through constant learning and practice. If you do that, Excel can be an all-around demon bat for anyone.