Course Outline

Course name: Excel Intermediate 2003

Price: $269.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

Volume discounts
1 booking no discount 2 or 3 bookings 5% discount 4 bookings 10% discount 5 or more 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).