logo-slvexpert

YOUR

TRAINING

Excel training workshop – Management reports for controller and analyst
$ 300
AF3490
et|icon_check_alt|
Webinar training - Online
et|icon_check_alt|
6 hours (9 to 16)
et|icon_check_alt|
English
et|icon_check_alt|
Webinar

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
Technical information Solutions D'Affaires SLV inc. will provide the laptop needed for this course.

YOUR TRAINERS:

CALENDAR :

14/12/2022Webinar training - OnlineStéphanie Perreault
17/03/2023Webinar training - OnlineStéphanie Perreault
12/05/2023Webinar training - OnlineStéphanie Perreault
14/08/2023Webinar training - OnlineStéphanie Perreault