Top 10 Excel Functions you should learn in 2024

Опубликовано: 28 Сентябрь 2024
на канале: Chandoo

138,222

5.3k

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/top-10-excel-f...

💡 LEARN MORE
==============

▶ Pivot Tables for Data Analysis with 8 quick examples -    • Learn Excel Pivot Tables in 10 Minute...
▶ 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/excel-school-p...

~

What does A1 say to SUM()?
You add value to me 😍

#excel