Choose a route based on what you can do today—not on a label. Every path uses practical work: a real spreadsheet, a repeatable report, a small automation or a check you can apply at work.
Basic: build confidence with the essentials
Start here if you are learning the tools, have inherited a workbook, or want a reliable foundation before automating anything. The aim is to understand the screen, make safe edits and verify your output.
- Excel Beginner: 18 lessons with practice files
- Excel VBA: 15 free lessons
- Power Query Beginner: 10 lessons
- Power Automate Beginner: 8 lessons
- SAP Basics for business users
Intermediate: solve repeatable work problems
Choose this level when you can follow a process but want to make it faster, more reliable and easier to hand over. Build a clean data model, a refreshable report or an automation with checks.
- Excel Intermediate: practical analysis and reporting
- Power Query Intermediate: real-world data cleaning
- Python Intermediate: office automation
- Power Automate Intermediate: approvals and reliable flows
- Excel for Finance Intermediate
Expert: design, control and scale
Expert work is not merely harder formulas. It means designing an approach that another person can check, maintain and use safely. Start with a defined business problem, document assumptions, add reconciliations and test failure cases.
- Build an Excel LAMBDA function library
- Bank statement automation: from raw data to dashboard
- AI Agents and RAG with Python
- Build Your Own LLM course
- Vibe Coding: build tools with AI responsibly
How to use a learning path
- Pick one route and complete one lesson with your own small sample file.
- Keep a copy of your before-and-after output.
- Write down what failed and why; that becomes your next lesson.
- Move up a level when you can explain and repeat the work, not just when you finish a page.
For quick answers, browse the Excel, Automation, ERP and Wacky World sections. Longer pillar guides are being expanded from the short posts previously published on the site.