Excel Dashboards for Security & Safety Reporting
Turn incident and inspection data into a clear one-page dashboard with tables, pivot summaries and simple charts.
Why it matters
Managers act on what they can see. A clean dashboard turns logs into decisions.
Who it's for: Supervisors, coordinators and analysts who prepare monthly reports.
Learning objectives — by the end you can:
- Structure raw data as a table.
- Summarise with a pivot table.
- Choose the right chart and KPI.
Key terms
- Leading indicator
- Measures activity that prevents incidents, e.g. inspections completed.
- Lagging indicator
- Measures outcomes, e.g. injuries, thefts.
- Pivot table
- A tool that summarises rows by categories and totals.
Lesson notes
Steps
- 1Keep one row per event, one column per field (date, site, type, severity, status).
- 2Format as a Table (Ctrl+T) so formulas and charts grow automatically.
- 3Insert a PivotTable: rows = type, columns = month, values = count.
- 4Add a column chart for trends and a simple KPI tile (e.g. open actions overdue).
- 5Use COUNTIFS for KPIs, e.g. =COUNTIFS(Status,"Open",Due,"<"&TODAY()).
Choosing indicators
| Indicator | Type | Why |
|---|---|---|
| Inspections completed vs planned | Leading | Shows prevention effort |
| Near-miss reports | Leading | Shows reporting culture |
| Lost-time injuries | Lagging | Outcome |
| Overdue corrective actions | Leading | Shows follow-through |
Video lesson
Video to be added
A verified video from an official or reputable channel has not yet been selected for this topic. The text lesson above covers the full content.
Search YouTube for related videosPractical story: From 40 tabs to one page
Fictional teaching example
Situation. A site sent a 40-tab workbook to management every month. Nobody read it.
Known facts
- Data was inconsistent across tabs.
- No trend view existed.
Decisions
- Consolidated into one table and one dashboard sheet with four KPIs.
Outcome. Management review time fell; overdue actions halved in three months because they were visible.
Lessons
- Less is more.
- Make overdue actions visible.
- Consistent data first, charts second.
Worked example
Worked example: KPI formulas
| KPI | Formula (illustrative) |
|---|---|
| Open actions | =COUNTIFS(Actions[Status],"Open") |
| Overdue | =COUNTIFS(Actions[Status],"Open",Actions[Due],"<"&TODAY()) |
| Inspections % | =Done/Planned (format as %) |
Practice exercise
Download the corrective-action tracker, add 10 sample rows and build a pivot of actions by status and priority.
Corrective action tracker (CSV)Quiz
Sign in to save quiz results.
References
- Good practiceMicrosoft Support — Create a PivotTable
Verify current editions and applicability. Standards are copyrighted; consult licensed copies for exact requirements.
Report an issue with this contentRelated topics
Preparedness
Tabletop Exercises, Drills and After-Action Reviews
Test plans safely through discussion and drills, then capture lessons and track corrective actions to closure.
Risk Assessment
HIRA: Hazard Identification and Risk Assessment
Break work into activities, identify hazards, rate risk, apply the hierarchy of controls and verify that controls are actually in place.