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

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

This course concentrates on using Excel is a group situation. As an advanced user, you’re often the focus of several people, and need to develop spreadsheets that will be used by them as well as yourself. By the end of this course you’ll be able to make pre-made forms and templates, build spreadsheets that can be accessed by several users simultaneously, and connect Excel to other sources of data such as Access databases and web pages.

Templates

Using an Existing File as a Template

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

Data Consolidation

Consolidate Multiple Worksheets into One

Consolidate by Position

Consolidate by Category

Consolidate from Other Workbooks

Importing and Exporting (2003 only)

Importing Text Files

Importing Access Tables

Exporting Data

Importing Data (2007/2010 only)

From Another Spreadsheet

Paste Link

Insert Object

Get External Data (2007/2010 only)

Importing from Access

Importing Text Files

Importing from Web

Working with Connections

Open External Files

Customizing Excel

Changing Default Options

Custom Lists

Numeric Formats

Custom Numeric Formats

Formatting Codes

Custom Date & Time Formats

Special Characters

Codes That React To Different Number Types

Scenarios

Creating and Saving the Scenario

Displaying Scenarios

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

Data Tables (2007/2010 only)

Creating

Substitute Consecutive Values in a Formula

Solver

Setting Objective/Target

Specifying Variable Cells

Specifying Constraints

A Brief Introduction to Macros

What is a Macro?

Recording a Macro

Playing a Macro

Relative Referencing

Rerecording a Macro

Versions	Toronto	North York	Mississauga	Newmarket
2007 /2010	Apr 26	May 31	May 29	Apr 30
Course Prerequisite: An Intermediate level knowledge of Excel is required before taking this course. This includes the Excel Introduction course, or equivalent knowledge, plus Intermediate Level 1 or Level 2 or Formulas and/or Functions. It is not necessary to take Advanced Level 1 before taking this course; however, you must have a solid understanding of Excel before attempting it.