Technical Skills / Computer Applications, Software and Infrastructure

Microsoft Excel Intermediate

PET002090

Optimise functions to automate and analyse data

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 Macros
  • XLOOKUP *New in Office 365

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: 23 Aug 2021 Location: Portsmouth Duration: 1 day Availability: Fully Booked Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 14 Sep 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 15 Oct 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 15 Nov 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 14 Dec 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 12 Jan 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 10 Feb 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 15 Mar 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 11 Apr 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 9 May 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 17 Jun 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 18 Jul 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)
Date: 24 Aug 2022 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £220.00 (Fees + VAT) Non-Member Price: £259.00 (Fees + VAT)

Enquire about this course.

Related news, insights and events