About the class

Hi, classmates!

You are How far can you use ExcelAre you doing it?

You'll learn a completely different way to use Excel that no one in the company told you! Furthermore, we have easily solved even the most important data analysis in this day and age. I'll teach you everything from basics to application so that you can easily follow along even if you don't know Excel or don't know data analysis!

Course effects

• I can clearly understand the two most important basic principles when using Excel.

• You can select and learn only the core functions that are responsible for 80% or more of the tasks that can be done with Excel.

• You can understand the data analysis process and lay the foundation for practical use.

• Data can be visualized in a variety of ways using Excel charts and functions.

Recommended target

• People who use Excel for work

• Those who find Excel constantly difficult and complicated.

• People who are interested in data analysis but don't know how to get started

• Those who want to easily apply data analysis to practice without difficult coding

Notes before taking the course

• We recommend Excel 2016 or higher or MS Offce 365. (Excel versions below 2013 can also be used, but some features or functions may be limited.)

3 reasons why this class is special

❶ Two basic principles of Excel that anyone who uses Excel should definitely know

One of the functions we perform the most in Excel is Ctrl+C/Ctrl + V, or copy/paste. However, when we paste with Ctrl + V in Excel, the original format of the Excel data is broken.

To prevent this problem from occurring at all, we must understand the types of Excel data and be able to paste formulas/values/formats separately.

Excel is a program in which data is entered into a “cell (cell),” which consists of horizontal rows and vertical columns, and is the point where a single row and column meet. What matters here is which direction the rows and columns each move.

When writing a formula or function, we need to apply an appropriate reference to the referenced cells to obtain the exact result value we want across the entire data range.

❷ Get to know the data analysis process right away

The data analysis process consists of [Problem Definition and Analysis Objective Setting] → [Data Gathering] → [Data Exploration] → [Data Preprocessing] → [Data Analysis] → [Verification and Evaluation] → [Data Visualization].

You can learn what we need to do at each step and how we can do that using various functions and functions in Excel.

❸ Data visualization

Excel is the best tool for effectively visualizing data.

In addition to static visualization with a frozen screen, such as PPT, it is also possible to implement dynamic visualization where the visualization results automatically change according to desired criteria. We'll teach you everything about Excel data visualization, from basic bar charts to Interactiver Dashboards.