FREE Data Analyst Course - Best Excel Formulas in an hour - Beginner to PRO Masterclass

🎉 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-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 - https://chandoo.org/wp/excel-school-program/ 📺 Excel formula videos: XLOOKUP - https://youtu.be/DDlZXXEI1bU VLOOKUP - https://youtu.be/8rtvDQVQaA0 INDEX + MATCH - https://youtu.be/kly0uPIM4IU FILTER - https://youtu.be/JuTdj2j-9Kg Dynamic Arrays (# operator) - https://youtu.be/kR6czKY4FEw SUMIFS - https://youtu.be/YEt-aYbDTrs IF (Advanced uses) - https://youtu.be/-yFpzIRifK4 5 EVEN MORE advanced IF examples - https://youtu.be/15NtFld9mVM Top 15 Excel functions - https://youtu.be/B5hayFelHDU Top 10 formulas for accountants - https://youtu.be/xarUaqsjmFY 🎶 Free Data Analyst Course Playlist: https://www.youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO ~ #excel #dataanalyst #chandoo #freedataanalystcourse #fdac