Microsoft Excel Intermediate

Use the functions of Excel to automate and manipulate your data

Who is it for?

Those with a basic knowledge of Excel who need to analyse, manipulate date and automate spreadsheets.

What will I learn?
  • How to use Excel to analyse or manipulate data
  • Creating flexible spreadsheets using Functions
  • Working more efficiently by recording Macros

Course Details

  • Location: Portsmouth
  • Duration: 1 Day
  • Member: £212
  • Non-Member: £250

All fees subject to VAT

Book this course »
Next steps



Course Overview
  • Using date and time functions 
  • Linking data across spreadsheets
  • Linking data across spreadsheets
  • Subtotalling
  • Using Excel as a database
  • Writing Logical Functions
  • Lookup tables
  • Introduction to Macros

Course Dates
Course commences;


23 July 2018
21 August 2018

Please note the courses after the 21st August 2018 are subject to new prices the new fees are: £218 for members £257 for non-members.

20 September 2018

18 October 2018

15 November 2018

13 December 2018

16 January 2019

21 February 2019

21 March 2019

18 April 2019

20 May 2019

24 June 2019

24 July 2019

19 August 2019

Company Sponsored Option

This course is also available as a company-sponsored option which is for your delegates only, this is a flexible solution and can be tailored to reflect your business needs, delivered on a date, time and place to suit you - please contact us.


Group Discounts

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 Microsoft Word, Excel, PowerPoint, Outlook courses


Our Courses and Services