Objectives
The aim of this course is to have the participant `up and running' immediately following a one day intermediate programme based upon their existing skills and future needs. At the end of the course the participant should be able to understand basic formulae in more detail, print and manage large spreadsheets more easily and create simple graphs.
Refresher of the Basics
- Tips for Creating Spreadsheets
- Basic Formulae / Functions
- Absolute References ($)
Names
- Naming Cells
- Editing and Deleting
Tips for Working with Large Spreadsheets
- Freezing Screen Titles
- Splitting Windows
- Displaying Multiple Sheets / Files on Screen
Worksheet and File Linking
- Creating Simple Links
- 3D Referencing
- Consolidation
- Hyperlinks
- Links to other Programs
Page Setup Options
- Headers and Footers
- Repeat Headings for Printing
- Scaling
- Page Break Preview
- Setting Print Areas
List Data
- Sorting a List
- Filters
Charts
- Creating, Formatting and Editing Basic Charts
- Sparklines