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):
5/12/2024
27/1/2025
25/02/2025
27/03/2025
29/04/2025
19/05/2025
16/06/2025
15/07/2025
Raising the Bar
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 day
Level
Be a Mindset Detective
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 day
Level
Microsoft Word Intermediate
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Unconscious Bias, Diversity and Inclusion
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
May 2025
Duration
1/2 day
Level
Social Media Basics for your Business
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
April 2025
Duration
1 day
Level
Introduction to MS Teams in Office 365
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Facilitation Skills
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
June 2025
Duration
1 day
Level
Email Etiquette
Short courses
Subject Area
Business, Tourism & Professional Studies
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, Tourism & Professional Studies
Study Mode
Full cost
Start Date
May 2025
Duration
1 day
Level
Social Media Strategy Building and Blogging Tips
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
July 2025
Duration
1 day
Level
Social Media Strategy Building with Google Business Profile
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
June 2025
Duration
1 day
Level
18th Edition
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Various Available
Start Date
Variable
Duration
TBC
Level
Intermediate Management and Supervisory Skills
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
February 2025
Duration
2 Days
Level
Microsoft Power BI
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
Introduction to Coaching
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
March 2025
Duration
1 day
Level
Microsoft Office365 for Homeworkers
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
May 2025
Duration
1 Day
Level
Excel Advanced
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
November 2024
Duration
1 day
Level
Excel Introduction
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
December 2024
Duration
1 Day
Level
Managing Difficult Conversations
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
-
Duration
-
Level
Introduction to Management and Supervisory Skills
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
January 2025
Duration
2 Days
Level
Assertiveness
Short courses
Subject Area
Business, Tourism & Professional Studies
Study Mode
Full cost
Start Date
Variable
Duration
1 Day
Level
