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

24th February 2017

19th April 2017
13th July 2017

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

Excel-pullquote

Related Courses

Course Enquiry

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