Excel Fundamentals
Reference & Formulas — master the interface, relative vs absolute references, and the five formulas every analyst uses
12 min read
Turn raw data into decisions
Follow this 26-week path to master analyst-grade Excel, SQL, Python, Power BI, and AI-assisted workflows. Mix Learn lessons (structured) with Notes tools (deep dives). Roadmap milestones below show where you stand.
Phase 1 · Weeks 1–8
Build the core spreadsheet, querying, and programming foundations of analytics.
Reference & Formulas — master the interface, relative vs absolute references, and the five formulas every analyst uses
12 min read
Query, join and aggregate relational data
TBD
Pandas, NumPy, and data cleaning fundamentals
TBD
Phase 2 · Weeks 9–18
Apply analytical logic, visual storytelling, and transformation workflows.
IF, nested IF, XLOOKUP — conditional logic without drowning in nesting
14 min read
Power BI and Tableau storytelling — interactive visuals without touching a formula
TBD
Real-world messy data → analysis-ready datasets
TBD
Phase 3 · Weeks 19–26
Scale your analysis, strengthen statistical judgment, and bring the skills together.
INDEX-MATCH, Power Query, automated data pipelines — dashboards that don't require touching a formula
16 min read
Distributions, tests, and significance — the math behind the insights
TBD
Apply Excel, SQL, Python, and dashboards to a real dataset from start to presentation
4 weeks
Join the community for live Q&A and peer projects.
Explore WhatsApp & Discord