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