Microsoft Excel 2003 - Level 1

COURSE DESCRIPTION

This spreadsheet software is simplified by the instructor-led techniques that enhance your ability to understand relationships between numbers, formulas and data. You learn to create worksheets, develop workbooks with formatting and functions, perform calculations using formulas, customize a layout and generate and print reports.

PREREQUISITES

Computer Basics

CORE TOPICS
Getting Started Developing a Workbook

An overview of Excel 

Navigate in Excel 

Select, enter data 

Save a workbook

Obtain help

 

Format worksheet tabs

Reposition worksheets in a workbook

Insert and delete worksheets

Copy and paste worksheets

Copy a workbook

Modifying a Worksheet  Printing Workbook Contents

Move and copy data between cells

Fill cells with series of data 

Edit cell data 

Insert and delete cells, columns and  rows

Find, replace and go to cell data  

Spell check a worksheet

 

 

Set a print title

Create a header and footer

Set page margins

Change page orientation

Insert and remove page breaks

Print a range

Performing Calculations  Formatting a Worksheet Customizing Layout

Create basic formulas 

Calculate with functions  

 Copy formulas and functions 

Create an absolute reference

Change font size and type

Add borders sand colour to cells

Change column width and row height

Merge   cells

Apply number formats

Apply an Autoformat and styles

Split a worksheet

Arrange worksheets

Freeze and unfreeze rows and columns

Hide and unhide worksheets

Your partner in customized corporate education.

Call 905 949 9900 Extension 2474
to talk about your training needs,
or email
corporatetraining@hbicollege.com

Copyright 2007© HBI College. All Rights Reserved

HBI College Home Page To Registration Page