logo-slvexpert

VOTRE

FORMATION

Excel training workshop – Management reports for controller and analyst

$ 395

AF3490

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

RÉSUMÉ :

This training, aimed at controllers and analysts, has been designed for users who wish to create quality reports from large amounts of data, frequently used by finance and accounting professionals. After a quick review on few functions and useful features, learn how the use of tables and named fields can simplify your data management. You will also learn how the famous SUMPRODUCT function can be adapted and customized to generate dynamic and impactful reports. A series of examples and techniques will be taught to effectively meet the reporting needs of organizations.
Voir plus
Training Objectifs
  • Provide the necessary tools to manipulate large databases.
  • Produce effective, integral, and professional management reports.
  • Control data quality and integrity.
  • Use advanced array functions for report development.
Lesson Plan
  • Introduction
  • Mastering date functions
  • Mastering text functions
  • Addressing absolute and mixed cell references
  • Lookup and reference functions
    • VLOOKUP and XLOOKUP
    • MATCH
  • Tables, named fields, and validations
    • Inserting a table
    • Named fields
    • Dropdown lists in Excel
  • Array functions
    • SUMPRODUCT type And
    • SUMPRODUCT type Or
    • SUMPRODUCT type And & Or
    • SUMPRODUCT Dynamic type
    • SUMIFS
  • Conditional formatting
  • Remove duplicates
  • 3D function
  • File security

CALENDRIER :

13/05/2025WebinaireMarcel Dubé
12/08/2025WebinaireMarcel Dubé