L'ensemble de nos services sont assurés à distance jusqu'à nouvel ordre en raison de la pandémie de COVID-19.
Suivez l’évolution de la situation et son incidence sur la profession > 

Excel training workshop – Management reports for controller and analyst - Webinar


  • Partner: SLV Expert inc.
  • Registration/cancellation: Follow the Order’s normal procedure.
  • Final registration confirmation sent by: SLV Expert inc.
  • Price: Please see the schedule fee below. Prices are subject to change without notice.
  • Webinar: SVL will send, in the days peceding the course, an email with the needed information for you to access your course.


This course will be offered via the Zoom platform.


  • Provide the tools to handle large databases
  • Making effective and professional management reporting with data integrity
  • Monitor the quality and integrity of data
  • Use several advanced matrix functions to make reports
  • Use the macro commands in management reports

Summary of Contents

  • Introduction
  • Structuring data
    • Essential Conditions to respect
    • Database basic functionalities
  • Imports / Exports and data conversion
    • From Access
    • From a Text File
    • From Word
    • From another Excel workbook
    • From an XML file
  • Master dates functions
  • Master text functions
  • Addressing absolute and mixed cells
  • Search function and matrix
    • Vlookup functions and Hlookup
    • index / equiv functions
  • Statistics functions
  • Named Fields and Validation
    • Named fields
    • Drop-down lists in Excel
  • Error Validation (if / ISERROR)
  • The matrix functions
    • SUMPRODUCT and Type
    • SUMPRODUCT or Type
    • SUMPRODUCT and & or Type
    • SUMPRODUCT Dynamic Type
    • SUMPRODUCT cross Type
  • 3D Function
  • Best practices and tips
    • Maintenance sheet
    • Navigation sheet
  • Macros
    • Create and edit a macro
    • Attach a macro to a button or to a drawing
    • Security Management
    • Examine the execution of a macro

Description complète

Aucune formation en salle trouvée


Pour tous

Saison de formation : 2020-2021
No de séance : 2531
Date de début : 2021-04-23, 09:00
Date de fin : 2021-04-23, 16:00
Durée : 7.00 h
Animateur : Animateur du partenaire
Renseignements complémentaires : SVL will send, in the days peceding the course, an email with the needed information for you to access your course. You can see the suggested order of training worshop and prerequisites on

Grille tarifaire

1 place disponible

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O