Data and AI Training

Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data

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)