Excel Series Module 4: Features that go beyond the general user level

Having covered some fundamental spreadsheet methods and techniques in the previous steps, we start to look at some of the Excel features that will be useful to Creator level users. In this step, you will cover Excel’s built-in error checking and how to find and trace the source of errors together with the importance of considering the design of your spreadsheets and including documentation. You will also learn how to insert and use PivotTables to create summaries of data.

This step of the Excel series starts to move beyond the General User level of the ICAEW Spreadsheet Competency Framework towards the Creator level.

Learning outcomes

  • How Excel alerts you to potential errors, and how it doesn’t
  • Using the Formula Auditing tools to identify and trace issues
  • Key spreadsheet design concepts and principles
  • How to document your spreadsheet to make it easier for others to use and maintain
  • How to start using PivotTables to summarise data
Price: £30.00