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)

 

Toronto

North York

Mississauga

Newmarket

Apr 7

Jul 23

Apr 18

Aug 18

Jun 5

Jun 20

 

Course Prerequisites

 

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

 

Course Description

 

This course is a must if you want to get up to speed quickly with the many changes and improvements in Excel version 2007.  Topics include: the brand new user-interface, changes in spreadsheet limits, themes and styles, conditional formatting, improved formula writing, improved sorting and filtering, table enhancements, the new look of charts, improved pivot tables, new file formats, changes in printing, improved sharing, and more.

 

Detailed List of Topics

 

General

New Interface

The Office Button

The Ribbon

Customize Quick Access Toolbar

 

Creating & Editing Workbooks

Larger Spreadsheets

Column & Row Headings

Using Templates

Using Themes and 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

New Cell Styles

 

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

 

Pivot Tables

More Levels of Undo

Sorting & Filtering in Pivot Table

Conditional Formatting

Pivot Table Styles and Formats

 

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

Converting 2007 Workbooks to earlier versions

Converting to Other Formats

 

  

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