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

Опубликовано: 09 Март 2025
на канале: Chandoo

66,619

2.2k

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 ch...
Excel Basics for a Beginner:    • How to use Microsoft Excel - Beginner...
Excel beginner to PRO course:    • Beginner to Pro FREE Excel Data Analy...
Important Excel functions:    • These are the ONLY 15 functions you n...

~

#excel #dataanalyst #chandoo #freedataanalystcourse #fdac