OBJECTIVES
Know the tricks to save time in the realization of a dashboard Know the tools to use
Know how to perform automatic calculations and reports in other tables - Know how to graph the indicators
PUBLIC
Managers or HR Managers required to develop tables for monitoring their activities
REQUIREMENTS
Knowledge of the basic features of Excel
PROGRAM
The elaboration of the table
Analysis of data to enter
Creating and formatting the table
Establishment of indicators (verification, prevention ...)
Follow-up
Choice of statistical tools
Specific calculations (percentage, average, differences, cumulative ...)
Consolidation over several months or years
Conditional Formatting
Creation of cross tables
Graph generation
Table Analysis
Choosing the data to graphically represent
Graph generation
EDUCATIONAL TOOLS
Presentations
Exercises
Practical cases
Good to know
DURATION
0.5 days
Organizer
Reval
You will also like:
Sur demande
Stress'agile
Sur demande
Mbti discovery
Sur demande
Mbti agile
Great place to work Luxembourg or upon request
Communication basics
Great place to work Luxembourg or upon request
Develop your leadership
Sur demande
Developing assertiveness
Sur demande
Communicate better to avoid conflict
Sur demande
Develop positive relationships with your employees and...
Sur demande
Controlling difficult situations at work
REF.#178 - A MISTAKE? LET US KNOW
You could like it :
THE AGENDA
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
