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: 18 Nov 2020 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 17 Dec 2020 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 11 Jan 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 9 Feb 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 3 Mar 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 6 Apr 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 6 May 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 4 Jun 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 30 Jun 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 27 Jul 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)
Date: 23 Aug 2021 Location: Portsmouth Duration: 1 day Availability: Spaces Member Price: £224.00 (Fees + VAT) Non-Member Price: £264.00 (Fees + VAT)

Enquire about this course.