This is an example of a simple banner

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 course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

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
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Documentation in digital format
  • Achievement Badge
Mois actuel

ven21Fév09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven21Fév09:00ven12:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-22

ven28Mar09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven28Mar09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-22

ven02Mai09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven02Mai09:00ven12:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-22

ven06Juin09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven06Juin09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-22

ven11juil09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven11juil09:00ven12:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-22

ven15Aoû09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven15Aoû09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-22

ven19Sep09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven19Sep09:00ven12:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-22

ven24Oct09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven24Oct09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-22

ven28Nov09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-22

ven28Nov09:00ven12:00Genève, Route des Jeunes 35, 1227 Carouge Etiquettes de sessionMOE-22

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

Monday to Friday
8:30 AM to 6:00 PM
Tel. 058 307 73 00

Contact-us

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Make a request

Contact

ITTA
Route des jeunes 35
1227 Carouge, Suisse

Opening hours

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

Contact us

Your request