This course introduces techniques for enhancing, customising and automating Excel worksheets. It includes tasks such as advanced functions, pivot tables, macros, auditing and analytical tools.

This is an advanced Excel 2010 course. We recommend that you first attend Excel 2010 Intermediate training or make sure that you have an equivalent level of knowledge. 

By the end of this course, you will be able to:

  • Create then use labels and names in a workbook
  • Use the Formula Auditing tools to find and fix formula errors
  • Use the range of Paste Special options
  • Use a variety of Financial functions
  • Perform What-If Analysis on a range of data using Data Tables
  • Use Advanced Filters to view or extract matching records from a list of data
  • Use goal seeking to determine the values required to reach a desired result
  • Create and work with 'what-if' analysis using scenarios
  • Summarise and present information in a Pivot Table report
  • Construct and operate Pivot Tables using some of the more advanced techniques
  • Create recorded macros in Excel
  • Use the macro recorder to create a variety of macros

 

  • Labels And Names
  • Formula Auditing
  • Special Pasting
  • Financial Functions
  • Statistical Functions
  • Data Tables
  • Advanced Filtering
  • Summarising Data
  • Goal Seeking
  • Scenarios
  • Pivot Tables
  • Pivot Table Techniques
  • Pivot Charts
  • Recorded Macros
  • Recorder Workshop