Excellent resource for Australian document templates
|
Course Outline
Course name: Excel Intermediate 2003
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 |
|---|
| Wed, 8/09/2010 |
Wed, 8/09/2010 |
Balcatta (Rm 2) |
Day |
Info/register |
| Mon, 4/10/2010 |
Mon, 4/10/2010 |
Balcatta (Rm 2) |
Day |
Info/register |
| Tue, 2/11/2010 |
Tue, 2/11/2010 |
Balcatta (Rm 2) |
Day |
Info/register |
| Thu, 2/12/2010 |
Thu, 2/12/2010 |
Balcatta (Rm 2) |
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).
|