This is an example of a simple banner
☀️ It's summer at ITTA! Enjoy a 10% discount until July 31st on a selection of courses 🌴 ×

Training: Excel – Formulas and Functions

Ref. MOE-12
Duration:
0.5
 day
Exam:
Not certifying
Level:
Intermediate

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
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

lun12Aoû09:00lun12:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-12

lun12Aoû09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 LausanneAnnulée Etiquettes de sessionMOE-12

lun12Aoû09:00lun17:00VirtuelConfirméVirtual Etiquettes de sessionMOE-12

lun12Aoû09:00lun17:00Lausanne, Avenue Mon repos 24, 1005 LausanneConfirmé Etiquettes de sessionMOE-12

lun16Sep09:00lun12:00VirtuelAnnuléeVirtual Etiquettes de sessionMOE-12

lun16Sep09:00lun12:00Genève, Route des Jeunes 33B, 1227 CarougeAnnulée Etiquettes de sessionMOE-12

lun16Sep09:00lun17:00VirtuelConfirméVirtual Etiquettes de sessionMOE-12

lun16Sep09:00lun17:00Genève, Route des Jeunes 33B, 1227 CarougeConfirmé Etiquettes de sessionMOE-12

lun21Oct09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-12

lun21Oct09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-12

lun25Nov09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-12

lun25Nov09:00lun12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-12

lun30Déc09:00lun12:00VirtuelVirtual Etiquettes de sessionMOE-12

lun30Déc09:00lun12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-12

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