Excel Advanced
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:
- 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
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:
Fee:
£110
Next Course Dates
Next course dates:
14/04/2025
3/06/2025
17/07/2025
07/10/2025
02/12/2025
17/02/2026
21/04/2026
16/06/2026
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.
Emergency First Aid at Work
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
March 2026
Duration
1 Day
Level
Level 2 Mental Health First Aid
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
November 2025
Duration
1 Day
Level
Basic Life Support with Automated External Defibrillator (AED)
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
February 2026
Duration
1 Day
Level
Power Up Your LinkedIn
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
February 2026
Duration
1 Day
Level
Managing Microsoft Teams & SharePoint
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
March 2026
Duration
1 Day
Level
Intro to Microsoft Office 365 for Business
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
November 2025
Duration
1 Day
Level
Team Dynamics
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
February 2026
Duration
1 Day
Level
Problem Solving with Assertiveness to be an Effective Leader
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
February 2026
Duration
1 Day 9.30am - 4.30pm
Level
Microsoft Word Advanced
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
June 2026
Duration
1 Day
Level
Be a Mindset Detective - For Leaders, Managers & Supervisors
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 day
Level
Microsoft Word Intermediate
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 day
Level
Unconscious Bias, Diversity and Inclusion
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
May 2025
Duration
1/2 day
Level
Social Media Basics for your Business
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
April 2025
Duration
1 day
Level
Facilitation Skills
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
June 2025
Duration
1 day
Level
Email Etiquette
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1/2 a day
Level
Disciplinary and Investigation skills training for Managers
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
May 2025
Duration
1 day
Level
Esports 101: An Industry for the Future
Courses for Adults
Subject Area
Business & Professional Studies, Digital & Media, Sport & Uniformed Service
Study Mode
Part-time
Start Date
January 2025
Duration
8 Weeks
Level
Microsoft Power BI
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
CIPD Associate Diploma in People Management Level 5
Courses for Adults
Subject Area
Business & Professional Studies
Study Mode
Part-time
Start Date
January 2025
Duration
36 Weeks
Level
Level 5
CIPD Certificate in People Practices Level 3
Courses for Adults
Subject Area
Business & Professional Studies
Study Mode
Part-time
Start Date
September 2024
Duration
36 Weeks
Level
Level 3
Introduction to Coaching
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 day
Level
SEG Level 2 Award in Progression (Pre-Access and Adult)
Courses for Adults
Subject Area
Art & Design, Business & Professional Studies, English, Health & Social Care, Humanities & Social Sciences, Mathematics, Science
Study Mode
Part-time
Start Date
April 2025
Duration
10 Weeks
Level
Level 2
BA (Hons) Business Management (Top-up)
University Centre
Courses for Adults
Subject Area
Business & Professional Studies
Study Mode
Full-time
Start Date
September 2025
Duration
1 Year full-time, 2 Years part-time
Level
Level 6
Excel Intermediate
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
Excel Introduction
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
April 2025
Duration
1 Day
Level
Managing Difficult Conversations
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
-
Duration
-
Level
Introduction to Management and Supervisory Skills
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
2 Days
Level
