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;

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