Excel

The Learning Laboratory
Adelaide, Melbourne, Sydney, Brisbane, Perth, Canberra, Hobart, Australia

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

Course Description:

'' Upon completion of this course the participant will be able to:

�enter, edit, delete, clear and select data �build a basic formula
�manage worksheets �understand functions
�work with cells, rows and columns �format existing data

Training Method
Training is conducted by professional trainers, using hands on exercises and user practise to consolidate concepts.

Prerequisite
Windows 95 Getting Started or equivalent. Participants must have basic mouse skills.

Course Content
Getting Started
Starting and Closing Excel
The Workbook Window
Moving around the Worksheet
Using the Edit, Go To Command
Ending the Current Excel Session
Survival Skills
Choosing a Command using the Keyboard
Choosing a Command using the Mouse
Cancelling a Command Selection
Using Short Cut Menus
Moving between Worksheets
Opening and Closing Workbooks
Creating and Saving a Workbook
Opening a Recently Used Workbook
Opening Several Workbooks at One Time

Worksheet Skills
Identifying Data Types
Entering Data
Abandoning Data Entry
Using Undo and Redo
Using AutoComplete
Editing Existing Data
Deleting Data Only
Deleting Data and Formatting
Using AutoFill
Fill Sequences
Selecting
Moving through Selected Cells
Moving and Copying
Changing Column Widths
Changing Row Heights
Inserting Cells, Rows and Columns
Deleting Cells, Rows and Columns
Working with Sheets
Renaming Sheets
Inserting and Deleting Sheets
Hiding and Unhiding Sheets


Formulas
Types of Formulas
Building a Basic Formula
The Order of Precedence
Using the SUM Function
Using AutoSum
Relative and Absolute Cell References
Formatting Cells
The Formatting Toolbar
The Format, Cells Menu
Copying Cell Formatting
AutoFormats

Printing
Overview
Printing using Excel’s Defaults
Changing Page Setup
Page Options
Margins Options
Header and Footer Options
Sheet Options
Print Preview
Changing Margins via Print Preview
Page Breaks

...''

Phone:(08) 8231 2426

School Address:

11th Floor,
Adelaide Bank Building
90 King William Street
ADELAIDE SA 5000

Jobs & Resumes: Adelaide, Melbourne, Sydney, Brisbane, Perth, Canberra, Hobart
Houses & Roommates: Adelaide, Melbourne, Sydney, Brisbane, Perth, Canberra, Hobart

PowerPoint
Publisher
Introduction to MYOB
MYOB - First Accounts
MYOB - Payroll
MYOB - Inventory
Project Management
Establishing a Commercial Web
Dreamweaver
FrontPage
Excel - Visual Basic for Applications
Database
Visual Basic 6

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: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.