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
Upgrade from 2003

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 Data

From Another Spreadsheet

Paste Link

Insert Object

Get External Data

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

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		May 29	May 31
2007/2010/2013	Aug 23	Jul 29 Sep 27	Jul 18 Sep 20	Aug 14
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.