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;


22 August 2017
19 September 2017
18 October 2017
16 November 2017
19 December 2017  

 
17 January 2018
22 February 2018
19 March 2018
17 April 2018
23 May 2018
21 June 2018
23 July 2018
21 August 2018


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