Description
COURSE OBJECTIVE:
This online course introduces some of Excel’s most useful tools for
organising and analysing data. You will learn how to sort information
into a meaningful order, apply filters to quickly find the records you
need, and work with Excel Tables to manage data more effectively. The
course explores how tables can simplify tasks such as filtering,
formatting and analysing information, helping you work more efficiently
with lists and datasets of any size. These techniques are ideal for
anyone who needs to organise and maintain data in Excel.
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 basic knowledge of Excel and be able to
select cells, enter & edit data, format data and use the cut/copy &
paste technique.
CONTENT
• Sort a data list
• Extract data using filters
• Working with tables
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
