Level 4 · Specialist
Excel Analyst
Dashboards and data visualisation
Plan, build and share interactive dashboards that people actually use, from the first sketch to a tested, shareable file.
Log in to open this level
Students log in to see their lessons and progress.
What is inside
1Dashboard thinking0/5
- A-1-1What makes a dashboard usefulComing soon
- A-1-2Operational, strategic and analytical dashboardsComing soon
- A-1-3Choosing the right KPIsComing soon
- A-1-4Knowing your audienceComing soon
- A-1-5Sketching a blueprintComing soon
2Preparing your data0/5
- A-2-1Clean data rules for reportingComing soon
- A-2-2Tables and named rangesComing soon
- A-2-3Power Query refresh pipelinesComing soon
- A-2-4Building a calculations sheetComing soon
- A-2-5Checking your numbersComing soon
3Layout and visual design0/5
- A-3-1Grids and alignmentComing soon
- A-3-2Visual hierarchyComing soon
- A-3-3Colour, fonts and accessibilityComing soon
- A-3-4Choosing the right visual for each questionComing soon
- A-3-5Designing for screens and for printComing soon
4Charts and KPI cards0/5
- A-4-1Building KPI cardsComing soon
- A-4-2Trend and comparison chartsComing soon
- A-4-3Sparklines and in cell chartsComing soon
- A-4-4Data bars, icon sets and colour scalesComing soon
- A-4-5Dynamic titles and labelsComing soon
5Interactivity0/5
- A-5-1Slicers and timelinesComing soon
- A-5-2Drop down selectorsComing soon
- A-5-3Form controlsComing soon
- A-5-4Linking several PivotTablesComing soon
- A-5-5Drill down viewsComing soon
6Advanced techniques0/5
- A-6-1Dynamic ranges with FILTER and XLOOKUPComing soon
- A-6-2Scenario switchesComing soon
- A-6-3Buttons and navigationComing soon
- A-6-4Scripts to refresh and exportComing soon
- A-6-5Testing a dashboard before releaseComing soon
7Performance and sharing0/5
- A-7-1Reducing file sizeComing soon
- A-7-2Efficient formulasComing soon
- A-7-3Protecting and sharing safelyComing soon
- A-7-4Sharing through Teams and SharePointComing soon
- A-7-5Handing off to Power BIComing soon
8Dashboard projects0/5
- A-8-1Project: sales performanceComing soon
- A-8-2Project: budget versus actualComing soon
- A-8-3Project: project statusComing soon
- A-8-4Project: HR headcount and turnoverComing soon
- A-8-5Project: operations and stockComing soon