Learn Excel
Master Excel — from your very first formula to real dashboards.
A calm, step-by-step Excel roadmap for complete beginners. Learn the exact skills companies actually hire for, with free notes, practice files and real projects.
What you'll learn
Everything you need to master Excel
Clear outcomes so you always know what you're building toward.
Core formulas
SUM, IF, VLOOKUP, XLOOKUP, INDEX-MATCH and the modern essentials.
Data cleaning
Fix messy data fast with Text, Date and lookup techniques.
Pivot tables
Summarise thousands of rows in seconds and answer real questions.
Charts & dashboards
Build clean, executive-ready dashboards from raw data.
Power Query basics
Automate repetitive imports and transformations.
Shortcuts & speed
Keyboard shortcuts and habits that 10× your speed.
Roadmap
Beginner to Advanced — the complete path
A calm, structured path so you never feel lost. Move at your own pace.
Beginner
- Excel interface & navigation
- Basic formulas (SUM, AVERAGE, IF)
- Formatting & tables
- Sorting & filtering
Intermediate
- VLOOKUP, XLOOKUP, INDEX-MATCH
- Text & date functions
- Pivot tables & pivot charts
- Conditional formatting deep-dive
Advanced
- Power Query for data cleaning
- Dynamic array formulas
- Dashboards with slicers
- Intro to Excel automation with macros
Real-world projects
Build things you can actually show
Every project uses real datasets and real problems — perfect for your portfolio.
Sales Dashboard
Turn a raw sales sheet into a clean, interactive dashboard.
Personal Finance Tracker
Monthly budget tracker with automatic summaries and charts.
HR Attendance Report
Clean and analyse attendance data with pivots and formulas.
Inventory Manager
Track stock in and out with lookups and alerts.
Free notes
Short, clear notes for every topic
Written to be revised quickly — perfect before interviews or projects.
Formulas cheat sheet (PDF)
Free inside the VIP community.
Shortcuts cheat sheet (PDF)
Free inside the VIP community.
Pivot tables quick guide
Free inside the VIP community.
Power Query starter notes
Free inside the VIP community.
Practice files
Learn by doing, not just watching
Real datasets and starter files so you can practise along with every lesson.
Beginner practice workbook
Free inside the VIP community.
Formulas practice pack
Free inside the VIP community.
Dashboard starter file
Free inside the VIP community.
Real-world messy datasets
Free inside the VIP community.
FAQ
Common questions about learning Excel
Still curious? Ask anything inside the VIP community.
Related resources
Explore other skills
Each skill has its own beginner-friendly roadmap.
AI
Understand and use modern AI tools like ChatGPT to save hours every week.
ExplorePower BI
Turn boring data into clean, interactive reports business teams love.
ExploreSQL
Query real databases with confidence — the #1 data skill employers ask for.
ExplorePython
Automate work, analyse data and build small useful tools from scratch.
ExploreLearn with a community that actually helps.
Get daily tips, free notes, practice files and doubt-solving — all inside the free VIP WhatsApp community.