Excel Data Visualisation & Dashboards Training Course
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: Excel Data Visualisation & Dashboards Training Course
This expert-level Excel Data Visualisation & Dashboards training course teaches you to turn raw data into clear, impactful and professional dashboards. Over two highly practical days, you will discover the principles of good data visualisation, master advanced and customised charts, then design readable indicators using conditional formatting. You will build a genuine interactive dashboard that is refreshable and ready to share. By the end, you will be able to give meaning to your figures and support decision-making.
Complementary courses: to go further, also discover Excel PivotTables Training Course, Excel for Business Reporting & Management Training Course and Power BI Expert DAX Training Course.
Good to know
The sessions are guaranteed from the first registration (except in cases of force majeure).
A preliminary interview takes place between the participant and/or a company contact in order to fully take into account the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment: during the course, the trainer assesses participants’ learning progress through quizzes, role-play and practical exercises. Participants receive a certificate of completion at the end of the course.
This training course is part of our Power Platform Training Courses catalogue. Explore all our Power Platform courses to automate, analyse and build your business applications without code.
Objectives of the training: Excel Data Visualisation & Dashboards Training Course
By the end of the course, participants will be able to:
- apply the principles of effective data visualisation;
- create advanced and customised charts;
- design readable key indicators (KPIs);
- use conditional formatting for visualisation;
- build an interactive dashboard;
- automate and refresh a dashboard.
Prerequisites of the training: Excel Data Visualisation & Dashboards Training Course
To follow this course under the best conditions, it is recommended to be proficient with Excel’s PivotTables and charts, or to have completed an advanced-skills Excel course. Because every participant is unique, a personalised interview is held beforehand in order to adapt the pace and practical cases to your context.
Detailed programme of the training: Excel Data Visualisation & Dashboards Training Course
Data visualisation principles
Advanced and customised charts
Indicators and conditional formatting
Building an interactive dashboard
Automating and refreshing the dashboard
The highlights of this training course
FAQ
What is data visualisation?
Data visualisation means representing data in graphical form (charts, indicators, gauges) to make it easier to understand and to support decision-making. In Excel, it relies on charts, conditional formatting and dashboards — at the heart of this course.
What is the difference between a chart and a dashboard?
A chart represents a data series; a dashboard brings together several indicators and charts, often interactive, to provide an overview and support business steering. The course teaches you to design complete, refreshable dashboards.
Do you need an advanced level to take this course?
Yes, this is an expert-level course. It is recommended to be proficient with Excel’s charts and PivotTables, or to have completed an advanced-skills course. A preliminary interview helps confirm your level.
How long does the Excel Data Visualisation & Dashboards training course last?
The course lasts 2 days, i.e. 14 hours. Sessions are guaranteed from the first registration and take place in a small group of 1 to 3 participants. The programme can be customised and organised at your premises.
Is this course eligible for CPF or OPCO funding?
This course is funded directly by the company and is not eligible for CPF. Depending on your situation, funding by your OPCO may be considered: contact us to explore the funding options suited to your project.
.elementor-accordion .elementor-tab-title .elementor-accordion-icon{margin-right:10px}.elementor-accordion .elementor-tab-title .elementor-accordion-icon + a,.elementor-accordion .elementor-tab-title .elementor-accordion-title{padding-left:4px}