Microsoft Excel

Introduction

Intermediate Level 1

Intermediate Level 2

Formulas

Functions

Advanced

Macros & VBA Level 1

Macros & VBA Level 2

Macros & VBA Level 3

Version 2007 Upgrade

 

Register Now

 

View Course Outline PDF

(all Excel Courses show in one PDF)

 

 

 

 

Pay $ 115. to $ 215. for this course using TICKETS instead (Minimum Purchase of 11 Tickets).…Click here for More Information.

 

Course Dates (9am to 4pm)

 

Versions

Toronto

North York

Mississauga

Newmarket

Version 2003

Apr 1

May 6

Jun 3

Jul 14

Aug 7

Sep 4

Apr 2

May 5

Jun 9

Jul 7

Aug 8

Sep 2

Apr 8

May 2

Jun 11

Jul 9

Aug 13

Sep 5

Apr 3

May 1

Jun 2

Jul 11

Aug 15

Sep 8

Version 2007

Apr 4

Jun 4

Aug 14

May 9

Jul 10

Aug 8

Apr 9

Jun 6

Jul 28

Jul 8

Sep 10

 

Course Prerequisites

 

Required:  Knowledge of Windows Introduction topics and ability to use keyboard and mouse.

 

Course Description

During this course you will learn how to create spreadsheets from scratch. Topics include: entering data, creating formulas, copy and move, column width and row height, inserting and deleting columns and rows, numeric formats, alignment, fonts, lines and shading, spell check, saving and opening files, and printing.

Detailed List of Topics

 

Worksheet Entries

Rules For Entering Data

Deleting Cell Contents

Editing Cell Entries

Moving Around A Worksheet

Selecting Cells (Short Cuts)

 

Formulas

Entering A Basic Formula

Operators

Using Functions For Sum & Average

 

Spreadsheet Formatting

Setting Column Widths

Setting Row Heights

Choosing Number Formats

Date Formats & Custom Date Formats

Setting Decimal Places, Negative Display

Aligning Entries In Cells – Left, Centre, Right

Centering A Heading

Using Paste Special

 

Copy, Move, & Fill

Drag & Drop

Clipboard Cut, Copy, & Paste

Using Fill To Automate Entering Months, Days, Numbers, And To Copy Formulas

     

Inserting & Deleting

Columns

Rows

Partial Columns And Rows

 

 

 

Cell Formatting

Attributes

Changing Font

Applying Borders

Using Colour For Shading And Reverse Video

 

Files

Saving & Opening

Working In More Than One File

Closing  & Creating New Files

 

Page Setup

Portrait & Landscape

Scaling

Paper Size

Margins

Centre On Page

 

Print & Print Preview

Page Breaks

Preview

Print Options

 

  

Computer Training Courses, SoftSkills Seminars & Access Database Development

Computer Help is a division of MPM Skills Development Inc.
Toronto, Ontario, Canada.

Phone: 416.494.4912, Fax: 416.494.9952

www.Computer-Help.ca

Question or Comment - Email Us