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 19th April 2024
  • Thursday 23rd May 2024
  • Thursday 20th June 2024
  • Thursday 18th July 2024
  • Tuesday 27th August 2024
  • Tuesday 24th September 2024
  • Thursday 24th October 2024
  • Tuesday 26th November 2024
  • Monday 16th December 2024