Excel Training Workshop - management Reports for Controler and Analyst

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 managemen... Lire la suite

Niveau
intermédiaire
Mode de formation
Sur mesure
6 heures
1 groupe disponible
Langue
Anglais

  • 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

For controller and analyst

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.

Sur mesure

Partager

Vous cherchez le meilleur expert pour votre entreprise?

Découvrez le forfait qui vous convient!

Vous êtes formateur?

Découvrez pourquoi des milliers de formateurs choisissent Boomrank

Entreprise de formation

SLV Expert inc

SLV Expert inc

  • Canada
Fiche de l'entreprise

Formateurs

François Jasmin, CPA, CA

François Jasmin, CPA, CA

CPA, CA


Disponibilité(1)