Excel Intermediate
This course is suitable for people who have either attended an introductory Excel course or have a working knowledge of Excel functions that they wish to build on.
This course is delivered over 1 day from 9.30am to 4.30pm
Topics covered will include:
Building Spreadsheets
- Introduction, Outline & Objectives
- Functions and Formulae - Entering and Copying Formulae, Searching for Functions
- Naming Ranges - Creating Named Ranges, Using Names in Movement, Inserting Names in Formulae
- Formatting - Number Formatting, Cell Styles, Copying and Clearing formatting
Printing and Charting
- Printing - Setting up the Print Area, Previewing and Print Settings, [Page Layout] Choices
- Page Breaks - Inserting and Removing Page Breaks, Page Break Preview, Repeating Page Titles, Page Layout View
- Charting - Chart Types, Creating Charts, Customising Charts, [Design] options, [Layout] options, [Format] options
Printing and previewing Charts
What if?
- Conditional Formatting - Adding Rules, Modifying Rules, Date Driven Formatting
- Input Cells - Entering percentage Cells, Absolute ($) cell references
- IF() Function - Arguments, Entering conditions
- SumIf() and Countif()
Counting & totalling with conditions
Look Up Tables
- Using VLOOKUP () - Referencing Tables, Returning Columns
Exact Matching
Organising Worksheets and Workbooks
- Opening Workbooks
- Arranging Workbook Windows
- Creating Workspaces
- Opening Workspaces
- Totalling
- Copy and Paste Special
- Linking Formulae
- Editing Links
- Updating Linked Information
- Trusting Links
- Worksheets
- Inserting Worksheets
- Moving & Copying Worksheets
- Managing Worksheets
- Grouping Worksheets
- Hyperlinks
- Inserting Hyperlinks
- Hyperlink Targets
Lists
- Lists - Selecting Lists, Formatting as Table, [Table Tools]
- Sorting - Single Column Sorting, Multi Column Sorting
- Filtering - Text Filters, Number Filters, Date Filters
- Totals - Inserting Total Row, Adding Totals
- Pivot Tables - Creating Pivot Table, Adding Rows, Columns and Values, Manipulating Elements
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
Fee:
£110
Next Course Dates
Next course dates (Utilising laptops):
27/03/2025
29/04/2025
19/05/2025
16/06/2025
15/07/2025
06/10/2025
04/11/2025
01/12/2025
19/01/2026
16/02/2026
24/03/2026
20/04/2026
19/05/2026
15/06/2026
14/07/2026
Surviving to Thriving
Courses for Adults
Short courses
Subject Area
Business & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 day
Level
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
Variable
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
HTQ Higher National Certificate (HNC) Leadership & Management
University Centre
Courses for Adults
Subject Area
Business & Professional Studies
Study Mode
Part-time
Start Date
September 2025
Duration
2 years part-time
Level
Level 4
Excel Advanced
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
