Course Outline

Course name: Excel Intermediate 2007

Price: $299.00 (Includes GST)

Duration: 1 day

Summary

This course goes beyond the basics and focuses on more in-depth examples of formulas, formatting and charting. How to work with larger spreadsheets more efficiently and how to analyse raw data are some of the important features covered. Many shortcuts and time-saving techniques used in creating multi-level spreadsheets are also covered.

Register for this course

Course start date	Course end date	Location	Mode	Info/register
Tue, 17/08/2010	Tue, 17/08/2010	Balcatta (Rm 1)	Day	Info/register
Fri, 10/09/2010	Fri, 10/09/2010	Balcatta (Rm 1)	Day	Info/register
Thu, 14/10/2010	Thu, 14/10/2010	Balcatta (Rm 1)	Day	Info/register
Mon, 15/11/2010	Mon, 15/11/2010	Balcatta (Rm 1)	Day	Info/register
Thu, 23/12/2010	Thu, 23/12/2010	Balcatta (Rm 1)	Day	Info/register

Volume discounts
1 place only - no discount 2 places 5% discount 3 places 10% discount Over 3 places 20% discount

Course Details

This course is appropriate for those who are already familiar with the basic operations of Excel and are looking to improve their skills and move into the more advanced features Excel has to offer.

By the end of this course you will be able to:

Apply more advanced charting features.
Use absolute references in formulas.
Assign name ranges to make formulas easier.
Group & outline large data to summarise it easily.
Use sheets, calculate across sheets and link to files.
Sort and arrange data.
Create SubTotals from raw data.
Create Pivot Tables from raw data.
Create ‘What If’ formulas (Goal Seek and Solver).