Financial Dashboarding with Excel Training Course

Duration 5 days 10 modules · 33 contact hours
Level Intermediate Certificate on completion
Who attends Financial Analysts, Finance Managers and others
Fee from USD 1,100 KSh 95,000 for Kenyan organisations
Where 52 cities + online See dates by city
Next start 16 Nov 2026 Course code SD-BI-173

Before you join: Participants should be comfortable using Excel formulas, sorting and filtering data, creating basic charts, and working with worksheets and workbooks.

Dates & prices

Two start dates a month in every city, and live online on weekdays or weekends. Fees are per participant; classroom fees include tuition, materials, lunch and refreshments, and the certificate.

Suggest a date or city

Showing the next six months. Later dates, other cities and private deliveries for your team are available on request.

Course overview

Finance teams often spend too much time reconciling exports, updating report packs and explaining inconsistent figures. A well-designed Excel dashboard turns periodic financial data into an agreed management view of revenue, margin, operating expenditure, working capital, cash flow and forecast performance. The challenge is not chart production alone: it is defining consistent measures, building a reliable data model, applying appropriate comparisons and presenting exceptions that require management action.

This course teaches participants to design, build and maintain financial dashboards in Microsoft Excel. Participants structure source data, clean imports with Power Query, create relationships in the Excel Data Model, and calculate financial measures with PivotTables, Power Pivot and DAX. They develop dashboards for monthly management reporting, budget-versus-actual analysis, variance investigation, profitability reporting, rolling cash forecasting and KPI monitoring. The course also addresses chart selection, interactive controls, dashboard layout, controls over refreshes and the documentation needed for recurring reporting.

Teaching combines concise instructor briefings with guided case work based on realistic finance-reporting scenarios. Participants work with financial datasets resembling those used by corporate finance teams, banks, public bodies and programme-funded organisations. They diagnose reporting requirements, define a KPI dictionary, build dashboard components and test outputs against management questions. Each participant leaves with a reusable Excel financial dashboard template, a structured KPI definition sheet, a data-refresh checklist and a dashboard design plan that can be adapted to their reporting cycle.

The course is suited to finance professionals and analysts who already use Excel and need to produce more reliable, decision-focused reporting. It is also relevant to business intelligence staff who support finance functions and need a practical understanding of financial reporting measures.

What you will be able to do

  • Define a financial dashboard specification using management questions, KPIs and reporting cadence
  • Prepare structured financial source data using Excel Tables and Power Query transformations
  • Build an Excel Data Model with relationships between actuals, budgets and dimensions
  • Create DAX measures for variances, margins, growth rates and rolling periods
  • Design interactive PivotTable dashboards using slicers, timelines and linked visualisations
  • Apply variance analysis methods to identify material financial performance drivers
  • Implement dashboard controls for reconciliations, refresh procedures and exception checking
  • Produce a reusable financial dashboard template and KPI definition sheet

Benefits of attending

For you

  • Reduce manual monthly report preparation through reusable dashboard structures
  • Present budget and performance variances with clearer financial narratives
  • Build credible Excel reporting models using documented calculation logic
  • Identify data-quality issues before figures reach senior management
  • Create a portfolio-ready financial dashboard for workplace use

For your organisation

  • Shorten reporting cycles through standardised data preparation and refresh processes
  • Improve consistency between finance packs, budget reports and management dashboards
  • Give managers faster visibility of material variances and emerging risks
  • Reduce spreadsheet errors through reconciliations, control checks and documented KPIs
  • Reuse a common dashboard structure across departments, projects and reporting periods

Course modules

10 modules over 5 days

Participants can define a dashboard brief that links management decisions to financial KPIs.

  • Management questions translated into dashboard objectives, users, decisions and reporting cadence
  • Financial KPI hierarchy covering profitability, liquidity, efficiency, growth and forecast accuracy
  • KPI dictionary fields for definition, formula, owner, source and refresh frequency
  • Actual, budget, forecast and prior-period comparisons matched to decision requirements
  • Materiality thresholds defined for revenue, cost, margin and cash variances
  • Dashboard wireframes organised around executive summary, drivers and exceptions
  • RAG status rules based on thresholds, trends and approved performance targets

Participants can structure and validate financial data for repeatable dashboard production.

  • Excel Tables used to standardise transactions, budgets, forecasts and account mappings
  • Chart-of-accounts mappings aligned with reporting categories and management cost centres
  • Normalised data structures separating facts, dimensions, dates and reference tables
  • Data-quality checks for duplicates, missing values, invalid dates and sign conventions
  • Period calendars configured for fiscal years, quarters, months and reporting cut-offs
  • Source-to-report reconciliation checks comparing dashboard totals with finance extracts
  • Named ranges and structured references supporting maintainable financial workbook formulas

Participants can use Power Query to clean, combine and refresh recurring financial data.

  • Power Query connections created from workbooks, CSV files and folder imports
  • Column profiling used to identify nulls, errors, outliers and inconsistent types
  • Unpivot transformations convert monthly budget columns into analysis-ready transaction rows
  • Merge queries join actuals with account mappings, budgets and organisational dimensions
  • Append queries combine monthly extracts using consistent field structures
  • Custom columns classify revenue, expenditure, direct costs and overhead allocations
  • Refresh parameters manage reporting periods, source locations and controlled updates

Participants can build a related Excel Data Model for multi-dimensional financial reporting.

  • Fact tables separated from account, entity, department, project and calendar dimensions
  • One-to-many relationships configured between financial transactions and reporting dimensions
  • Date tables marked for time intelligence and consistent period filtering
  • Granularity assessed before combining ledger, budget, forecast and headcount data
  • Surrogate keys used where source-system labels are duplicated or inconsistent
  • Power Pivot diagrams reviewed for ambiguous relationships and disconnected tables
  • Data Model design documented through source, transformation and relationship maps

Participants can write DAX measures for core financial calculations and period comparisons.

  • Explicit measures created for actuals, budgets, forecasts and prior-year results
  • CALCULATE modifies filter context for selected entities, accounts and reporting periods
  • Variance measures calculate absolute differences, percentage differences and favourable signs
  • DIVIDE handles margin percentages and prevents misleading divide-by-zero errors
  • Time intelligence calculates month-to-date, year-to-date and rolling twelve-month values
  • Contribution analysis measures revenue mix, cost drivers and profit movements
  • Measure names, formats and display folders standardise finance reporting outputs

Participants can analyse financial movements and identify the drivers requiring management attention.

  • Price-volume-mix analysis separates commercial drivers of revenue and gross margin
  • Waterfall charts explain bridges between budget, actual and forecast performance
  • Trend analysis compares monthly run rates with seasonal patterns and targets
  • Drill-down paths trace material variances from totals to accounts and transactions
  • Pareto analysis ranks cost centres, products or projects by variance contribution
  • Rolling forecasts compared against approved budget baselines and latest actuals
  • Narrative commentary distinguishes one-off effects from recurring performance drivers

Participants can create clear financial dashboard layouts and select suitable visualisations.

  • Dashboard layout applies visual hierarchy, reading paths and disciplined use of whitespace
  • KPI cards display current value, comparator, variance and directional indicator
  • Line charts show revenue, cash and margin trends across reporting periods
  • Bar charts compare departments, projects, products and budget variance rankings
  • Waterfall charts communicate financial bridges without obscuring component values
  • Sparklines provide compact trend indicators beside financial summary measures
  • Conditional formatting highlights exceptions using data bars, icons and threshold rules

Participants can assemble interactive Excel dashboards that support controlled management exploration.

  • PivotTables summarise measures by entity, period, account and reporting category
  • Slicers filter dashboard views by department, region, project and business unit
  • Timelines control monthly, quarterly and annual financial reporting periods
  • Report connections synchronise slicers across multiple PivotTables and PivotCharts
  • GETPIVOTDATA retrieves controlled summary values for dashboard KPI cards
  • Dynamic titles display selected period, entity and scenario context
  • Drill-through sheets provide supporting detail behind executive dashboard metrics

Participants can implement controls and maintenance procedures for dependable financial dashboards.

  • Control totals reconcile dashboard values to general ledger and budget extracts
  • Refresh checklists confirm source completeness, query status and reporting period selection
  • Exception logs record data issues, overrides, ownership and resolution dates
  • Workbook protection separates input cells, formulas, outputs and approved templates
  • Version control conventions identify reporting cycle, release date and preparer
  • KPI change governance documents revised definitions, formulas and approval records
  • Performance tuning reduces unnecessary formulas, duplicated queries and oversized ranges

Participants can plan the implementation of an Excel dashboard within their own reporting process.

  • Monthly close timetable aligned with data availability, validation and dashboard publication
  • Stakeholder review criteria assess relevance, clarity, accuracy and actionability
  • Dashboard adoption plan assigns owners for data, measures, review and distribution
  • Reporting pack integration positions dashboard outputs alongside commentary and supporting schedules
  • Access requirements identify confidential finance data and approved distribution groups
  • Improvement backlog prioritises new KPIs, automation opportunities and usability changes
  • Ninety-day application plan defines workplace dashboard milestones and review points

Exercises and examples are adapted to each cohort's sectors and roles.

What you take back to work

  1. Financial dashboard requirements template
  2. KPI dictionary and calculation sheet
  3. Power Query financial data-preparation template
  4. Excel Data Model relationship map
  5. DAX financial measures library
  6. Dashboard refresh and reconciliation checklist

Who should attend

  • Financial Analysts — need faster, more consistent management reporting from recurring finance data
  • Finance Managers — require clear KPI views for performance reviews and resource decisions
  • Management Accountants — need to explain budget, forecast and actual variances visually
  • FP&A Professionals — need interactive reporting for planning cycles and forecast reviews
  • Business Intelligence Analysts — support finance teams with Excel-based reporting solutions
  • Project Finance Officers — need to monitor budgets, spend, commitments and funding performance

Skills and tools covered

Financial KPI designPower Query transformationDAX measure writingVariance analysisDashboard visual designReporting controls

Tools and standards

Microsoft Excel, Power Query, Power Pivot, DAX

How the course runs

Training methodology

The course uses short technical briefings followed by instructor-guided case work in Excel. Participants analyse financial reporting requirements, prepare source files, construct measures and assemble dashboard views from realistic monthly reporting scenarios. Group discussions examine KPI definitions, chart choices, variance explanations and common reporting errors. Trainers demonstrate Power Query, PivotTables, the Data Model and DAX before participants apply each technique to structured datasets. The final sessions use review simulations and application planning to connect course outputs to participants' own reporting cycles.

Requirements and prerequisites

Participants should be comfortable using Excel formulas, sorting and filtering data, creating basic charts, and working with worksheets and workbooks. Familiarity with common finance terms such as revenue, gross margin, operating expenditure, budget, actuals and variance is expected. Participants should have experience handling recurring financial reports or datasets, although they do not need to be qualified accountants. Prior experience with Power Query, Power Pivot, DAX, VBA, SQL or dedicated business intelligence platforms is not required. The course focuses on Excel desktop features available in current Microsoft 365 versions.

A typical training day

08:30 – 10:30First session
10:30 – 10:45Refreshment break
10:45 – 12:30Second session
12:30 – 13:30Lunch and networking
13:30 – 15:00Third session
15:00 – 15:15Refreshment break
15:15 – 16:30Workshop and daily review

Live online deliveries follow the same structure in East Africa Time, with shorter screen blocks and longer breaks.

What the fee includes

  • Instruction by a practitioner facilitator
  • Full course workbook and materials
  • Exercise files, templates and case studies
  • Refreshments and lunch on classroom deliveries
  • Certificate of completion
  • Post-course application plan

Frequently asked questions

You should be comfortable with formulas, worksheets, sorting, filtering and basic charts. You do not need previous experience with Power Query, Power Pivot or DAX, as these are taught from their financial reporting use cases.

Bring a laptop with a current desktop version of Microsoft Excel, preferably Microsoft 365. You may also bring a non-confidential sample of a recurring financial report or dashboard requirement for use during application planning.

The course is designed primarily for financial analysts, management accountants, FP&A staff and finance managers. It also suits business intelligence analysts who support finance reporting and need to understand financial KPIs.

This course focuses on financial reporting logic, including actuals, budgets, forecasts, variances, margins, cash and reconciliations. It uses Excel features rather than Power BI, while introducing Data Model and DAX techniques that are relevant to both environments.

Participants can use the templates and methods to improve monthly management packs, budget-monitoring reports, project finance dashboards and forecast reviews. The final module helps participants identify a suitable workplace dashboard and plan its first implementation steps.

The programme contains ten modules taught in sequence across five training days, with approximately 6.5 contact hours each day. Time is divided between instructor demonstrations, guided Excel work, financial reporting cases, peer discussion and implementation planning.

Questions about this course?

Ask about dates, fees, group bookings or running it for your team. Our training team replies by email.

Ask on WhatsApp info@skillsetdevelopment.com

More courses in Business Intelligence

Business Intelligence Excel Dashboard Design for Management Reporting Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Excel Dashboard Development Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Excel Power Query and Power Pivot Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Excel for Business Intelligence Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Financial Modelling with Power BI Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Operational Dashboards Using Excel Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Power BI Business Intelligence Training Course 5 days · from USD 1,100 · next 16 Nov Business Intelligence Power BI Data Analysis and Visualisation Training Course 5 days · from USD 1,100 · next 16 Nov