Excel 2010 - Managing Data
EXL-10-04
Duration
2 hours
Who should attend?
The module will suit all users who need to build and manage lists of data.
Pre-requisites
Attendees should have experience of inputting, amending, copying and moving data and be familiar with the concepts of creating simple calculations. Familiarity with topics covered in modules:
Objectives
You will learn how to: Organise a list of data by sorting and filtering. Extract information based upon certain criteria. Produce subtotals to summarise filtered numerical data.
Course Content
Sort data
Organise lists of data by sorting alphabetically and numerically.
Filter data
Filter a list of data according to certain criteria.
Add sub-totals
se the sub-total function to calculate data in filtered lists.
Group and Outline
Group separate sheets to perform common tasks i.e. format and enter formulae in the same range of cells in separate sheets. Print a selection of sheets.
Conditional Formatting
Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions.
Data consolidation
Use data consolidation to produce totals.
Scenario manager
Create scenarios to present totals based upon increasing/decreasing values.
