Objectives of the training
To provide the knowledge and skills required to use the various features of Excel to create dashboards without VBA programming.Targeted audience
Managers and employeesPrerequisite
Intermediate knowledge of MS Excel. Experience with dynamic pivot tables (Course CH166).Trainers
Course architecture
Visualizing results
- Examples of dashboards: information systems, project management, budget preparation and monitoring, etc.
- Construction of the dashboard signage page: choice of indicators and visuals.
Functions :
- INDIRECT
- REPT
- ISERROR
- OFFSET
- VLOOKUP
Visuals and graphics :
- Thermometer
- Gantt charts
- Gauges
- etc.
Dashboards
- Advanced pivot tables
- GETPIVOTDATA
- PivotTable Wizard
- Etc. - Advanced macro commands with control buttons
If you have any questions about registration, cancellation, timetables, language of instruction, etc., you'll find the answers in our FAQ.
Training Notes
At the end of this training, yoiu will have a real exemple of dashboard for a company.
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote