Excel Charts, Pivot Tables & Macros

This course is aimed at delegates who are using Excel to maintain lists of data and carry out some form of analysis on them. It is designed for people who need to know how to fully understand and manipulate lists to maximum effect. This will be done by covering data manipulation and filters, the more advanced mathematical and statistical analysis of data and ultimately the use of Pivot Tables, Macros and Charts within Excel.

 

One Day Course 

Course Outline (PDF)

Course Objectives:

• For delegates who use Excel to store and analyse data instead of Microsoft Access.
• To create and maintain a list of data that makes lists work for you.
• Use Filters to quickly select sets of data within lists.
• Manipulate data into useful elements e.g. separate data from a single cell.
• See the magic of Pivot Tables and the speed of which they analyse and present statistical information.

Excel Green Logo Microsoft. Green book with white x in centre
Price: £185 + vat

Dates

  • Friday 24th July 2026
  • Tuesday 25th August 2026
  • Wednesday 30th September 2026
  • Tuesday 20th October 2026
  • Friday 27th November 2026
  • Wednesday 16th December 2026
  • Thursday 28th January 2027
  • Thursday 25th February 2027
  • Wednesday 31st March 2027
  • Wednesday 28th April 2027
  • Thursday 27th May 2027
  • Wednesday 30th June 2027
  • Thursday 29th July 2027
  • Tuesday 31st August 2027
  • Thursday 30th September 2027
  • Thursday 28th October 2027
  • Tuesday 30th November 2027
  • Tuesday 21st December 2027
Back to all Courses