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
June 2023
Study Mode
Full cost
Duration
1 Day
Fee
See Further Information and Booking
Next Start Date
20th June 2023

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:

From August 2022 - £100

From August 2023 - £110

Next Course Dates

(Utilising laptops)

05/06/2023 (Campus@Northallerton)

20/06/2023

10/07/2023

17/07/2023

30/10/2023

31/10/2023

23/01/2024

27/02/2024

25/03/2024

05/04/2024

07/05/2024

03/06/2024

04/07/2024

05/07/2024

Other similar courses
These other courses may be more suited to your interests or needs
Business & Professional Short Courses department
Short courses
Intermediate Management and Supervisory Skills
Short courses
Microsoft SharePoint
Short courses
Social Media for your Small Business - Campus@Northallerton
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
Introduction to Coaching
Short courses
NEBOSH National General Certificate
Short courses
IOSH Managing Safely
Short courses
Time Management - Campus@Northallerton
Short courses
Effective Recruitment
Short courses
Presentation Skills
Short courses
Microsoft Office365 for Homeworkers
Short courses
Excel Advanced
Short courses
Excel Introduction
Short courses
Performance Management - Campus@Northallerton
Short courses
Managing Difficult Conversations
Short courses
Introduction to Management and Supervisory Skills
Short courses
Assertiveness
How can we help?
I am a
Interested in
Show me