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

Excel
Upgrade to 2007/2010 (from 2003)

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.)

The release of Office 2007 brought a major change in the way Excel spreadsheets are made. With the new Ribbon interface both Office 2007 and 2010 approach many tasks, even the simplest ones, in a new way. If you’re comfortable with older versions of Excel, you may find yourself floundering for some time before you can become proficient in these new versions. Why not save yourself time and trouble by taking this course and getting Computer Help to show you how to transition to the new Office, rather than having to figure it out on your own?

Course Prerequisite: This course is not intended for beginners. An Intermediate or better knowledge of Excel (versions 97, 2000, 2002 XP, or 2003) is essential.

General

New Interface

The Office Button (2007)

The File Tab (2010)

The Ribbon

Customize Quick Access Toolbar

Customize the Ribbon (2010)

Creating & Editing Workbooks

Larger Spreadsheets

Column & Row Headings

Using Templates

Using Themes and Cell Styles

Page Layout Options

Headers and Footers

Improved Spell & Grammar Checker

Mark as Final for Read-Only

Viewing Workbooks

Formulas & Formatting

Basic Formatting

Enhanced Conditional Formatting

New Formatting as Table

Total Row

Improved Formula & Function tools

Working with Range Names

Sorting & Filtering

Improved Find & Replace

Improved Sorting Options

Improved Filters

Charts & Graphics

Improved Look for Charts

New Chart Formatting Tools

Adding Graphics and Shapes

Enhanced Formatting of Graphics and Shapes

Professional Diagrams with SmartArt

Sparklines (2010)

Pivot Tables

More Levels of Undo

Sorting & Filtering in Pivot Table

Conditional Formatting

Pivot Table Styles and Formats

Pivot Table Slicers (2010)

Productivity Tools

Sharing Workbooks

Connections to Outside Sources, e.g. Currency Exchanges

Enhanced Printing Options, including Page Layout View

Saving and Converting

Converting Existing Workbooks to 2007/2010

Converting 2007/2010 Workbooks to earlier versions

Converting to Other Formats

Toronto	North York	Mississauga	Newmarket
Mar 26	Apr 10	Feb 28