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
March 2024
Study Mode
Full cost
Duration
1 Day
Level
-
Fee
£110
Next Start Date
25th March 2024

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):

25/03/2024

5/04/2024

7/05/2024

3/06/2024

4/07/2024

5/07/2024

7/10/2024

5/11/2024

5/12/2024

27/1/2025

25/02/2025

27/03/2025

29/04/2025

19/05/2025

16/06/2025

15/07/2025

Other similar courses
These other courses may be more suited to your interests or needs
Business & Professional Short Courses department

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

Microsoft Word Intermediate

Short courses

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

Unconscious Bias, Diversity and Inclusion

Short courses

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

Social Media Basics for your Business

Short courses

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

Introduction to MS Teams in Office 365

Short courses

Facilitation Skills

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

June 2025

Duration

1 day

Level

Facilitation Skills

Short courses

Email Etiquette

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

March 2025

Duration

1/2 a day

Level

Email Etiquette

Short courses

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

Disciplinary and Investigation skills training for Managers

Short courses

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 and Blogging Tips

Short courses

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

Social Media Strategy Building with Google Business Profile

Short courses

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

18th Edition

A Level

Access to HE

Short courses

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

Intermediate Management and Supervisory Skills

Short courses

Microsoft SharePoint

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

Variable

Duration

1 Day

Level

Microsoft SharePoint

Short courses

Microsoft Power BI

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

Variable

Duration

1 Day

Level

Microsoft Power BI

Short courses

Introduction to Coaching

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

May 2024

Duration

1 day

Level

Introduction to Coaching

Short courses

IOSH Managing Safely

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

July 2024

Duration

3 days

Level

IOSH Managing Safely

Short courses

Presentation Skills

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

June 2024

Duration

2 Days

Level

Presentation Skills

Short courses

Microsoft Office365 for Homeworkers

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

June 2024

Duration

1 Day

Level

Microsoft Office365 for Homeworkers

Short courses

Excel Advanced

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

March 2024

Duration

1 day

Level

Excel Advanced

Short courses

Excel Introduction

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

April 2024

Duration

1 Day

Level

Excel Introduction

Short courses

Managing Difficult Conversations

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

-

Duration

-

Level

Managing Difficult Conversations

Short courses

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

Introduction to Management and Supervisory Skills

Short courses

Assertiveness

Short courses

Subject Area

Business & Professional Short Courses

Study Mode

Full cost

Start Date

November 2024

Duration

1 Day

Level

Assertiveness

Short courses