Technical Skills / Computer Applications, Software and Infrastructure
Microsoft Excel Advanced
PET002096
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: 31 Aug 2022 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £240.00 (Fees + VAT) | Non-Member Price: £283.00 (Fees + VAT) | ||
Date: 24 Oct 2022 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £252.00 (Fees + VAT) | Non-Member Price: £297.00 (Fees + VAT) | ||
Date: 19 Dec 2022 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £252.00 (Fees + VAT) | Non-Member Price: £297.00 (Fees + VAT) | ||
Date: 14 Feb 2023 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £252.00 (Fees + VAT) | Non-Member Price: £297.00 (Fees + VAT) | ||
Date: 3 Apr 2023 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £252.00 (Fees + VAT) | Non-Member Price: £297.00 (Fees + VAT) | ||
Date: 8 Jun 2023 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £252.00 (Fees + VAT) | Non-Member Price: £297.00 (Fees + VAT) | ||
Date: 14 Aug 2023 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £252.00 (Fees + VAT) | Non-Member Price: £297.00 (Fees + VAT) |