Excel, the office worker's best friend
Master essential business functions! 📊
👀 Please check before taking the class!
- Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture and hands-on screens.
- Since the training will be conducted based on Windows OS, we recommend taking the course in a Windows environment.
- Lecture notes and practice files are available in the <0. Textbook Download Center> section.
Excel work processing
New Paradigm 💡
#1 Using cell references and static/dynamic ranges
#2 Microsoft's Top 10 Functions
#3 Even more systematically with array formulas !
#4 Functions for finding data that can be used immediately in practice!
Excel Bible for Office Workers 📖
Functions and formulas are the most fundamental part of Excel, forming the foundation for all its features . Regardless of what other functions you learn, if you don't understand basic functions like SUM, IF, COUNT, and VLOOKUP, you'll struggle to fully utilize Excel. The key lies in a lack of fundamental understanding of Excel functions and formulas. Memorizing a few formulas without fully understanding how each function works can hinder your ability to find unique problem-solving methods and hinder your ability to apply them effectively.
This course is designed for professionals who use Excel but are unsure how to effectively use its functions and formulas. It systematically explains the fundamentals of Excel, including functions and their operating principles. With the convenient and powerful Excel functions, you can work faster and more accurately than ever before.
- Understanding Excel's operating principles to effectively utilize functions
- Process complex data using various functions and use it in the desired format.
- The ability to use functions appropriately without having to memorize them
- The ability to examine data from various angles and derive insights
👉 Master this course and become a professional worker!
You can learn it in this lecture! 😎
[STEP 1] A Different Look at Excel, Used by Everyone
To help modern workers effectively utilize Excel functions, we'll explain how they work, step by step. Listen carefully and you'll be captivated by the diverse capabilities of Excel functions.
[STEP 2] Mastering Excel functions that you've heard of but find confusing when actually using them.
SUM, IF, FIND, VLOOKUP… Most of you have probably seen these functions somewhere, but few know what they do. Let's take a look at these frequently used functions and delve into their functions!
[STEP 3] Until the day you can retrieve the data you want from complex data with a single function!
Trying to actually use data exploration functions can be overwhelming. Learn how to use functions to find the data you want, even in complex data sets.
Structural reference of the table Aggregation using functions and wildcards Period calculations and unit conversions Cell references and data tables Expected Questions Q&A 💬
Q. Is prior knowledge of Excel required?
No, you don't need any prior knowledge of Excel functions. We'll walk you through every single button click from beginning to end, so you don't have to worry about your Excel skills.
Q. Are there any requirements or prerequisites for taking the course?
Since this is a hands-on course , we recommend bringing a dual monitor or a spare device that allows you to separate the lecture and practice screens . Furthermore, since the practical training will be conducted on a Windows OS, we recommend taking the course in a Windows environment.
Introducing the knowledge sharer ✔️
