Excel 2003

ELECTUS
Adelaide, SA, Australia

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

Course Description:

'' In this 2 day program, you will gain the knowledge and skills to allow you, by means of realistic business scenarios, to create workbooks incorporating formulas, functions and graphs..



They will also learn how format your workbooks for professional presentation and easy-to-follow printouts.



You will learn to

Ø Fully utilise the interface

Ø Navigate efficiently

Ø Format and edit cells

Ø Format number displays

Ø Write formulas

Ø Use Excel’s built-in Functions

Ø Create and format graphs

Ø Configure page layout and printing options



What skills you need

The ability to work in the Windows environment and use a mouse.

Course Content
Exploring Excel

· Using the Interface

· Working with worksheets

· Displaying/Hiding toolbars

· Changing menu and toolbar options

· Using the Task Pane

Using Basic Workbook Skills

· Selecting cells

· Entering text and numbers

· Entering formulas

· Editing columns & rows

· Using the AutoSum function

· Saving a workbook

· Opening existing workbooks

· Using data entry shortcuts

· Editing cell entries

· Deleting/clearing cell entries

Navigating the Workbook

· Selecting cells and ranges

· Using the GoTo command

· Using multiple worksheets

· Navigating between worksheets

Basic Formatting

· Formatting cell text

· Changing font attributes

· Wrapping Text

· Changing text alignment

· Using the Borders button

· Drawing cell borders

· Renaming/colouring worksheet tabs

Creating Simple Formulas

· Entering formulas

· Using Functions

· Using the AutoSum List

· Entering basic Functions

· Modifying formulas

· Checking Errors

· Using Autocalculate

· Creating an absolute reference


Smart Data Entry

· Using Ranges

· Entering values into a range

· Using the AutoFill feature

· Undo/Redo

· Using drag-and-drop editing

· Copying/moving data

· Using the Paste Options data

· Freezing panes

· Spell checking

· Finding & replacing data

Formatting Numbers

· Applying Currency and Percent formats

· Changing decimal places

· Using the comma style

· Date and Time formats

Building Worksheets

· Inserting columns & rows

· Deleting columns & rows

· Adjusting columns automatically

· Inserting worksheets

· Moving worksheets

· Deleting worksheets

Using Page Setup

· Setting Margin & Centering

· Changing the page orientation

· Changing print gridlines

· Repeating row and column labels

· Adding Headers & Footers

· Using Page Break preview

· Removing page breaks

Printing

· Setting/removing a print area

· Previewing a worksheet

· Printing options

Working with Comments

· Creating & viewing comments

· Using the reviewing toolbar

· Printing comments
Using other Functions

· Using Date Functions

· Using Logical Functions

· Using Statistical Functions

· Using Maths Functions

More Formatting

· Using Colour fills

· Merging & Centering

· Splitting cells

· Copying formatting

· Changing vertical alignment

· Using AutoFormatting

· Extending list formats

Using Drawing Objects

· Drawing Enclosed Objects

· Drawing Lines

· Selecting & Moving objects

· Adding text to an object

· Applying formatting

· Inserting graphics

Creating Charts

· Instant Charts

· Using the Chart Wizard

· Moving/Resizing Charts

· Editing chart elements

· Changing the data source

· Changing the chart location

· Printing the chart

Managing Files

· Changing workbook properties

· Using the Search task panes

· Selecting File Views

· Sorting Excel files

· Using the Document Recovery Pane

Using the Help System

· Using the Help Task Pane

· Using Type a Question for help

· Using the Office Assistant

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Indispensable Assistant
Leadership
Time Management
Access - Advanced
Access 2003
CorelDRAW 12
Dreamweaver MX 2004 Advanced
Dreamweaver MX 2004
Excel 2003 Advanced
Excel 2003 Intermediate
FrontPage 2003 Advanced
FrontPage 2003
Outlook 2003
Photoshop CS2 Advanced
Photoshop CS2
PowerPoint 2003 Advanced
PowerPoint
Premiere 6.5 Advanced
Project 2003 Advanced

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: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.