Learn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file ๐Ÿ“) @chandoo_
Learn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file ๐Ÿ“)  @chandoo_
Uploaded August 2024 | Updated November 2026, 1 day ago
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 chandoo.org/wp/free-data-analyst-course for the sample file and course details

Blank Workbook (for practice) - chandoo.org/wp/wp-content/uploads/2024/08/essential-excel-concepts-blank.xlsx
Completed file (with all examples) - chandoo.org/wp/free-data-analyst-course

โŒš 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)
chandoo.org/wp/excel-school-program

Advanced Power BI Course - (14+ hours of video, 2k+ happy students)
chandoo.org/wp/power-bi-course

๐ŸŽถ Free Data Analyst Course Playlist:

๐Ÿ“š Course page and all lessons: chandoo.org/wp/free-data-analyst-course
๐Ÿ“บ YouTube Playlist: youtube.com/playlist?list=PLmejDGrsgFyCD25L2XEKESQEw8smsY6WO

๐Ÿ‘ฉโ€๐Ÿ’ป Related Videos:

Dynamic Arrays + Spill range in Excel: youtu.be/kR6czKY4FEw
Excel Basics for a Beginner: youtu.be/F7aPazuS8QY
Excel beginner to PRO course: youtu.be/v2oNWja7M2E
Important Excel functions: youtu.be/B5hayFelHDU

~

#excel #dataanalyst #chandoo #freedataanalystcourse #fdac
Learn ALL the useful Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file ๐Ÿ“)Excel SCAN Function is Shockingly Powerful! [Step-by-Step]This Excel Trick Finds the Last 5 Salaries Instantly!How I Tracked 5 Stocks in Excel With One Formula!You need these 4 Excel Skills if you run a Small BusinessHow-to Build an Advanced Excel ChartHow to set up and use Calculation Groups in DAX | Power BIDENSE Rank Excel FormulaPower BI Dashboard Makeover - 5 IdeasAll Unique Names with One Excel FormulaExcel SEQUENCE Function: 5 Genius UsesThe Secret VLOOKUP Trick that Lookups Multiple Sheets ๐Ÿš€
Chandoo |

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

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER