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

Excel
Intermediate Level 2

1 Day (9am to 4pm)
$ 275. or 1 Ticket

Other Excel Course Levels

Introduction
Intermediate Level 1
Formulas
Intermediate Level 2
Functions
Advanced Level 1
Advanced Level 2
Macros & VBA Level 1
Macros & VBA Level 2
Macros & VBA Level 3
Version 2007/2010 Upgrade

Register Now

Contact Us

View PDF Course Outlines for All
Excel Courses

Locations

Toronto
20 Queen Street West, Suite 3306
(Toronto Eaton Centre)

North York
2 Lansing Square, Suite 505
(Hwy 401 & Hwy 404/DVP)

Mississauga
1087 Meyerside Drive, Unit 10
(Dixie Rd. & Hwy. 401)

Newmarket
16635 Yonge Street, Unit 19
(Yonge St. & Mulock Dr.)

A simple spreadsheet is often enough, but many times you need to make it look good too. This course’s emphasis is on the visual aspects of an Excel spreadsheet. Whether it’s something as simple as getting cells to colour themselves based on the values entered, to mid-level tricks like making in-cell menus, to complex topics like making a graph, you’ll learn it here.

Course Prerequisite: 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.

AutoFormat & Styles (2003 only)

AutoFormat a Spreadsheet

Using Styles to Speed Repetitive Formatting

Creating and Editing Styles

Format as Table (2007/2010 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 Drop-Down List

Input Message

Error Alert

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

Conditional Formatting (2007/2010 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/2010 only)

SmartArt Graphics (2007/2010 only)

Adding ScreenShots (2010 only)

Lines, Arrows, Freehand

Boxes, Circles, Arcs

Text Boxes

Group, Ungroup, Order

Colours and Shadows

Versions	Toronto	North York	Mississauga	Newmarket
2007 /2010	Feb 21 Mar 16 Apr 17 May 18	Feb 17 Mar 21 Apr 25 May 16	Feb 27 Mar 23 Apr 30 May 22	Feb 23 Mar 22 Apr 24 May 25