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 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
Watch video Learn ALL the "useful" Excel concepts in 40 mins - Tables, Formulas, Pivots & Charts (with file 📁) online without registration, duration hours minute second in high quality. This video was added by user Chandoo 20 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 66,619 once and liked it 2.2 thousand people.