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

23rd February 2017

10th April 2017
20th April 2017

31st May 2017
1st June 2017
18th July 2017

19th July 2017

 

Further Information and Booking

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

Excel-pullquote

Related Courses

Course Enquiry

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