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

Excel
Formulas

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

Excel’s core strength is its ability to perform calculations, and calculations are done with formulas. This course focuses on mathematical formulas (and so is often taken in conjunction with Computer Help’s Excel Functions course). Beginning from one simple technique that makes simple formulas, you’ll build up through more and more complex situations learning the correct way to integrate your numbers no matter where they’re located.

Course Prerequisite: Excel Introduction and Intermediate Level 1 or equivalent knowledge. It is not a necessary to take Intermediate Level 2 before this course. The topics in this course are unrelated to Intermediate Level 2 topics.

Review of Basic Formulas

Using Operators

Order of Calculation

Formulas that Reference One Cell

Copying and Filling Formulas

A Brief Introduction to Functions

Using Sum & Average

Using AutoSum

Absolute Formulas

Partial Absolute Formulas

Date and Time Formulas

Using Today and Now

Calculating Days Between Dates

Calculating Years Between Dates

Calculating Time Differences

Manipulating Formulas

Editing Formulas

Converting Formulas to Values

Printing Formulas in Place of Results

Manual Calculation

Combining/Splitting Cell Contents

Concatenating Formulas

Text To Columns

Referencing Cells Not On Sheet

Multiple Sheet Formulas

Multiple File Formulas

Linking Formulas

Save and Open Workspace

Formulas And Range Names

Using Range Names in Formulas

Using Range Names For Values

Column/Row Headings in Formulas

Mapping Formulas with Auditing

Tracing Formulas

Tracing Dependents and Precedents

Step Into a Formula

Watch Window

Text Formulas

Adding Text to Value Cells

Goal Seek

Have Excel Change Cell Value To Arrive At Desired Result

Formulas That Cannot Be Edited

Creating Array Formulas

Editing Array Formulas

Versions	Toronto	North York	Mississauga	Newmarket
2007 /2010	May 21			May 23
2007/2010/2013	Jun 14 Jul 15 Aug 19 Sep 13	Jun 17 Jul 16 Aug 14 Sep 23	Jun 18 Jul 22 Aug 12 Sep 19	Jun 20 Jul 26 Aug 13 Sep 16