Practical Excel for office workers - from data processing to analysis

A specialized data processing tool that is much easier and more sophisticated than Vlookup.
Learn “Power Query” and become a successful person!

Do you know the differences between Excel of the past and today's Excel? Previously, joining data often involved tedious copy-and-paste or Vlookups. However, this often resulted in lag and inconveniences when using large amounts of data. To address this, Excel has added Power Query, a specialized data extraction feature .

1 What is Power Query?

PowerQuery is a feature that allows Excel to use the "query" data extraction function, previously used in Microsoft Access. Simply put, it's a specialized data processing tool that sits between Nogada and VBA, capable of handling most data processing tasks.

By simply checking the Ribbon menu > Developer Tools (Options - Customize Ribbon - Developer Tools...check) > Excel Add-ins > Analysis ToolPak, Solver checkbox, you can use almost all of the specialized analysis functions available in specialized statistical analysis tools in a general-purpose Excel program. Of course, the results are the same.
Wouldn't you like to learn PowerQuery, which allows you to easily use specialized analysis functions?

2 Reasons why Power Query is efficient and good!

1. When compiling and reporting monthly data, it's necessary to first consolidate data from numerous Excel files within a specific folder. Here are the differences between the old and new Excel versions:

2. In the field, we often use the Vlookup function to join data.
At this time, the differences between the old Excel and the new Excel are as follows.

3. In addition, you can cleanly retrieve web data and extract text without using functions.
You can easily perform complex data processing, such as data formatting and complementing the shortcomings of pivot tables.

3. This course's unique strengths

Presenting Excel's most trendy data processing and analysis skills!

Until now, predicting future data values was generally considered a task limited to those skilled in specialized statistical analysis tools (SAS, R, MINITAP, etc.). While Excel power users may be aware of this feature, it's designed based on statistics, requiring basic statistical knowledge to interpret the results. This knowledge is rare among general users.
This course provides basic statistical knowledge so that you can flexibly apply Excel's statistically based 'analysis' function to your work, and helps you understand and apply it easily through practical examples .

4 What you will learn in this lecture

Learn how to process structured and unstructured data from the workplace using Excel's Power Query, a Business Intelligence Platform.

Leverage slicers, pivot table linking, and conditional formatting to create stunning visualizations of aggregated pivots, and automatically refresh pivot tables with a little VBA code.

Excel's statistical analysis features, designed based on statistical models, allow you to grasp data properties at a glance with descriptive statistics and scientifically predict future data with regression analysis. Through this course, you can easily master the fundamentals of statistics and write scientific reports .

Finding the optimal combination of data is easy to understand and can be applied in practice. The Solver function helps you find the optimal combination of data with limited resources in the business world.