Excel has 400+ FUNCTIONS, and most of these are a WASTE of time. If you want to get good with Excel in a short time, focus on these 10 instead. Once you know how to use and combine them, you can learn more.
So, what are the 10?
SUMIFS
XLOOKUP
FILTER
COUNTIFS
INDEX
EDATE
UNIQUE
TEXTJOIN
SORT
IFERROR
Let's dive in.
⏱ VIDEO TOPICS:
===============
0:00 Most Excel functions are useless
0:42 Number 1 function SUMIFS
1:52 XLOOKUP function
2:40 How to get multiple values with lookup? (FILTER function)
3:43 COUNTIFS Function
5:49 INDEX Function
6:40 The most important function
6:57 EDATE Function
7:50 TEXTJOIN Function
8:25 Using TEXTJOIN in a FUN way
9:07 UNIQUE Function
9:57 SORT Function
11:05 IFERROR Function
11:52 What if you don't like FUNCTIONS?
SAMPLE FILE
==============
Refer to this page for more on this topic + free example workbook to practice https://chandoo.org/wp/top10excelf...
LEARN MORE
==============
▶ Pivot Tables for Data Analysis with 8 quick examples • How to use Pivot Tables in Excel A ...
▶ Power Query & Data Cleansing for Beginners (10 examples) • Data Cleaning in Excel 10 Tricks (B...
▶ Power Pivot for Beginners (20+ examples) • Learn Power Pivot & DAX for Power BI ...
▶ Only 15 Functions you need • These are the ONLY 15 functions you n...
Specific Functions:
▶ XLOOKUP • I don't use VLOOKUP anymore. I use th...
▶ FILTER • I don’t use filters in Excel anymore....
▶ SUMIFS • 10 *next level* SUMIFS tricks only Ex...
▶ INDEX • Excel's INDEX + MATCH How to use it...
▶ DATE formulas • 3 Powerful & Essential DATE formulas ...
▶ Dynamic Array functions • Learn about the *NEW* Dynamic Array F...
Courses:
If you want to learn more than these 10, consider my Excel School program.
This comprehensive course can help you navigate Excel data analysis situations with ease and grace. You will learn how to use and combine various Excel functions to solve work problems quickly. You will also learn how to apply pivot tables, charts, power query and dashboards to elevate your performance.
Check out Excel School and join here https://chandoo.org/wp/excelschoolp...
~
What does A1 say to SUM()?
You add value to me
#excel