Microsoft Excel Advanced

PET002096

Build powerful business intelligence using Excel advanced features

Who is it for?

This course accelerates the skills of regular Excel users, to enable management reporting on a wide range of business data scenarios.

Business benefits

To be able to accurately forecast business decisions based on reliable data. To give clear visibility of KPIs and budgets, reducing defects by managing inputs.

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  
26 August 2020 Portsmouth 1 day £229.00 £270.00 Spaces Book
30 November 2020 Portsmouth 1 day £229.00 £270.00 Spaces Book
23 February 2021 Portsmouth 1 day £229.00 £270.00 Spaces Book
18 May 2021 Portsmouth 1 day £229.00 £270.00 Spaces Book
27 August 2021 Portsmouth 1 day £229.00 £270.00 Spaces Book
26 August 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £229.00
  • Non-member +VAT: £270.00
  • Availability: Spaces
Book
30 November 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £229.00
  • Non-member +VAT: £270.00
  • Availability: Spaces
Book
23 February 2021
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £229.00
  • Non-member +VAT: £270.00
  • Availability: Spaces
Book
18 May 2021
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £229.00
  • Non-member +VAT: £270.00
  • Availability: Spaces
Book
27 August 2021
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £229.00
  • Non-member +VAT: £270.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