Formulas and Functions


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

Course Description

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 Program Coordinator
Registration is closed, however our advisors are available to address your questions. Price quoted are in Canadian funds, per person, per registration, and does not include any applicable taxes. Subject to change without prior notice.

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