VOTRE
FORMATION
Excel training workshop – Management reports for controller and analyst
$ 395
AF3490
Formation en ligne
6 heures (9h à 16h)
Anglais
En classe
RÉSUMÉ :
RÉSUMÉ :
Objectives
- 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
CALENDRIER :
| 14/08/2024 | 3095 boul Concorde Est, Laval, Formation en ligne | Stéphanie Perreault |
