Resources
Selected learning materials and articles focused on structured thinking, system design and practical modelling
Courses
Excel Architecture Fundamentals
Introduces structured workbook design and the use of Excel Tables as the foundation for dynamic, maintainable models. The focus is on clarity, consistency, and long-term usability rather than ad-hoc spreadsheet work.
Key Focus Areas
- Structured workbook architecture
- Proper use of Excel Tables
- Clear separation of input, logic, and output
- Consistent formatting and model readability
- Level: Basic
- Prerequisite: Basic Excel knowledge
- Language: English
Advanced Excel Formulas & Model Logic
Explores advanced formula design using Structured References and dynamic combinations. Emphasis is placed on building reusable, transparent logic that scales with larger datasets and more complex workflows.
Key Focus Areas
- Advanced formula structure and nesting
- Structured References and dynamic ranges
- Reusable calculation patterns
- Managing larger datasets with consistency
- Level: Intermediate
- Prerequisite: Understanding of formulas and Excel Tables
- Language: English