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

  • Monday 16th December 2024
  • Tuesday 28th January 2025
  • Monday 24th February 2025
  • Tuesday 25th March 2025
  • Thursday 24th April 2025
  • Thursday 24th April 2025
  • Thursday 22nd May 2025
  • Monday 30th June 2025
  • Monday 28th July 2025
  • Friday 29th August 2025
  • Thursday 25th September 2025
  • Tuesday 28th October 2025
  • Friday 28th November 2025
  • Monday 15th December 2025
Back to all Courses