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: 28 May 2024 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 17 Jun 2024 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 17 Jul 2024 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) | ||
| Date: 14 Aug 2024 | Location: Portsmouth | Duration: 1 day | Availability: Spaces | Member Price: £267.00 (Fees + VAT) | Non-Member Price: £315.00 (Fees + VAT) |