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

15th July 2019
17th July 2019

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.

Course Enquiry

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