Training: Excel – Formulas and Functions Advanced

Ref. MOE-22
Duration:
0.5
 day
Exam:
Not certifying
Level:
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 courseware 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
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • An online skills assessment test before and after your course so that you can evaluate your progress

mar04apr09:00mar12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-22

mar04apr09:00mar12:00VirtuelVirtual Etiquettes de sessionMOE-22

mar23may09:00mar12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-22

mar23may09:00mar12:00VirtuelVirtual Etiquettes de sessionMOE-22

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X