Training: Excel – Formulas and Functions Advanced

Ref. MOE-22

Download PDF

Duration:

0.5

day

Exam:

Not certifying

Level:

Advanced

Funding:

Eligible

Home > Trainings > Office Automation > Spreadsheet > Excel – Formulas and Functions Advanced

Description

This Excel course will provide participants with the knowledge and skills to perform complex calculations in their Excel spreadsheets, and teach them a variety of different functions.

Participant Profiles

End-users who want to go further in the calculations on their worksheets, or who need to solve complex problems

Objectives

Perform multi-sheet and multi-file calculations
Manage range names
Use a variety of functions

Prerequisites

Basic knowledge of Excel and ability to use common formulas and functions

Course Content

Module 1: Setting up complex calculations

Create a multi-sheet formula
Create a multi-file formula
Check and edit cells containing links

Module 2: Range names

Create a cell range name
Creating range names automatically
Managing range names
Use all the options of the name manager

Module 3: Functions

Nesting functions
Make your functions more readable
Evaluate all or part of your function
Function library :
- Search (VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, INDIRECT)
- Logic (IFS, AND, OR, …)
- Date (NETWORKDAYS, WORKDAY, DATEDIF)
- Information (ISNA, ISNUMBER, ISBLANK)
- Math and trig (SUBTOTAL, CEILING, FLOOR, EVEN, ODD)
- Statistics (SUMIFS, AVERAGEIFS, MAXIFS, MINIFS)
- Text (REPLACE, SEARCH, LEN)
Use the Function Wizard and Microsoft Help to find the right function
Worksheet calculation options

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

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