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

Price

£100.00 per delegate

Next Course Dates

PC’s:

27/10/2020

15/02/2021

30/03/2021

09/04/2021

01/06/2021

06/07/2021

19/07/2021

LAPTOP’s (please ensure you bring a fully charged laptop):

06/10/2020

17/05/2021

To book onto this programme please call: 01904 770368 Option 1 or email This email address is being protected from spambots. You need JavaScript enabled to view it.

Need Help?

Course Enquiry

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