Technical Skills / Computer Applications, Software and Infrastructure
Microsoft Excel Intermediate
PET002090
Course overview
Ideal for those with a good knowledge of Excel, who are responsible for the analysis and manipulation of data to automate spreadsheets.
- Using date and time functions
- Linking data across spreadsheets
- Subtotalling
- Sorting and filtering data
- Writing Logical Functions
- Lookup tables
- Introduction to Pivot Tables
Course benefits
Increased productivity using functions to automate calculations be able to structure data allowing easy analysis, to reduce manual data entry and errors from everyday tasks.
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: 18 Nov 2024 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 3 Dec 2024 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 13 Jan 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 13 Feb 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 14 Mar 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 15 Apr 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 12 May 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 19 Jun 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 15 Jul 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 11 Aug 2025 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) |