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
  • Increased productivity through the use of functions to automate calculations
  • Structured segmentation and linking of data into relevant groups for easy analysis
  • Reduced 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  
19 December 2018 Portsmouth 1 day £218.00 £257.00 Spaces Book
16 January 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
21 February 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
21 March 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
18 April 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
20 May 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
24 June 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
24 July 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
19 August 2019 Portsmouth 1 day £218.00 £257.00 Spaces Book
19 December 2018
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
16 January 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
21 February 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
21 March 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
18 April 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
20 May 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
24 June 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
24 July 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.00
  • Availability: Spaces
Book
19 August 2019
  • Location: Portsmouth
  • Duration: 1 day
  • Member +VAT: £218.00
  • Non-member +VAT: £257.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