Best Excel Formulas in an hour - Beginner to PRO Masterclass

Published: 27 August 2024
on channel: Chandoo

30,980

1.2k

🎉 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 https://chandoo.org/wp/free-data-anal... 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 - https://chandoo.org/wp/excel-school-p...

📺 Excel formula videos:

XLOOKUP -    • I don't use VLOOKUP anymore. I use th...
VLOOKUP -    • How to use Excel VLOOKUP? Complete Be...
INDEX + MATCH -    • Excel's INDEX + MATCH - How to use it...
FILTER -    • I don’t use filters in Excel anymore....
Dynamic Arrays (# operator) -    • Excel Dynamic Arrays and How to use t...
SUMIFS -    • 10 *next level* SUMIFS tricks only Ex...
IF (Advanced uses) -    • 10 Advanced IF formulas every analyst...
5 EVEN MORE advanced IF examples -    • 5 Advanced Tips on how to use IF form...
Top 15 Excel functions -    • These are the ONLY 15 functions you n...
Top 10 formulas for accountants -    • If you work in finance, here are the ...

🎶 Free Data Analyst Course Playlist:
   • FREE Data Analyst Course

~

#excel #dataanalyst #chandoo #freedataanalystcourse #fdac

Watch video Best Excel Formulas in an hour - Beginner to PRO Masterclass online without registration, duration hours minute second in high quality. This video was added by user Chandoo 27 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 30,980 once and liked it 1.2 thousand people.

8,263

271