Home | Power BI | Excel | Python | SQL | Visualising Data | Generative AI
Excel Best Practices Course
Who should attend
People who want to build Excel spreadsheets that are robust, presentable, maintainable, useful and least likely to contain errors.
Course Length
1 day
Learning Objectives
You will learn how to design and build spreadsheets that are readable and robust and tested well.
Pre-requisites
Completion of the Excel foundation and intermediate courses.
Course Content
Here is a set of possible topics. We will not cover them all.
- Design and build an Excel model from scratch. Apply best practices (case study).
- The 10 golden rules of spreadsheet design
- How to test your spreadsheet. (case study)
- Data presentation
- Build a financial model
- NPV (discount factors) calculations
- Sensitivity Analysis
- Scenario Modelling
- Monte Carlo simulations (if time allows and there is interest)