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:
26/03/2024
6/06/2024
19/07/2024
19/11/2024
28/01/2025
14/04/2025
3/6/2025
17/7/2025
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.
Microsoft Word Intermediate
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Level 1
Unconscious Bias, Diversity and Inclusion
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2025
Duration
1/2 day
Level
Level 1
Social Media Basics for your Business
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
April 2025
Duration
1 day
Level
Level 5
Introduction to MS Teams in Office 365
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Facilitation Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2025
Duration
1 day
Level
Email Etiquette
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2025
Duration
1/2 a day
Level
Disciplinary and Investigation skills training for Managers
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2025
Duration
1 day
Level
Social Media Strategy Building and Blogging Tips
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
1 day
Level
Social Media Strategy Building with Google Business Profile
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
1 day
Level
18th Edition
A Level
Access to HE
Short courses
Subject Area
Business & Professional Short Courses, Digital Technologies
Study Mode
Apprenticeship, Various Available
Start Date
Variable
Duration
TBC
Level
Level 1, Level 2
Intermediate Management and Supervisory Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2024
Duration
2 Days
Level
Microsoft SharePoint
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
Microsoft Power BI
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
Introduction to Coaching
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
May 2024
Duration
1 day
Level
IOSH Managing Safely
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
July 2024
Duration
3 days
Level
Presentation Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
2 Days
Level
Microsoft Office365 for Homeworkers
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
June 2024
Duration
1 Day
Level
Excel Intermediate
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
March 2024
Duration
1 Day
Level
Excel Introduction
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
April 2024
Duration
1 Day
Level
Managing Difficult Conversations
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
-
Duration
-
Level
Introduction to Management and Supervisory Skills
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
July 2024
Duration
2 Days
Level
Assertiveness
Short courses
Subject Area
Business & Professional Short Courses
Study Mode
Full cost
Start Date
November 2024
Duration
1 Day
Level
