Course Details
Microsoft Excel 3
24 Aug 2011
Professional Development
Computer Skills / Applications
Auckland Chamber of Commerce
Auckland Chamber of Commerce, Level 1, 100 Mayoral Drive, Auckland
Half Day
9.00am to 12.30pm
9.00am to 12.30pm
$200.00
Members $200 +GST / Non-members $300.00 +GST
Members $200 +GST / Non-members $300.00 +GST
This course is aimed at people who analyse and report on large data lists – usually extracted from in house databases and then imported into Excel.
By the end of this course, participants should be able to confidently:
Work with data imported into Excel from an external source
Prepare data so that it’s fit for analysis and reporting
Extract and match data using Lookup functions
Create and work with Named ranges
Analyse and filter data using Advanced Filter commands and the Table feature
Create powerful reports using Pivot Tables and Pivot Charts
By the end of this course, participants should be able to confidently:
Work with data imported into Excel from an external source
Prepare data so that it’s fit for analysis and reporting
Extract and match data using Lookup functions
Create and work with Named ranges
Analyse and filter data using Advanced Filter commands and the Table feature
Create powerful reports using Pivot Tables and Pivot Charts
Sharyn Baine