Tailor-made training course on “Creating and using dashboards in Excel”

The aims of the training course are:

• To design dashboards in Excel to improve the management of your activity.
• To identify data and become skilled in the use of data for the creation of dashboards.
• To have a good understanding of the key features for creating dashboards and enhancing the presentation of data.

The topics that will be addressed during the training course are as follows:

Topic 1: Excel in the preparation and analysis of data

• Control of source data entry.
• Data import and fixing of import errors.
• Data consolidation.
• Statistical analysis of data.
• Pivot tables.

Topic 2: Automating dashboards with Excel

• Formatting indicator dashboards to facilitate their interpretation.
• Highlighting data through conditional formatting and visual alerts.
• Creating graphical dashboards.
• Optimising and automating calculations and charts.
• Map representations in Excel.

The services provided for this training course are of the following types:

• hiring of the expert trainer and management of the contracting process;
• design, validation and sending of the training materials;

evaluation of the training course and provision of certificates to the participants.