MS Excel 2003: Getting Started with Excel

To download a PDF version of this course overview click here

This Excel course is perfect for any beginner. Covering the basics of using Excel 2003, including creating workbooks and adding data. It also covers editing data, working with formulas, printing and charting.

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 a variety of office environments where there is a requirement to produce reports, budgets, lists, and the like.

Learning outcomes

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

  • 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
  • access and use the help system and work safely with your computer.

The training room and facilities

When training on-site at your premises, we require only that each participant has access to their own computer or laptop, with Microsoft Excel 2003 installed. Internet and networking facilities are not required. A data projector is required, and if your training room or board room is not equipped with one, we’re able to provide one at no extra cost.

Spreadsheets

  • How Spreadsheets Work
  • Spreadsheet Characteristics
  • Spreadsheet Functionality
  • The Appropriateness of Spreadsheets

Excel 2003 Orientation

  • Starting Microsoft Excel 2003
  • The Excel 2003 Screen
  • Understanding The Workbook
  • Moving The Cell Pointer
  • Moving About The Workbook
  • Using Go To
  • Menus and Toolbars
  • Using Menus and Toolbars
  • Using Context Sensitive Menus
  • Exiting Excel

A Simple Workbook

  • Creating A New Workbook
  • Entering Data In A Workbook
  • Saving A New Workbook
  • Opening A Saved Workbook
  • Creating An Input Range
  • Saving Your Work
  • Essential Formatting
  • Column Best Fit
  • Closing A Workbook

Selecting Ranges

  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Using Special Selection Techniques
  • Selecting Larger Ranges
  • Range Calculations

Formulas

  • Understanding Formulas
  • Formulas That Add
  • The Sum Function
  • Formulas That Subtract
  • Formulas That Multiply And Divide
  • Referential Formulas
  • What If Formulas
  • More Complex Formulas
  • Formula Error Checking
  • Common Error Messages

Copying And Filling

  • Understanding Copying In Excel
  • Using Fill For Quick Copying
  • Copying From One Cell To Another
  • Copying From One Cell To Multiple Cells
  • Copying From Many Cells To Many Cells
  • Copying Relative Formulas
  • Copying To A Non-contiguous Range

Working With Functions

  • Functions
  • Typing A Sum Function
  • Summing Non-Contiguous Ranges
  • Calculating An Average
  • The Maximum Function
  • The Minimum Function

Printing

  • Print Preview
  • Simple Printing
  • Previewing Large Worksheets
  • Page Orientation
  • Scaling To Fit
  • Printing To Multiple Pages
  • Creating Page Headers And Footers
  • Formatting Headers And Footers
  • Printing Formulas

Charting

  • Using The Chart Wizard
  • Choosing The Chart Type
  • Changing The Chart Type
  • Modifying A Chart
  • Printing A Chart
  • Creating A Pie Chart
  • Creating A Bar Chart
  • Moving A Chart
  • Deleting A Chart

General Computer Usage

  • The Help Task Pane
  • Searching For General Help
  • Searching For Specific Help
  • Understanding A Help Window
  • Disabling Online Content
  • Enabling Online Content
  • Displaying And Using The Office Assistant
  • Customising The Office Assistant
  • Disabling The Office Assistant
  • Screen Tips And Dialog Box Help
  • Setting Up An Ergonomic Workstation
  • Breaks And Exercises

Need more information?

Contact us:

1300 730 922
www.exceldimensions.com.au
enquiries@exceldimensions.com.au