Have you ever felt itchy and frustrated every time you created and used a function in Excel? If so, try this course, which includes everything from A to Z about functions, to solve it in a cool way!

An Excel Bible for office workers to handle your work quickly and smartly!

Functions and formulas are the strongest areas that form the foundation of ExcelIt is the foundation for all Excel functions. No matter how many other functions you learn, it's difficult to use Excel properly if you don't know basic functions such as SUM, IF, COUNT, and VLOOKUP. Of course, each Excel function is independent, so if there is a problem, it can be solved quickly by searching for tips and answers posted on various Internet sites. However, we can't do anything if we create a formula to solve a complex problem that must reflect our company's situation, or if we have to reflect conditions that have not been seen before in the formula, no matter how simple the task is.

The key is about Excel functions and formulas Poor basic understandingThis is it. I'm just memorizing a few function expressions, and since I don't know the original function of how each function works, I can't find my own way to solve problems, and my applicability to new problems is poor. This course is a systematic explanation of the functions that are the foundation of Excel and the operating principles of Excel for office workers who are using Excel but can only use arithmetic or a few aggregation functions, and are unsure about how to handle Excel functions and formulas well anymore. Process tasks faster and more precisely than now with a convenient and excellent program called Excel Functions.

I learn something like this!

— Ability to use Excel beyond basic usage

— Understanding how to use Excel functions essential for work

— Key features to improve work processing efficiency

— Ability to use context-specific Excel functions

An office worker's best friend, Excel

Perfectly conquer business-essential functions

A New Paradigm for Excel Business Processing

< at Maso Campus Excel functions and formulas commonly used by companies > At, you can develop the following competencies.

Using cell references and static/dynamic ranges

Without basic concepts of cell references, static ranges, dynamic ranges, structural references in tables, and array formulas, it's difficult to handle functions smoothly. Therefore, I will show you step by step how to recognize and express cells and ranges when referring to data in functions and formulas.

“Top 10 Functions” selected by Microsoft

We will summarize the big picture of the purpose and useful functions of using functions based on the “10 most used functions” compiled by Microsoft. Learn about other commonly used functions and practical uses, focusing on SUM for aggregating data, IF and CHOOSE for selecting values based on conditions, DATE and DAYS that handle dates and periods, FIND for text, and VLOOKUP, LOOKUP, INDEX, and MATCH functions used to find and import desired data

More organized with array formulas!

Understand the differences between single calculation and array calculation, practice how to use array functions such as SUMPRODUCT, and learn how to use wildcards to properly handle desired data, how to handle AND and OR conditions, and logical multiplication to create formulas that satisfy all multiple conditions.

Use these functions to find data right in practice!

It covers several functions for finding data, starting with VLOOKUP. In particular, INDEX and MATCH search arrays to find the desired data, or how to use the LOOKUP function to find the last data among various data that satisfies conditions, how to establish an appropriate formula and how it works in various situations that are actually commonly used by companies, and how the formula can be changed to achieve the same purpose, and can be directly applied to practices with complex and large amounts of data.

I recommend it to people like this

— Those who want to use Excel to speed up their work

— People who want to easily handle simple Excel tasks with functions

— People who want to use complex functions well where they are needed

— Those who need an Excel function course that can be directly applied to practice

After listening to Excel functions and formulas commonly used by companies

<Excel functions and formulas commonly used by companies>After attending the course, you will be able to secure the following competencies.

Understanding the working principles of Excel to properly use functions
Use various functions to process even complex data and use it in the desired form
Ability to use functions in the right place without memorizing
Ability to look at data from multiple angles and derive insights

I will teach you everything from the basics of Excel to the useful features of the core Excel functions.

Master this course and become a professional worker!

Course features

This course is not just a dictionary course that lists 330 Excel functions. Excel has many functions, but they are all difficult to memorize, and you don't need to memorize them all.

By focusing on about 30 of the most commonly used functions in work, focusing on how to establish functional expressions in various situations frequently seen in companies, and how the formulas for aggregation, transformation, and data import are built according to what logical flow, you can have the ability to comprehensively understand and use Excel functions and formulas.

STEP 1. A different look at Excel that everyone uses

In order to properly use functions in Excel, which are essential for modern office workers, I will teach you the operating principles of Excel step by step.

As you listen, you'll fall in love with the variety of Excel functions.

STEP 2. How to completely conquer the confusing Excel functions I've heard a lot but are just about to write

SUM, IF, FIND, VLOOKUP... Most of you have seen it somewhere, but few people know what each function does. Let's take a look at these frequently used functions and uncover them!

STEP 3. Until the day when you can import the desired data from complex data all at once with a single function!

If you actually try it out, you can learn how to find the desired data with functions such as INDEX, MATCH... that take your breath away.

Learning content

1. Cell references and data tables

2. Structural references in tables

3. Aggregation using functions and wildcards

4. Period calculation and unit conversion

5. Import data from another table!

6. Aggregate data that satisfies multiple conditions!

Expected Questions Q&A

Q. Do players need to know how to use Excel?

A. That's not true. You don't need to have any prior knowledge about Excel functions, and you don't need to worry about Excel function skills because the instructor will point through the buttons you have to click from beginning to end.

Q. Are there any requirements or requirements to take the course?

A. Since this is a practice-oriented course, it is a good idea to prepare a dual monitor or an extra device that can separate the lecture screen from the practice screen. Also, since exercises are conducted based on Windows OS, we recommend taking courses in a Windows environment.

About knowledge sharers

Please check before taking the course!

- - Since this is a practice-oriented course, it is a good idea to prepare a dual monitor or an extra device that can separate the lecture screen from the practice screen.
  - Since the exercises are conducted based on Windows OS, we recommend taking courses in a Windows environment.
  - Lecture plan and practice files are <0. It is located in the Textbook Download Center> section.