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

Home
  About Computer Train
  Public Courses
  Corporate Courses
  Distance Courses

 Microsoft Word
 Microsoft Excel
 Microsoft Access
 Microsoft Powerpoint
 Microsoft Project
 Microsoft Visio
 Microsoft Outlook
 MYOB
Enrol
  Free Resources
  Student Resources
  Self-Assessments
  Contact
 


Join our mailing list to receive regular articles and tips!
 
 

 

 

Microsoft Excel Introduction

About the Excel 2003 Introduction Course

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.

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

 

What's new?

Specials

order online

Make an enquiry

 

 


 

 

web design by Escala