Computer Help Training: Excel Courses - Toronto - North York - Mississauga

(all Excel Courses show in one PDF)

Course Dates (9am to 4pm)

Versions

Toronto

North York

Mississauga

Newmarket

Version 2003

Sep 23
Oct 25

Dec 14

Sep 22
Nov 24

Jan 26

Sep 24
Oct 27

Dec 17

Sep 30
Nov 26

Jan 24

Version 2007/2010 *

Oct 20

Nov 23

Dec 22

Jan 27

Oct 26

Nov 25

Dec 15

Jan 21

Oct 28

Nov 22

Dec 16

Jan 20

Oct 22

Nov 29

Dec 21

Jan 25

* Version 2010 available for all course dates after Oct 1/10.

Course Prerequisites

Excel Introduction or equivalent knowledge. It is not a necessary to take Intermediate Level 1 before this course. The topics in this course are unrelated to Intermediate Level 1. However you must have a solid understanding of the basics in Excel (Introduction topics) before attempting this course.

Course Description

This course examines features of Microsoft Excel which assist in working with larger spreadsheets, as well as creating graphs and using drawing tools.

Detailed List of Topics

AutoFormat & Styles (2003 only)

AutoFormat a Spreadsheet

Using Styles to Speed Repetitive Formatting

Creating and Editing Styles

Format as Table (2007 only)

Using The Design Tab

Design Your Own Table Style

Creating and Editing Cell Styles

Using Cell Styles in Other Workbooks

Customizing Toolbars (2003 only)

Choosing Different Toolbars

Creating Custom Toolbars

Changing Toolbar Display

Passwords

Protecting Sheets

Protecting Workbooks

Unprotecting Specific Cells

Password Protect Files

Data Validation

Setting the Validation Rules

Setting the Allowable Values

Choosing from a List

Input Message

Error Alert

Conditional Formatting (2003 only)
Conditional Formats Based on Values
Conditional Formats based on Formulas

Conditional Formatting (2007 only)
Highlight Cell Rules
Top/Bottom Rules
Data bars, Color Scales, Icon Sets
Manage Rules
Stop if True
Clearing Rules

Charts (Graphs)
Creating and Editing
Formatting Items in a Chart
Changing Chart Types
Naming Charts
Printing Charts
Unlinking Charts From Data

Drawing Tools

Lines, Arrows, Freehand

Boxes, Circles, Arcs

Text Boxes

Group, Ungroup, Order

Colours and Shadows

Moving, Sizing, Formatting Objects

Add Pictures and Clip Art (2007 only)

SmartArt Graphics (2007 only)

Lines, Arrows, Freehand

Boxes, Circles, Arcs

Text Boxes

Group, Ungroup, Order

Colours and Shadows

	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