Microsoft Data Analysis

So you know how to use Excel. Quick and to the point this course will demonstrate how to get more out of your data!

Quickly analyse data in excel and make sense of large amounts of information

»Overview

Pivot Tables and Pivot Charts
Summarising data
Using Sorting and filtering techniques including advanced filtering
Database Functions in Excel to SUM and analyse data
Using Lookup functions – VLOOKUP, HLOOKUP
Grouping and Outlining a Worksheet
Linking and importing data with ODBC
Exporting data from applications
Using Solver
Using Scenario’s

» Who should attend?

Attendees should be proficient in the use of Excel with basic functions such as SUM, drag and drop and formatting a spreadsheet.

» Prerequisites
None

» Assessment
On completion of this course, attendees will be provided with a Certificate of Participation.

Can't attend? Order course on DVD for $199 (Excel 2007 Advanced DVD and manual)

» Dates
Please visit our timetable for current dates.

» Registration
To register for this course please click here.

» More Information
If you require more information please don't hesitate to contact us.