Excel training workshop – Management reports for controller and analyst

$ 395


6 heures (9h à 16h)
Aussi disponible en entreprise


  • 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 array functions to make reports
  • Use the macro commands in management reports
Voir plus
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 array 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
Technical information Solutions D'Affaires SLV inc. will provide the laptop needed for this course.


14/08/2024WebinaireMarcel Dubé
08/10/2024WebinaireMarcel Dubé
04/02/2025WebinaireMarcel Dubé
13/05/2025WebinaireMarcel Dubé
12/08/2025WebinaireMarcel Dubé