Byron Employment

Byron Employment. Over 162,573 Jobs Australia Wide.

Delivery Method

  • Distance Learning
  • Price: $345.00

Course Overview

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.

Learn 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
  • Get help in using Excel 2003

Objectives

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

Getting Help

  • 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
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 9779 9800
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 9779 9800 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search