Excel 1 2003 FE

Download PDF

Next Dates:

Wed, 07. Mar. 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 data
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