York College

York College National Careers Week Banner

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

1st April 2021

20th May 2021

21st June 2021

5th July 2021

Further Information and Booking

If you are interested in this course then please contact us:

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

Need Help?

Course Enquiry

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