Excel training workshop – Management reports for controller and analyst
$ 395
AF3490
Webinaire
6 heures (9h à 16h)
Anglais
Aussi disponible en entreprise
RÉSUMÉ :
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.
- 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/2025 | Webinaire | Marcel Dubé | |
12/08/2025 | Webinaire | Marcel Dubé |