Free ebook
Free ebook: LAMBDA & Dynamic Arrays
Unlock modern Excel: write reusable custom functions with LAMBDA, LET, and the dynamic array functions that replace complex old formulas.
Get the ebookCourse path
Turn Data Analysis into a course path
Data Analysis & Statistics strings this into a structured, mixed-friendly path with a full lesson list.
View course path5 subtopics in this path
Descriptive statistics, what-if tools, forecasting, scenarios, Solver, analysis add-ins, and practical business analysis.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Summarize distributions, averages, spread, outliers, and ranking patterns.
Chandoo
Open on YouTube (opens in a new tab)
excelisfun
Open on YouTube (opens in a new tab)
Chandoo
Open on YouTube (opens in a new tab)Use Goal Seek, Scenario Manager, and Data Tables for assumptions and sensitivity checks.
Leila Gharani
Open on YouTube (opens in a new tab)Use trendlines, forecast sheets, and simple time-series thinking.
Leila Gharani
Open on YouTube (opens in a new tab)Optimize decisions with constraints, targets, and changing variable cells.
Leila Gharani
Open on YouTube (opens in a new tab)Use built-in statistical tools such as regression, correlation, histograms, and sampling.
excelisfun
Open on YouTube (opens in a new tab)Real Excel screenshots showing what this topic looks like in practice.
Chandoo
Broad free Excel data-analysis course with files and a practical final dashboard.
Open on YouTube (opens in a new tab)excelisfun
Public playlist with classroom-style Excel data analysis foundations.
Open on YouTube (opens in a new tab)Chandoo
Focused PivotTable lesson for analysis and reporting.
Open on YouTube (opens in a new tab)Leila Gharani
Clear dedicated tutorial for Excel forecasting and seasonal prediction.
Open on YouTube (opens in a new tab)Leila Gharani
Strong focused video for sensitivity-style modeling with Excel Data Tables.
Open on YouTube (opens in a new tab)Leila Gharani
Practical Solver walkthrough for multi-variable optimization problems.
Open on YouTube (opens in a new tab)excelisfun
Short setup video for enabling the Analysis ToolPak before statistical analysis.
Open on YouTube (opens in a new tab)
Learn Skills Daily
Long-form course anchor for learners building practical Excel data-analysis skills.
Open on YouTube (opens in a new tab)
Simon Sez IT
Compact course-style introduction to core Excel analysis workflows.
Open on YouTube (opens in a new tab)
Simplilearn
Broad analytics course that fits learners looking for a full Excel data-analysis track.
Open on YouTube (opens in a new tab)
MyOnlineTrainingHub
Strong bridge from beginner analysis into statistics and ToolPak-style thinking.
Open on YouTube (opens in a new tab)
Simon Sez IT
Extracted from saved YouTube search results - titled "Data Analysis with 2 Hour Training", filed under Data Analysis.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
