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)

 
Versions

Toronto

North York

Mississauga

Newmarket

Version 2003

May 21

Jul 29

Sep 17

Apr 29

Jun 26

Aug 28

May 28

Jul 30

Sep 24

Apr 4

May 30

Aug 12

Sep 25

Version 2007

Jul 31

Aug 29

Apr 10

Aug 15

May 27

Sep 2

 

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

Tools, Options

Custom Lists

 

Numeric Formats

Custom Numeric Formats

Formatting Codes

Dates & Times

Special Characters

Codes That React To Different Number Types

 

 

 

 

 

 

 

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.

 

Pivot Tables

Creating a Pivot Table

Summarizing Data

Using Totals and Subtotals

 

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

Importing Text Files

Importing Access Tables

Exporting Data

 

  

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