Microsoft Excel Intermediate

PET002090

Use functions of Excel to automate and manipulate your data

Who is it for?

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

Business benefits
  • Increase productivity through the use of functions to automate calculations
  • Structure segmentation and linking of data into relevant groups for easy analysis
  • Reduce manual data entry of everyday tasks
Course overview
  • Using date and time functions
  • Linking data across spreadsheets
  • Subtotalling
  • Using Excel as a database
  • 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  
11 November 2019 Portsmouth 1 day £224.00 £264.00 Spaces Book
12 December 2019 Portsmouth 1 day £224.00 £264.00 Spaces Book
9 January 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
3 February 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
3 March 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
1 April 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
30 April 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
27 May 2020 Portsmouth 1 day £224.00 £264.00 Spaces Book
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
11 November 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
12 December 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
9 January 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
3 February 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
3 March 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
1 April 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
30 April 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: Spaces
Book
27 May 2020
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £224.00
  • Non-member +VAT: £264.00
  • Availability: 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