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 (for this session you will require your own laptop)

4th June 2021

21st June 2021 (for this session you will require your own laptop)

5th July 2021

9th 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