Tel: +1 (604) 900-1980

Formulas and Functions

Registration
Closed
Contact
Us
Registration is closed, however our advisors are available to address your questions. Price quoted are in Canadian funds, per person, per registration, one month access, and does not include any applicable taxes. Subject to change without prior notice.

 

Course Description

Formulas and functions enable you to perform calculations on a worksheet. Excel can perform simple calculations, such as summing a column of numbers, or very complex calculations such as calculating financial, statistical or engineering information.

Course Details

Learning Objectives

By the end of this course, you will be able to

  • Define formula and function
  • List the mathematical operators used in Excel
  • Explain how references to cells or ranges are used in formulas and functions
  • Use the Sum and Average functions
  • Use the AutoSum command
  • Understand how to copy formulas and functions
  • Explain relative and absolute cell references
  • Understand how to move formulas and functions
  • Describe methods for troubleshooting formulas and functions
Registration
Closed
Contact
Us
Registration is closed, however our advisors are available to address your questions. Price quoted are in Canadian funds, per person, per registration, one month access, and does not include any applicable taxes. Subject to change without prior notice.
Google Review

Preparing you for success

The Northwest Skills Institute is an industry focused training organization.

Our programs are geared specifically for industry, making students more qualified and READY FOR WORK.

Runner to target

It's time to upskill your employees and solve your workforce problems.

Contact our program coordinator

Trusted by companies looking to develop highly skilled workers

Manufacturing BC
Discover Tours
Print Forward
Mission Community
Arcteryx
BC Food & Beverage
BSIA
Go Industrial
Great Little Box Company
BC Apparel & Gear
Mustang Survival
Red Wood Rubber

Northwest Skills Institute
Proud Member of