Best Excel Formulas in an hour - Beginner to PRO Masterclass @chandoo_
Best Excel Formulas in an hour - Beginner to PRO Masterclass  @chandoo_
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
Best Excel Formulas in an hour - Beginner to PRO MasterclassIntroduction to DAX SVG Charts (way better than default Power BI visuals)XLOOKUP in Excel | Step-by-Step Tutorial for Beginners (better than VLOOKUP)How I easily deal with 100s of columns in Excel ~ PRO TrickπŸ’‘Email Excel Reports with Power Automate & Office Scrips - One Click Automation πŸ€–Combine Excel Sheets with *this* simple formulaExcel for Managers [FREE Masterclass]How to Remove Duplicate Values in Excel - Data Cleaning Tips🧹Easy XLOOKUP Hacks You Need To Try in Excel!Excel Magic Revealed: Unstacking Data Like a Pro! ✨Power BI Q&A - What is Microsoft Fabric? Tableau vs. Power BI, How important is SQL and more...Excel LOOKUP function is CRAZY 🀯 (fastest way to get tenure bands)
Chandoo |

Best Excel Formulas in an hour - Beginner to PRO Masterclass

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER