YOUR
TRAINING
Excel training workshop – Management reports for controller and analyst
$ 395
AF3490
Webinar training - Online
6 hours (9 to 16 eastern time)
English
Live Webinar
Summary :
Summary :
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 matrix functions to make reports
- Use the macro commands in management reports
SEE MORE
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
YOUR TRAINERS:
CALENDAR :
| 13/05/2025 | Webinar training - Online | Marcel Dubé | |
| 12/08/2025 | Webinar training - Online | Marcel Dubé |
