Excel 2003 Introduction

Two Rivers Software Training
Gold Coast, QLD, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is designed for users who have had little or no exposure to Microsoft Excel. It teaches the basic techniques that are required to put together a basic worksheet. By the end of this course, participants will have the tools to enter a variety of data, create simple formulas, format the worksheet, create simple charts and be able to edit, save, retrieve and print their work.

TOPICS :
Excel Fundamentals

Creating, saving closing, opening and renaming a workbook.
Working with rows, columns and cells

Entering text, numbers, dates and percentages
Selecting a cell, cell-range, row or column
Insert, delete and resize a row/column
Moving around a worksheet
Formulas and functions

Entering and editing a formula
Rules for formulas
Fixing problems with a formula
Five basic functions
- SUM, AVERAGE, COUNT, MIN, MAX
Adding together a group of numbers
Averaging a set of numbers
Counting how many numbers in a range
Finding the largest/smallest number in a range
Where to find and use other functions
Formatting a worksheet

The Format Cells dialog box
Formatting a number or date
Aligning text
Formatting the font
Setting borders and shading
Copying cell formatting quickly
Using AutoFormat to quickly format a table
Inserting a picture or clipart
Changing the background
Basic Auditing

Identifying and fixing formula errors
Spell check
Find and Replace Charts

Creating a chart with one key press
Using the Chart Wizard
Changing the chart type
Setting the chart title
Labelling the chart axes
Turning the gridlines on or off
Showing or hiding the legend
Adding data labels
Showing the data next to the chart
Copying and moving data

Cut, copy and paste
Drag and drop
The Office Clipboard
Printing

Setting a worksheet up for printing
Setting the page size and orientation
Setting the margins
Creating a simple header and footer
Printing the whole worksheet or just a selection
Previewing the worksheet before printing
Help

Where to turn for help
Using the Office Assistant
Ask Excel a question
Using the in-built Help facility
...''

Phone:0405 760 820

School Address:

PO Box 1354, Southport BC, QLD 4215, Australia

Jobs & Resumes: Gold Coast
Houses & Roommates: Gold Coast

Windows XP
Excel 2003 Advanced
Access 2003 Introduction
Access 2003 Advanced
Powerpoint 2003
Publisher 2003
Microsoft Project 2003
Dreamweaver
MYOB

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent.