Microsoft Excel Advanced

PET002096

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.

Business benefits
  • Accurate business decisions and forecasting based on reliable data
  • Clear visibility of KPIs, budgets and progress towards objectives
  • Reduce data defects by managing input and embedding prompts for use
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

Sponsored option

This course is available as a company sponsored event, delivered at a location, date and time which is mutually agreed. The fees for this event vary depending on the location, number attending and the level of training required and the degree of customisation. Please contact us to discuss your requirements.


Next steps


Course dates and fees
Start date Location Duration Member
+VAT
Non-member
+VAT
Availability  
31 January 2019 Portsmouth 1 day £223.00 £263.00 Spaces Book
11 April 2019 Portsmouth 1 day £223.00 £263.00 Spaces Book
13 March 2019 Portsmouth 1 day £223.00 £263.00 Spaces Book
6 June 2019 Portsmouth 1 day £223.00 £263.00 Spaces Book
18 July 2019 Portsmouth 1 day £223.00 £263.00 Spaces Book
29 August 2019 Portsmouth 1 day £223.00 £263.00 Spaces Book
31 January 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £223.00
  • Non-member +VAT: £263.00
  • Availability: Spaces
Book
11 April 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £223.00
  • Non-member +VAT: £263.00
  • Availability: Spaces
Book
13 March 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £223.00
  • Non-member +VAT: £263.00
  • Availability: Spaces
Book
6 June 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £223.00
  • Non-member +VAT: £263.00
  • Availability: Spaces
Book
18 July 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £223.00
  • Non-member +VAT: £263.00
  • Availability: Spaces
Book
29 August 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £223.00
  • Non-member +VAT: £263.00
  • Availability: Spaces
Book

Group discounts are available for this course

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 Corporate Courses courses


Our Courses and Services