Microsoft Excel Dashboards
Learn how to build effective and functional dashboards to communicate key figures on our one day Excel : Dashboards course. Ideal for those who want to build on their knowledge and gain confidence using Excel's interactive and dynamic features.
On this tutor led course you’ll learn how to use formulas and pivot tables to analyse data and find key insights. You’ll learn how to create an interactive dashboard using charts, Pivot Charts, Slicers, and Dropdowns.
Finally, you'll learn how to link metrics back to your raw data for seamless updates. You'll need to be comfortable with basic formulas, absolute references, and the SUMIF, COUNTIF, and AVERAGEIF functions before attending this course, we recommend completing our intermediate course first.
Clean and prepare data
Analyse data with formulas and pivot tables
Design visualisations and add interactivity
Test functionality and dynamic features
Prepare your dashboard for sharingYou need to be comfortable with basic formulas and absolute references before joining this course.
Course leader is an experienced industry expert
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | Action |
|---|---|---|---|---|---|---|---|
| 28th Jul 25 | Mon | London Bridge | Available | £399.00 | £70.00 | £329.00 + VAT | |
| 24th Sep 25 | Wed | London Bridge | Available | £399.00 | £399.00 + VAT | ||
| 8th Oct 25 | Wed | London Bridge | Available | £399.00 | £399.00 + VAT | ||
| 4th Dec 25 | Thu | London Bridge | Available | £399.00 | £399.00 + VAT | ||
| 28th Jan 26 | Wed | London Bridge | Available | £399.00 | £399.00 + VAT | ||
| 26th Mar 26 | Thu | London Bridge | Available | £399.00 | £399.00 + VAT | ||
| 20th May 26 | Wed | London Bridge | Available | £399.00 | £399.00 + VAT |
| Course Dates | Days | Location | Places | RRP | Discount | You Pay | Action |
|---|---|---|---|---|---|---|---|
| 28th Aug 25 | Thu | Online | Available | £399.00 | £70.00 | £329.00 + VAT | |
| 29th Sep 25 | Mon | Online | Available | £399.00 | £399.00 + VAT | ||
| 3rd Nov 25 | Mon | Online | Available | £399.00 | £399.00 + VAT | ||
| 5th Jan 26 | Mon | Online | Available | £399.00 | £399.00 + VAT | ||
| 23rd Feb 26 | Mon | Online | Available | £399.00 | £399.00 + VAT | ||
| 27th Apr 26 | Mon | Online | Available | £399.00 | £399.00 + VAT | ||
| 15th Jun 26 | Mon | Online | Available | £399.00 | £399.00 + VAT |
Importing data from external sources (CSV, databases, web, etc.)
Using Power Query to dynamically update externally linked data
Removing duplicates, handling missing values, and correcting errors
Standardise data with the TRIM, CLEAN, or TEXT() functions
How to use Excel’s Remove Duplicates and Power Query's Transform tools for preprocessing
Organising raw data into a separate sheet or area
Using tables for easy referencing, sorting, and filtering
Identify key metrics and the purpose of your dashboard
Use Excel formulas (SUMIFS, COUNTIFS, AVERAGE, IF, XLOOKUP) to derive insights
Leverage pivot tables for dynamic analysis
Identify key performance indicators (KPIs) relevant to your audience (e.g., sales trends,
profit margins)
Breaking data into manageable sections
Choosing the right chart for your data
Highlight key numbers with heatmaps, data bars, or custom formatting
Using charts directly tied to PivotTables for interactive visualisations
Designing a clear and logical flow
Using text boxes or shapes for labels and instructions
Adding Slicers for easy filtering on PivotTables/Charts
Using Dropdowns via Data Validation for user inputs
Align charts, slicers, and shapes perfectly
Tie metrics to raw data dynamically with cell links
Using named ranges for dynamic data updates
Creating dynamic chart titles using formulas like ="Sales for "&A1
Incorporating a colour palette (e.g., corporate branding)
Design tips
Verifying interactivity (e.g., slicers, dropdowns)
Double-checking for broken formulas or incomplete data links
Hiding raw data sheets
Locking cells to protect data
Saving as .XLSX or .XLSM (if macros are included)
Exporting as a PDF for static sharing
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Upskill your team together. Build your team and develop consistency, and collective confidence.
Define your direction with purpose, aligning your learning journey to personal and career goals.
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
From £329 + VAT
From £299 + VAT
From £329 + VAT
