Award Crest
York College

Programme Content

For those who have a basic grounding in Microsoft Excel and have already completed the Excel Intermediate course this course will provide you with the knowledge and skills to use MS Excel at an advanced level.

To get the most out of this course, you will need to have completed our entry-level Microsoft Excel course or have the equivalent experience of this extremely popular software.

Course Content

Content includes:

  • Building Spreadsheets
  • Functions and Formulae, Naming Ranges, Data Validation, Formula Auditing
  • What if Analysis
  • Input Cells, Scenarios, Goal Seeking, Data Tables
  • Lookups
  • Numeric and Text Lookups, Index and Match Functions,
  • Importing CSV files
  • Pivot Tables, Charts and Macros
  • Pivot Tables, Filtering, Slicers, Pivot Charts, Macros, Running Macros, Editing Macros
  • Delivering Workbooks
  • Workbook Protection, Templates, Excel Options

Programme Delivery and Costs

This course will take place at York College from 9.30 am – 4.30 pm

Price: £100.00 per delegate

Next Course Dates

2017 – 5th September and 3rd November

2018 – 4th January, 13th February, 30th May and 16th July

Further Information and Booking

Business Development Unit, York College, Sim Balk Lane, York, YO23 2BB
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Tel: 01904 770368

Course Enquiry

Please type your full name.
Invalid email address.
Please tell us about your enquiry