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 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:

• Excel techniques for building robust spreadsheets including
  • the use of flexible and versatile functions such as INDEX, XMATCH, FILTER, LET and LAMBDA
  • techniques using dynamic arrays, tables, and named cells
  • data validation and conditional formatting
• The 10 golden rules of spreadsheet design
• Case study: Design and build an Excel model from scratch.
• Case study: Testing your spreadsheet.
• Case study: Build a financial model - includes NPV (discount factors) calculations

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