Description
COURSE OBJECTIVE:
This online course will provide you with the skills to be able to
summarise data using multiple calculations and format data that meets
specific conditions.
COURSE FORMAT:
The course involves explanation, demonstration and hands-on practice,
working through exercises that build on your existing skills and
increase the functionality of spreadsheets.
PREREQUISITES:
Participants should have a sound knowledge of Excel and be able to
apply a simple filter, sort data, create and understand basic formula.
To gain these skills we recommend that you attend the following courses
first:-
Excel Data Lists Part 2 (for sorting & filtering)
Excel Formula Part 1 (to learn basic formula & functions)
CONTENT
• Apply subtotals to a data list without writing the formula
• Create an automatic and manual outline to expand/collapse columns/rows
• Use conditional formatting to electronically highlight data
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
