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: 22 Mar 2024 Location: Portsmouth Duration: 1 day Availability: Fully Booked Member Price: £267.00 (Fees + VAT) Non-Member Price: £315.00 (Fees + VAT)
Date: 5 Apr 2024 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £267.00 (Fees + VAT) Non-Member Price: £315.00 (Fees + VAT)
Date: 15 Apr 2024 Location: Portsmouth Duration: 1 day Availability: Fully Booked Member Price: £267.00 (Fees + VAT) Non-Member Price: £315.00 (Fees + VAT)
Date: 20 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)

Enquire about this course.