Spreadsheets

A Course for intermediate users

Get the spreadsheet to perform your calculations! Gain the skills and knowledge of Excel to enter, edit and present numerical data using formulae and basic formatting tools and to produce and format a variety of charts and graphs. Gain confidence in using complex functions and formulae to analyse, interpret data and to predict future value and project results.

Activities

1 - Getting Started
2 - Laying out a basic format
3 - Intro - Creating Graphs
4 - Introduction to Formulea
5 - Formating a Worksheet
6 - Relative & Absolute references
7 - Multiple Worksheets
8 - Using Form Elements
9 - Report on Spreadsheets
10 - Sorting & Managing Data
11 - Health & Safety
11 - Download Start File
12 - Adopting Good Practices