Download our Directory

Download our Directory

Download our PETA Directory of Training 2016-2017


Download now



Microsoft Excel Advanced

Master Excel to deliver data that makes a big difference

Who is it for?

This course benefits regular Excel users who manage and report a wide range of data scenarios within business. 

What will I learn?
  • How to analyse or summarise data making use of pivot tables
  • Troubleshooting formulas and using ‘If’ statements
  • Understand how to import data from other applications

Course Details

  • Location: Portsmouth
  • Duration: 1 Day
  • Member: £211
  • Non-Member: £249

All fees subject to VAT

Book this course »
Next steps



Course Overview
  • Importing and exporting data
  • Database functions and data validation
  • Excel Tables
  • Creating Pivot Tables
  • Input messages and error alerts
  • Consolidating data techniques
  • Trace connections and errors between formulas 
  • “What if” scenarios and analysis
  • Templates and custom formatting

Course Dates
Course commences;

31 January 2017
28 February 2017
29 March 2017
26 April 2017
30 May 2017
27 June 2017
31 July 2017
30 August 2017

Company Sponsored Option

This course is also available as a company sponsored option which is for your delegates only, this is a flexible solution and can be tailored to reflect your business needs, delivered on a date, time and place to suit you - please contact us.


Group Discounts

Take advantage of these discounts when booking this course;

5% off for 2-3 people
8% off for 4-5 people
12% off for 6 or more people

« All Microsoft Word, Excel, PowerPoint, Outlook courses


Our Courses and Services