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: 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)
Date: 9 Sep 2024 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £267.00 (Fees + VAT) Non-Member Price: £315.00 (Fees + VAT)
Date: 9 Oct 2024 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £267.00 (Fees + VAT) Non-Member Price: £315.00 (Fees + VAT)
Date: 7 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)

Enquire about this course.