Uploaded August 2024 | Updated November 2026, 3 hours ago
π Unlock AI for $10 per month: https://ntn.so/Chandoo
~
Here is something that most people get wrong when learning Excel. They learn the functions, but not "when" and "how" to use them. So in this masterclass, let me tell you "when" and "how" to use Excel functions with 10 business problems.
What you will learn in this video:
β Working with Excel formulas & functions
β COUNTIFS, SUMIFS, AVERAGEIFS
β FILTER Functions, multiple criteria
β CHOOSECOLS function
β MIN, MAX
β SMALL, LARGE
β SORT + TAKE functions
β UNIQUE
β # OPERATOR
β COUNTA vs. COUNT functions
β VLOOKUP
β XLOOKUP
β INDEX@Mat+ MATCH
β IFERROR
β How to nest formulas to get the result you want
β Complex business problems and formula solutions for them
β€ And plenty of homework problems
π Sample files:
Please visit chandoo.org/wp/free-data-analyst-course for the sample file and more information about these functions.
β± Video timestamps:
0:00 - The problem with learning Excel functions
1:51 - Total salary and headcounts by department (COUNTIFS, SUMIFS, AVERAGEIFS)
8:28 - All employees with more than $100k salary (FILTER)
12:21 - Seeing only a few columns with FILTER using CHOOSECOLS
16:17 - How to learn & remember all this info
20:36 - All female employees with more than $100k salary (FILTER multiple conditions)
24:16 - Lowest, highest, top 5 salary values (MIN, MAX, MINIFS, MAXIFS, SMALL, LARGE, SORT+TAKE)
33:44 - Listing all departments with UNIQUE and using # operator
37:03 - Lookup functions (VLOOKUP, XLOOKUP, INDEX+MATCH, IFERROR)
53:22 - Highest paid person (XLOOKUP + MAX)
57:22 - All the employees that joined in March (FILTER + DATE FUNCTIONS)
1:01:41 - Making a report with formulas (COUNTIFS, SUMIFS, UNIQUE, #, Conditional Formatting)
1:09:09 - What's next?
πΊ Learn more:
πΌ Advanced Excel Course by Chandoo - chandoo.org/wp/excel-school-program
πΊ Excel formula videos:
XLOOKUP - youtu.be/DDlZXXEI1bU
VLOOKUP - youtu.be/8rtvDQVQaA0
INDEX + MATCH - youtu.be/kly0uPIM4IU
FILTER - youtu.be/JuTdj2j-9Kg
Dynamic Arrays (# operator) - youtu.be/kR6czKY4FEw
SUMIFS - youtu.be/YEt-aYbDTrs
IF (Advanced uses) - youtu.be/-yFpzIRifK4
5 EVEN MORE advanced IF examples - youtu.be/15NtFld9mVM
Top 15 Excel functions - youtu.be/B5hayFelHDU
Top 10 formulas for accountants - youtu.be/xarUaqsjmFY
πΆ Free Data Analyst Course Playlist:
youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
~
#excel #dataanalyst #chandoo #freedataanalystcourse #fdac
π Unlock AI for $10 per month: https://ntn.so/Chandoo
~
Here is something that most people get wrong when learning Excel. They learn the functions, but not "when" and "how" to use them. So in this masterclass, let me tell you "when" and "how" to use Excel functions with 10 business problems.
What you will learn in this video:
β Working with Excel formulas & functions
β COUNTIFS, SUMIFS, AVERAGEIFS
β FILTER Functions, multiple criteria
β CHOOSECOLS function
β MIN, MAX
β SMALL, LARGE
β SORT + TAKE functions
β UNIQUE
β # OPERATOR
β COUNTA vs. COUNT functions
β VLOOKUP
β XLOOKUP
β INDEX@Mat+ MATCH
β IFERROR
β How to nest formulas to get the result you want
β Complex business problems and formula solutions for them
β€ And plenty of homework problems
π Sample files:
Please visit chandoo.org/wp/free-data-analyst-course for the sample file and more information about these functions.
β± Video timestamps:
0:00 - The problem with learning Excel functions
1:51 - Total salary and headcounts by department (COUNTIFS, SUMIFS, AVERAGEIFS)
8:28 - All employees with more than $100k salary (FILTER)
12:21 - Seeing only a few columns with FILTER using CHOOSECOLS
16:17 - How to learn & remember all this info
20:36 - All female employees with more than $100k salary (FILTER multiple conditions)
24:16 - Lowest, highest, top 5 salary values (MIN, MAX, MINIFS, MAXIFS, SMALL, LARGE, SORT+TAKE)
33:44 - Listing all departments with UNIQUE and using # operator
37:03 - Lookup functions (VLOOKUP, XLOOKUP, INDEX+MATCH, IFERROR)
53:22 - Highest paid person (XLOOKUP + MAX)
57:22 - All the employees that joined in March (FILTER + DATE FUNCTIONS)
1:01:41 - Making a report with formulas (COUNTIFS, SUMIFS, UNIQUE, #, Conditional Formatting)
1:09:09 - What's next?
πΊ Learn more:
πΌ Advanced Excel Course by Chandoo - chandoo.org/wp/excel-school-program
πΊ Excel formula videos:
XLOOKUP - youtu.be/DDlZXXEI1bU
VLOOKUP - youtu.be/8rtvDQVQaA0
INDEX + MATCH - youtu.be/kly0uPIM4IU
FILTER - youtu.be/JuTdj2j-9Kg
Dynamic Arrays (# operator) - youtu.be/kR6czKY4FEw
SUMIFS - youtu.be/YEt-aYbDTrs
IF (Advanced uses) - youtu.be/-yFpzIRifK4
5 EVEN MORE advanced IF examples - youtu.be/15NtFld9mVM
Top 15 Excel functions - youtu.be/B5hayFelHDU
Top 10 formulas for accountants - youtu.be/xarUaqsjmFY
πΆ Free Data Analyst Course Playlist:
youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO
~
#excel #dataanalyst #chandoo #freedataanalystcourse #fdac





![Excel for Managers [FREE Masterclass]
Do you work as a manager and use Excel? Then this live stream is for you. In this informative, useful and incredibly time-saving session, learn the most impactful Excel concepts & tricks that matter to you.
π Sample file: https://chandoo.org/wp/wp-content/uploads/2025/03/sample-file-done.xlsx
#excelformanagers #excel Excel for Managers [FREE Masterclass]](https://i.ytimg.com/vi/elbXQRARrhw/mqdefault.jpg)




