Microsoft Excel 2003

Course Overview

The skills and knowledge covered in this course are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts and graphs, and managing small lists.

AOT Computer Training is a premier IT Training and Education solution provider specialising in customised end user training programs. AOT currently delivers training national and International with the capacity and infrastructure to deliver to over 100 countries.

At the completion of this courseware participants will be able to:

• understand the origins of and basic uses for spreadsheets
• start Microsoft Excel, navigate work courses, and exit correctly
• create, modify, save, and close a simple work course
• select ranges of cells in a work course
• create formulas that perform calculations in a work course
• copy and fill data in a work course
• understand and use absolute referencing in a work course
• format cells in a work course
• adjust the sizing of columns and rows in a work course
• create and work with functions in a work course
• sort data in lists in a work course
• print data in a work course
• use the various printing features to produce a variety of reports
• use the search and replace features in a work course
• edit data in a work course
• create a variety of charts (graphs) in Excel
• access and use the help system and work safely with your computer.
• 
  

This course is primarily designed for people who need to know how to use Microsoft Excel 2003. It is ideal for people who work in offices, for clubs or charities where there is a requirement to produce reports, budgets, lists, and the like.

Delivery Options

AOT specialises in delivering a complete training solution to corporate clients to improve workplace productivity.

This type of training is designed for the corporate market only. An expert trainer is provided to deliver high end personal training session’s using one of the options listed.

Option One

AOT will deliver face to face training for your company at your office location for a set daily price for any of our courses.

• Capital Cities and most regional areas - $3200 per day
• Book a minimum of 2 consecutive days and AOT will deliver anywhere in Australia for $3200 per day.
  * This price is based on a maximum of 10 people, additional numbers are subject to negotiation * Some conditions may apply

Option Two

• AOT will deliver face to face training in any location using our mobile computer lab for a set daily price for any of our courses.
  We can setup a training centre outside of your normal office environment that is close and convenient to you.
• Capital Cities and most regional areas - $3895 per day
• Book a minimum of 2 consecutive days and AOT will delivery anywhere in Australia for $3895 per day.
  * This price is based on a maximum of 10 people, additional numbers are subject to negotiation * Some conditions may apply

Our Guarantee of quality

• AOT is a Registered Training Organisation and is a Microsoft Certified Partner and testing centre.
  We have been audited by the governing bodies in all our training and assessment methodologies and principles. This allows us to guarantee you that AOT will deliver high quality training.

Course – Breakdown for Project

 

Spreadsheets

1. How Spreadsheets Work
2. Spreadsheet Characteristics
3. Spreadsheet Functionality
4. The Appropriateness of
Spreadsheets

Excel 2003 Orientation
1. Starting Microsoft Excel 2003
2. The Excel 2003 Screen
3. Understanding The Workcourse
4. Moving The Cell Pointer
5. Moving About The Workcourse
6. Using Go To
7. Menus And Toolbars
8. Using Menus And Toolbars
9. Using Context Sensitive Menus
10. Exiting Excel

A Simple Workcourse
1. Creating A New Workcourse
2. Entering Data In A Workcourse
3. Saving A New Workcourse
4. Opening A Saved Workcourse
5. Creating An Input Range
6. Saving Your Work
7. Essential Formatting
8. Column Best Fit
9. Closing A Workcourse

Selecting Ranges
1. Selecting Contiguous Ranges
2. Selecting Non-Contiguous Ranges
3. Using Special Selection Techniques
4. Selecting Larger Ranges
5. Range Calculations

Formulas
1. Understanding Formulas
2. Formulas That Add
3. The Sum Function
4. Formulas That Subtract
5. Formulas That Multiply And Divide
6. Referential Formulas
7. What If Formulas
8. More Complex Formulas
9. Common Error Messages

Copying And Filling
1. Understanding Copying In Excel
2. Using Fill For Quick Copying
3. Copying From One Cell To Another
4. Copying From One Cell To Multiple Cells
5. Copying From Many Cells To Many Cells
6. Copying Relative Formulas
7. Copying To A Non-Contiguous Range 

Adjusting A Worksheet
1. Inserting Cells
2. Deleting Cells
3. Inserting Columns
4. Inserting Rows
5. Deleting Rows And Columns
6. Resizing Columns
7. Resizing Rows
8. Hiding Grid Lines

Working With Functions
1. Functions
2. Typing A Sum Function
3. Summing Non-Contiguous Ranges
4. Calculating An Average
5. The Maximum Function
6. The Minimum Function

Sorting
1. Performing A Simple Sort
2. Sorting On More Than One Column
3. Sorting Numbers
4. Sorting By Rows

Printing
1. Print Preview
2. Simple Printing
3. Previewing Large Worksheets
4. Page Orientation
5. Scaling To Fit
6. Printing To Multiple Pages
7. Creating Page Headers And Footers
8. Formatting Headers And Footers
9. Printing Formulas

Printing Techniques
1. Printing A Selection
2. Setting The Print Area
3. Setting Page Margin

Absolute Referencing
1. Absolute And Relative Referencing
2. Problems With Relative Formulas
3. Tracing Precedents
4. Creating Absolute References
5. Creating Mixed References
6. Circular References

Formatting Cells
1. Using The Font Tools
2. Using The Alignment Tools
3. Using The Number Tools
4. The Format Cells Dialog Box
5. Formatting Fonts Using The Menu
6. Superscript Subscript & Strikethrough
7. Changing Horizontal Alignment
8. Centering Across A Selection
9. Wrapping Text
10. Changing Text Orientation
1