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: £217
  • Non-Member: £256

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;


30 August 2017
27 September 2017
31 October 2017
27 November 2017    

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

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