Home
1/3

3 representative Excel functions essential for practice: PART.1

Rookie
4 chapters
English · Japanese · Korean|Audio Korean

Check out what classmates have to say!


About the class



“Excel,” the most difficult work tool for practitioners

What's the reason for that?



That's because it's full of strange functions. Using functions that are too difficult for beginners.. But what if you don't use it? Business hours will double


In this class, you can learn 3 representative functions that are essential for practical use. Functions that must be used in practice are grouped and introduced by classifying them into logical functions that compare conditions, functions that end with IF, and functions that find values that match conditions. It's a class that will change the way you think “functions are convenient” from functions that you have only thought of as difficult. If you download the provided practice files and follow the classes, you can become an Excel proficient at some point.


Course effects


  • Repetitive and time-consuming tasks can be automated.

  • It can be applied to actual work or projects, and can improve work efficiency and obtain better results.

  • You can reduce errors that may occur during calculations and data processing and obtain accurate and consistent results.

  • You can improve your data analysis and problem solving skills, and develop problem solving skills in the process of analyzing data.


Recommended target


  • Everyone who uses Excel for office work

  • Job-seekers or new hires

  • Self-employed and small merchants


Notes before taking the course


  • This class uses M365 and can be taken by users of all Excel versions.

  • Enhanced functions that can only be used in M365 and Excel versions 2019 to 2021 are also introduced, and the versions are shown in the class content.




3 reasons why this class is special


❶ Curriculum designed to be easily digested by anyone


“Friendly class.”

The course is introduced in detail so that you don't miss the contents of the course. To use a function well, you must be able to select the required function according to the data and you must know exactly how to use the function's arguments, and this class suggests how to do that.



❷ A must! I'll only tell you the functions you need to know


Among the many functions, I will tell you only the Excel functions that can be used directly in practice and the essential functions.

It introduces functions and formulas that can be replaced even by users of versions that cannot use functions with enhanced functionality, so it is designed so that users of all versions can be satisfied. After completing the class, you can feel an amazing improvement in your Excel skills.

*Complete master of how to use the VLOOKUP function


* Smart use of the COUNTIFS function


❸ Class101 BEST EXCEL CLASS


The creator of the popular 'Short Course', whose productivity has reached 12,000 favorites, is back with an upgraded Excel class in 2023. In parts 1, 2, and 3, we will reveal all representative functions required for practice, practical compression courses for Excel beginners, and data analysis and visualization for intermediate and advanced students.


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

✅ Part 2. Practical compression course for Excel beginners (2021, M365 ver.) *Scheduled to open at the end of October

✅ Part 3. Data analysis and visualization *Scheduled to open in mid-November


image.png

image.png


Curriculum

Creator

Hantip

Hantip

✅ Biography

Running a YouTube short course channel with approximately 160,000 subscribers (Excel, PowerPoint, Word, and Hangul lessons)

2022-2024 Microsoft MVP

Working as a lecturer (attending public institutions and businesses other than Busan Education and Training Center, Hansuwon Redevelopment Center, and NHN)


✅ Books

It becomes! 7 Days of Practical Excel (2019) Aegis Publishing

It becomes! Practical Excel PowerPoint Word & Hangul (2022) Aegis Publishing

It becomes! 7 Day Practical Hangul Writing (2023) Aegis Publishing

EBS Computer Literacy Level 1 and 2 Excel, Access Calibration, and Editing (2021-2023)

짤막한강좌

짤막한강좌

hantip

hantip

briefclass

briefclass

View similar classes you might also like

Data analysis and visualization using ExcelOffice Productivity  |  Hantip

Notes on Copyright Protection

  • All videos and materials included in the class are protected intellectual property under relevant laws.
  • You may face legal action if you copy, distribute, transmit, modify or edit the videos or materials included in the class without permission.
CLASS 101, LLC.
1201 North Market St. Suite 111, Wilmington, DE, 19801
support@101.inc