Learn ALL the "useful" Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file 📁) скачать в хорошем качестве

Learn ALL the "useful" Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file 📁)

Excel has 100s of features, so learning what is important can be tricky. In this video, let me distil the essential concepts and present them in a digestible format in just under 40 minutes. This is "Essential" Excel in 40 minutes. What you will learn: 1) How to use data in Excel 2) The importance of Excel tables 3) Working with Filters & Slicers in Excel to do quick analysis 4) Using "Total Row" / SUBTOTAL function 5) Understanding Excel cell references - Relative / Absolute / Structural / Spill 6) Important and useful Excel functions - IF, IFS, SUBTOTAL 7) Creating and using Pivot Tables 8) Making Excel Charts - Box plots to explore salary distribution 9) Interactive charts with slicers 10) Next steps to improve your understanding of Excel 📁 Sample File & Course Page: ========================= Visit https://chandoo.org/wp/free-data-anal... for the sample file and course details Blank Workbook (for practice) - https://chandoo.org/wp/wp-content/upl... Completed file (with all examples) - https://chandoo.org/wp/free-data-anal... ⌚ Video Topics: ============== 0:00 - What are the Essential Excel topics? 0:41 - About the dataset and the 5 business problems 2:22 - The importance and how to use Excel Tables 8:45 - Using Total Row & SUBTOTAL functions 12:35 - Cell References in Excel - Relative, Absolute, Spill 20:52 - Spill Ranges and Dynamic Array Formulas 22:44 - Using IF / IFS functions in Excel (bonus calculation example) 31:35 - Excel Pivot Tables (and making a department-wise report) 38:35 - Using Excel Charts (Box plots for salary distribution) 📺 Learn more: ============= 💥 Paid Courses for Data People: Advanced Excel Course - (30+ hours of video, 10k+ happy students) https://chandoo.org/wp/excel-school-p... Advanced Power BI Course - (14+ hours of video, 2k+ happy students) https://chandoo.org/wp/power-bi-course/ 🎶 Free Data Analyst Course Playlist: 📚 Course page and all lessons: https://chandoo.org/wp/free-data-anal... 📺 YouTube Playlist:    • FREE Data Analyst Course   👩‍💻 Related Videos: Dynamic Arrays + Spill range in Excel:    • Excel's NEW "#" operator is a game changer!   Excel Basics for a Beginner:    • How to use Microsoft Excel - Beginner to I...   Excel beginner to PRO course:    • Beginner to Pro FREE Excel Data Analysis C...   Important Excel functions:    • These are the ONLY 15 functions you need t...   ~ #excel #dataanalyst #chandoo #freedataanalystcourse #fdac