Description
COURSE OBJECTIVE:
This online course will provide you with the skills to be able to
import data, remove duplicate data, convert text to columns and apply
data validation rules.
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 and sort data.
To gain these skills we recommend that you attend the following course
first:-
Excel Data Lists Part 2 (for sorting & filtering)
CONTENT
• Convert text to columns
• Remove duplicates records (rows)
• Fill data in quickly
• Apply validation rules to prevent certain data input
Duration: 2 hrs
Cost: Free
Suitability: Staff
|
