Zomalex | Data and AI Training

Home | Power BI | Excel | Python | SQL | Gen AI | Contact Us | LBAG | info@zomalex.co.uk

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.

Learning Objectives

You will learn how to design and build spreadsheets that are readable and robust and tested well.

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)

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