Computer Train: Public Computer Training Courses in Sydney at North Ryde, Word, Excel, Access, PowerPoint, Project, Visio, Outlook and MYOB


Join our mailing list to receive regular articles and tips!

 
 

 

Microsoft Excel Introduction Course in Sydney

This course is designed for people who have never used Microsoft Excel before, or those people who have tried to teach themselves and still have a lot to learn!  It covers basic charts, formulas and functions.

NEXT SYDNEY COURSE DATES:
2009
Pricing Group and Bulk Discounts Do this Course via Distance
Self-Assessment Enrol Online Enrol via Fax

 


 

Microsoft Excel Introduction Course Overview

  • Understand the origins of and basic uses for spreadsheets
  • Start Microsoft Excel, navigate workbooks and exit correctly
  • Create, modify, save and close a simple workbook
  • Select ranges of cells in a workbook
  • Create formulas that perform calculations in a workbook
  • Copy and fill data in a workbook
  • Create and work with functions in a workbook
  • Print data in a workbook
  • Create a variety of charts (graphs) in Excel
  • Get help in using Excel 2003

Specific Topics: Microsoft Excel Introduction Course

Excel 2003 Orientation

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

A Simple Workbook

  1. Creating a New Workbook
  2. Entering Data in a Workbook
  3. Saving a New Workbook
  4. Opening a Saved Workbook
  5. Creating an Input Range
  6. Saving Your Work
  7. Essential Formatting
  8. Column Best Fit
  9. Closing a Workbook

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. Formula Error Checking
  10. 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

 

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

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

Charting

  1. Using the Chart Wizard
  2. Choosing the Chart Type
  3. Changing the Chart Type
  4. Modifying a Chart
  5. Printing a Chart
  6. Creating a Pie Chart
  7. Creating a Bar Chart
  8. Moving a Chart
  9. Deleting a Chart

Getting Help

  1. General Computer Usage
  2. The Help Task Pane
  3. Searching For General Help
  4. Searching For Specific Help
  5. Understanding a Help Window
  6. Disabling Online Content
  7. Enabling Online Content
  8. Displaying and Using the Office Assistant
  9. Customising the Office Assistant
  10. Disabling the Office Assistant
  11. Screen Tips and Dialog Box Help
  12. Setting up An Ergonomic Workstation
  13. Breaks and Exercises
Printable Brochure
Self-Assessment Checklist
Request More Information
Make an enquiry

 

 

 

 

What's new?

Specials

order online

Make an enquiry

 

 


 

 

web design by Escala