Microsoft Excel 2003 Intermediate
Duration: ONE DAY
Who is it for?
All users who are required to produce complex analysis of data.
Objectives
· Manipulate data using the built-in functions
· Sort and match data between two different data sets
· Use ‘Lookup’ features.
Course Outline
· Using multiple worksheets
· Import external data
· Using the hide and protect options
· Text manipulation functions
· Using the group and outline tools
· Using ‘Lookup’ functions
· Using the ‘IF’ function
· Building advance graphs
· Conditional formatting.
You can also