Technical Skills / Computer Applications, Software and Infrastructure

Microsoft Excel Advanced

PET002096

Build powerful business intelligence using Excel advanced features

Course overview

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

  • 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 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 dates and fees

Date
When is it?
Location
Where do I go?
Duration
How long is it?
Availabilty
Remaining space?
Member
Fees + VAT
Non-Member
Fees + VAT
  Book
Add delegate(s)
Date: 30 Nov 2020 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £229.00 (Fees + VAT) Non-Member Price: £270.00 (Fees + VAT)
Date: 23 Feb 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £229.00 (Fees + VAT) Non-Member Price: £270.00 (Fees + VAT)
Date: 18 May 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £229.00 (Fees + VAT) Non-Member Price: £270.00 (Fees + VAT)
Date: 27 Aug 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £229.00 (Fees + VAT) Non-Member Price: £270.00 (Fees + VAT)

Enquire about this course.