logo-slvexpert

YOUR

TRAINING

Excel training workshop – Management reports for controller and analyst
$ 395
AF3490

Webinar training - Online

6 hours (9 to 16 eastern time)

English

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/08/2024Webinar training - OnlineStéphanie Perreault
08/10/2024Webinar training - OnlineFrançois Jasmin CPA, CA
04/02/2025Webinar training - OnlineFrançois Jasmin CPA, CA
13/05/2025Webinar training - OnlineFrançois Jasmin CPA, CA
12/08/2025Webinar training - OnlineFrançois Jasmin CPA, CA