Microsoft Excel

Introduction

Intermediate Level 1

Intermediate Level 2

Formulas

Functions

Advanced Level 1

Advanced Level 2

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

May 25

 

May 21

 

Version 2007

 

 

 

May 22

 

Course Prerequisites

 

Required: Solid understanding of all Excel Introduction and Intermediate Level I topics. Recommended:  Knowledge of Excel Intermediate Level II topics.

 

Course Description

Topics include: templates, forms, sharing workbooks and tracking changes, customizing excel, numeric formats (including custom numeric formats), advanced filter, dsum, daverage, scenarios, pivot tables, group & outline, and subtotals.

Detailed List of Topics

 

Templates

Creating a Template

Using In a New File

Templates and Inserting Sheets

Auto templates

For default Books or Sheets

   

Forms

Form Templates

Designing the Form

Tools-Combo Boxes, List Boxes, etc.

Control Properties

Protecting the Form

 

Sharing Workbooks and Tracking Changes

Sharing workbooks on a network

Multiple users in the same file

Controlling which changes are saved

     

Customizing Excel

Changing Default Options

Custom Lists

 

Numeric Formats

Custom Numeric Formats

Formatting Codes

Dates & Times

Special Characters

Codes That React To Different Number Types

 

Pivot Tables

Creating a Pivot Table

Summarizing Data

Using Totals and Subtotals

 

Data Tables (version 2007 only)

Creating

Substitute Consecutive Values in a Formula

 

 

 

 

 

 

Advanced Filter

Setting Up the Ranges

Performing the Filter

Setting Up the Criteria Range

Using Database Functions

Entering/Changing Criteria

 

Scenarios

Creating and Saving the Scenario

Displaying Scenarios

Other Scenario Options - Edit, Merge, Summary, etc.

 

Group & Outline, & Subtotals

Grouping Rows/Columns on a Sheet

Showing/Hiding Details in an Outline

Display/Hide Outline Symbols

Adding Automatic Subtotals

Adding Other Automatic Analysis (Average, Mode, etc)

Removing Subtotals

 

Importing and Exporting (version 2003 only)

Importing Text Files

Importing Access Tables

Exporting Data

 

Importing Data (version 2007 only)
From Another Spreadsheet
Paste Link
Insert Object

 

Get External Data (version 2007 only)

Importing from Access

Importing Text Files

Importing from Web

Working with Connections

Open External Files

 

  

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