York College

Important updates regarding COVID-19 (Coronavirus) and York College plans.
Please see our COVID-19 (Coronavirus) updates page for the latest information and advice.

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

6th September 2019
28th October 2019
18th February 2020
6th April 2020
15th April 2020
28th May 2020

Further Information and Booking

If you're interested in this course then please contact us on:

Business Development Unit,
York College,
Sim Balk Lane,
YO23 2BB

Email: This email address is being protected from spambots. You need JavaScript enabled to view it.

Tel: 01904 770368.

Need Help?

Course Enquiry

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