Award Crest
York College

Course Outline

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

 

Programme Delivery & Cost

One full day – 09.30am -16.30pm

Individual price: £100.00

Next Course Dates

16th July 2019

29th August 2019

2nd September 2019

29th October 2019

17th February 2020

19th February 2020

7th April 2020

9th April 2020

26th May 2020

13th July 2020

14th July 2020

Further Information and Booking

If you're interested in this course then please contact us on:

Business Development Unit, York College, Sim Balk Lane, York, YO23 2BB
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Tel: 01904 770368 Option 1

Microsoft excel intermediate case study

Microsoft excel intermediate case study 2

Need Help?

Course Enquiry

Please type your full name.
Invalid email address.
Please tell us about your enquiry
×