Microsoft Excel Intermediate

PET002090

Optimise functions to automate and analyse data

Who is it for?

Ideal for those with a good knowledge of Excel, who are responsible for the analysis and manipulation of data to automate spreadsheets.

Business 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 overview
  • Using date and time functions
  • Linking data across spreadsheets
  • Subtotalling
  • Sorting and filtering data
  • Writing Logical Functions
  • Lookup tables
  • Introduction to Macros

Sponsored option

This course is available as a company sponsored event, delivered at a location, date and time which is mutually agreed. The fees for this event vary depending on the location, number attending and the level of training required and the degree of customisation. Please contact us to discuss your requirements.


Next steps



Course dates and fees
Start date Location Duration Member
+VAT
Non-member
+VAT
Availability  
22 June 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
22 July 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
18 August 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
22 June 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
22 July 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
18 August 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book

Group discounts are available for this course

Take advantage of these discounts when booking this course;

  • 5% off for 2-3 people
  • 8% off for 4-5 people
  • 12% off for 6 or more people
« All Corporate Courses courses


Our Courses and Services