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
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
![Excel SCAN Function is Shockingly Powerful! [Step-by-Step]
Every heard of SCAN function in Excel? Today, let me show you why you need this function and how it changes the way you solve your data problems. I think SCAN is Magic โจ
You are going learn:
What is SCAN function in Excel
SCAN syntax and application
How to use SCAN to calculate running total quickly
Using SCAN to get Maximum values
SCAN with LAMBDA
Advanced SCAN usage when your data is dynamic
~WHAT IS SCAN FUNCTION~
Scan function in Excel lets us run an operation on a range and returns all the intermediate results.
For example, you can use SCAN function to calculate running total of a range.
~WHAT IS THE SYNTAX OF SCAN~
SCAN(initial_value, range or array, operation)
For example:
=SCAN(0, A1:A10, SUM)
is going to return the running to of the range A1:A10
You can also use LAMBDA functions with SCAN to create more complex calculations.
=SCAN(0, A1:A10, LAMBDA(a, b, SUM(a,b)))
will return the same values as the first SCAN example above.
โฑ Video timestamps:
0:00 - What is SCAN function & Why it is important?
1:46 - Understanding how SCAN works
3:46 - Using SCAN to calculate running MAX
4:57 - Using LAMBDA functions with SCAN
6:38 - How I use SCAN to solve tricky problems
๐บ Watch next
How to use LAMBDA function in Excel - https://youtu.be/YrMCkE59ef4
How to use FILTER function in Excel - https://youtu.be/JuTdj2j-9Kg
Top 10 Essential Excel functions - https://youtu.be/HgNCvd8IbSc
๐ Sample Workbook:
If you need a file with SCAN examples, download the scandoo.xlsx here:
https://chandoo.org/wp/wp-content/uploads/2024/03/scandoo.xlsx
~
What is the favourite Excel function of a German Shepard ๐ถ?
LAMBda... ๐
#Excel #functions Excel SCAN Function is Shockingly Powerful! [Step-by-Step]](https://i.ytimg.com/vi/VrQSgI596IQ/mqdefault.jpg)









