Your browser is unsupported and may have security vulnerabilities! Upgrade to a newer browser to experience this site in all it's glory.
Skip to main content
Short courses

Excel Advanced

Subject Area
Business & Professional Short Courses
Start Date
25 October 2022
Additional Start Date
29 November 2023
Additional Start Date
15 February 2023
Additional Start Date
28 March 2023
Additional Start Date
4 April 2023
Additional Start Date
11 April 2023
Additional Start Date
31 May 2023
Additional Start Date
1 June 2023
Additional Start Date
4 July 2023
Additional Start Date
10 July 2023
Additional Start Date
17 July 2023
Study Mode
Full cost
Duration
1 Day
Fee
Individual cost: £100.00

This course is suitable 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.

This course is delivered over 1 day from 9.30am to 4.30pm

Topics covered will include:

  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

Further Information and Booking

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

Business Partnerships, York College, Sim Balk Lane, York, YO23 2BB
Email: businesspartnerships@yorkcollege.ac.uk
Tel: 01904 770368 option 1

Next Course Dates

25/10/2022 (utilising PCs)

29/11/2022 (utilising laptops)

15/02/2023 (utilising PCs)

28/03/2023 (utilising laptops)

04/04/2023 (utilising PCs)

11/04/2023 (utilising PCs)

31/05/2023 (utilising PCs)

01/06/2023 (utilising PCs)

04/07/2023 (utilising laptops)

10/07/2023 (utilising PCs)

17/07/2023 (utilising PCs)

This is the second Excel course I have done at York College. Really useful content delivered in a user-friendly way. The Trainer was very engaging and related content to the workplace.
- Student Feedback
Other similar courses
These other courses may be more suited to your interests or needs
Business & Professional Short Courses department
Short courses
Introduction to Coaching
Short courses
Dealing with Anger and Conflict
Short courses
NEBOSH National General Certificate - Campus@Northallerton
Short courses
IOSH Managing Safely
Short courses
IOSH Managing Safely - Campus@Northallerton
Short courses
Time Management - Campus@Northallerton
Short courses
Effective Recruitment
Short courses
Effective Recruitment - Campus@Northallerton
Short courses
Minutes and Agendas
Short courses
Customer Service Excellence
Short courses
Presentation Skills
Short courses
Microsoft Word Advanced
Short courses
Microsoft Power BI
Short courses
Microsoft Office365 for Homeworkers
Short courses
Excel Intermediate
Short courses
Excel Introduction
Short courses
Social Media Basics for your Business - Campus@Northallerton
Short courses
Social Media Basics for your Business
Short courses
Performance Management - Campus@Northallerton
Short courses
Performance Management
Short courses
Managing Difficult Conversations
Short courses
Managing Change
Short courses
Introduction to Management and Supervisory Skills
Short courses
Assertiveness and How to Be a Better Manager
Short courses
HABC Award in Supervising Food Safety Level 3
Short courses
Highfield Award in Food Safety Level 2
How can we help?
I am a
Interested in
Show me