OBJECTIVES
Know the tricks to save time in the realization of a dashboard
Know the tools to use
Know how to carry out automatic reports in other tables
PUBLIC
Managers, service or project managers to develop tables for tracking their data
REQUIREMENTS
Knowledge of the basic features of Excel
PROGRAM
The development of the dashboard
Analysis of data to enter
Definition of objectives
Identify relevant indicators
The data
Links between tables
Consolidation
Creation of cross tables
Protect data
Protect the calculation ranges
Protect the sheet
Protect the workbook
Presentation
Conditional Formatting
Specific graphics
EDUCATIONAL TOOLS
Presentations
Exercises
Practical cases
Good to know
DUREE
0,5 jour
Organizer
Reval
You could like it :
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
