Training: Excel – Formulas and Functions

Ref. MOE-12

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Intermediate

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – Formulas and Functions

Description

This Excel course will provide participants with the knowledge and skills to perform calculations in their Excel spreadsheets, and teach them the most common functions.

Participant profiles

End users who need to perform calculations in their worksheets

Objectives

Insert a formula
Use a variety of functions
Understand and troubleshoot their functions and formulas

Prerequisites

Basic knowledge of Excel

Course content

Module 01: Formulas

The formula bar
Inserting a formula
Cell references (absolute and relative)
Precedence of operators
Comparison operators
Naming cells

Module 02: Functions

Inserting a function
Function library :
- Common (SUM, AVERAGE, MAX, MIN)
- Logical (IF, AND, OR, …)
- Date (TODAY, DAY, MONTH, WEEKDAY)
- Math & Trig (SUM.IF, ROUND, …)
- Statistics (COUNT, COUNTIF, …)
- Text (UPPERCASE, LEFT, CONCAT, SEARCH, …)
Introduction to nested functions

Module 03 : Troubleshooting functions and formulas

Understanding a function already present in a cell
Checking for errors
Evaluation of formulas
Finding precedents and dependents

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Explore all our Microsoft Office courses by clicking here