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 Intermediate

Subject Area
Business & Professional Short Courses
Start Date
9 September 2022
Additional Start Date
24 October 2022
Additional Start Date
15 November 2022
Additional Start Date
14 February 2023
Additional Start Date
14 March 2023
Additional Start Date
3 April 2023
Additional Start Date
20 June 2023
Additional Start Date
18 July 2023
Study Mode
Full cost
1 Day
Individual cost: £100.00

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 - 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
Tel: 01904 770368 option 1

Next Course Dates

09/09/2022 (utilising PCs)

24/10/2022 (utilising PCs)

15/11/2022 (utilising laptops)

14/02/2023 (utilising PCs)

14/03/2023 (utilising laptops)

03/04/2023 (utilising PCs)

20/06/2023 (utilising laptops)

18/07/2023 (utilising PCs)

Other similar courses
These other courses may be more suited to your interests or needs
Business & Professional Short Courses department
Short courses
Excel Advanced - Campus@Northallerton
Short courses
Excel Intermediate - Campus@Northallerton
Short courses
Introduction to Excel - Campus@Northallerton
Short courses
Microsoft Power BI
Short courses
Time Management
Short courses
Introduction to Coaching
Short courses
Dealing with Anger and Conflict
Short courses
NEBOSH National General Certificate
Short courses
IOSH Managing Safely
Short courses
Time Management - Campus@Northallerton
Short courses
Effective Recruitment - Campus@Northallerton
Short courses
Effective Recruitment
Short courses
Minutes and Agendas
Short courses
Customer Service Excellence
Short courses
Presentation Skills
Short courses
Microsoft Word Advanced
Short courses
Microsoft Office365 for Homeworkers
Short courses
Excel Advanced
Short courses
Excel Introduction
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