Excel 1 2003

Download PDF

Next Dates:

Wed, 29. Feb. 2012
Thu, 05. Apr. 2012

Length:

1 day

Location:

Ottawa

Language:

Max Attendees:

10 students

Price:

$ 185

Target audience & Prerequisites:

This Course is designed to cover important features of an Excel spreadsheet to new users. Participants must have basic knowledge of the Windows environment, keyboard and mouse operations as well as a basic understanding of mathematics.

Learning objectives:

Upon completion of the course you will be able to create and save a simple spreadsheet, use simple formulas and functions. Format and print your spreadsheets.

Course Outline:

GETTING STARTED

Starting Excel
Excel Window and Views
Excel Menus and Toolbars
Task Pane
Excel Help
Excel Intellisense

EXCEL BASICS

Creating and Saving a Document
Opening a Document
Using Spell check
Using Autocorrect and Autocomplete
Closing vs. Exiting

BASIC EDITING

Selecting Text using mouse and using keyboard
Using Autofill
MOving and copying date
Drag and Drop Feature
Smart Tags

BASIC FORMULAS

BASIC FORMULAS
Auto Sum
Editing Formulas
Formula Range Finder

FORMATTING WORKSHEETS

Column Widths
Row Heights
Number formatting
Alignments/Merge and Centre
Fonts
Borders
Patterns

INSERTING

Inserting a Column
Inserting a Row
Inserting multiple Rows and Columns
Adjusting formulas

VARIOUS VIEWS

View Preferences
Freezing Panes
Splitting Screen

PRINTING

Page Setup
Headers and Footers and Page Numbers
Various other Printing Options

Remember that we build our schedule around your requests. Check out our Courses List, call us at (613) 235-6161 or email us at training@compuease.ca:

Calendar

Search

Course List