Zomalex | Data and AI Training
Excel Best Practices Course
Who should attend
People who want to build Excel spreadsheets that are robust, presentable, maintainable, useful and less likely to contain errors.
Learning Objectives
We will learn how to design and build spreadsheets that are readable, robust, and well-tested.
Course Content
The course will cover:
- Use AI to solve hard Excel challenges such as building financial models, and testing spreadsheets.
- The 10 golden rules of spreadsheet design
- Case study: Design and build an Excel model from scratch.
- Case study: Build a financial model - includes NPV (discount factors) calculations
- Advanced formula language techniques e.g. MAP and LAMBDA functions.
- Use Excel Data Tables for scenario analysis
Course Length
1 day
Pre-requisites
Completion of the Excel foundation and intermediate courses.
Snapshots from the course exercises
A clean, well-structured Excel model