Excel training workshop – Management reports for controller and analyst

ACTIVITY OFFERED IN PARTNERSHIP

  • Partner: SLV Expert inc.
  • Registration/cancellation: Follow the Order’s normal procedure.
  • Final registration confirmation sent by: SLV Expert inc.
  • Price: Please see the schedule fee below. Prices are subject to change without notice.
  • Location: Verify your registration confirmation. You will receive it in the days following your registration or in the days preceding the course.
  • Lunch: Not included

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

Technical information

SLV Expert inc. will provide the laptop needed for this course.

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

Description complète


Laval – SLV Expert inc.


Séance(s)
Pour tous

Saison de formation : 2019-2020
No de séance : 6798
Date de début : 2020-04-03, 09:00
Date de fin : 2020-04-03, 16:00
Durée : Un jour
Animateur : Animateur du partenaire
Renseignements complémentaires : You can see the suggested order of training worshop and prerequisites on www.slvexpert.com/cpa

Grille tarifaire

8 places disponibles

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O

Pour tous

Saison de formation : 2019-2020
No de séance : 6301
Date de début : 2020-07-02, 09:00
Date de fin : 2020-07-02, 16:00
Durée : Un jour
Animateur : Animateur du partenaire
Renseignements complémentaires : You can see the suggested order of training worshop and prerequisites on www.slvexpert.com/cpa

Grille tarifaire

7 places disponibles

  Membre CPA Non-membre
À la carte 395,00 $ 425,00 $
Passeport CPA 525 CDP S/O
Passeport Multi-CPA 525 CDP S/O
Passeport Multi-usagers 525 CDP 675 CDP
Promo CPA 525 CDP S/O

Aucune formation à distance trouvée.

1.0.0.0