York College

Programme Content

For those who have a basic grounding in Microsoft Excel and have already completed the Excel Intermediate course or have the equivalent experience of this extremely popular software.  It explores the more complex functionality offered by Microsoft Excel.

Course Content

Content includes

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

Delivery and Attendance

This course will take place at York College.

Full day course - 9.30am to 4.30pm


£100.00 per delegate.

Next Course Dates

27th October 2021

28th October 2021

25th February 2022

13th April 2022

20th April 2022

30th May 2022

13th July 2022

Need Help?

Course Enquiry

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