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

12th April 2019
24th April 2019
28th May 2019
16th July 2019

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.

Course Enquiry

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