Most advocacy and non-profit teams already have the numbers. They sit in a spreadsheet somebody maintains, in a case log, in a funding tracker, in a chapter’s monthly return. What is usually missing is a single place where those numbers add up in the same way every month, so a coordinator can answer “how much did we take in, how many matters did we close, and where is the workload sitting” without rebuilding a report from scratch.
The Civil Rights Organizations Dashboard in Excel is that place. It is a five-page Microsoft Excel template – a reporting layer that sits on top of a flat table of your own case and funding records and summarises them into linked, filterable pages.
One thing to state plainly up front, and it will come up again below: everything in the screenshots is demo data. The workbook ships with 500 invented rows so the charts render before you load anything. The chapter names, case managers, amounts and counts describe no real organisation, no real matter and no real person. They exist so you can see the layout working, and they are meant to be deleted.
What This Template Is – And What It Is Not
It is worth being precise, because the subject area invites assumptions the template does not support.
What it is: an administrative reporting template. It counts rows, sums amounts, and groups both by whatever labels you have entered. Every figure on every page is a plain sum or count of data you supplied.
What it is not:
- It is not a case-management system. No intake forms, no document storage, no reminders, no user roles, no audit trail.
- It does not assess or establish anything about the matters recorded in it. It does not evaluate legal merit, does not measure discrimination, and produces no human-rights or regulatory findings.
- It offers no legal advice and makes no compliance claims. Nothing in it replaces professional counsel.
- It is not a funder reporting standard. If a grant requires a particular format, produce that format; this is an internal management view.
The labels visible in the sample data – programme areas, advocacy types, case stages, case statuses – are placeholders. They are ordinary text values in a spreadsheet column, chosen so the demo looks plausible. They are not a recommended taxonomy and carry no endorsement. Replace them with your own organisation’s vocabulary; the charts follow whatever you type.
Page 1 – Overview
The landing page carries five headline cards: Total Funds Raised, Total Cases Resolved, Total Case Records, Net Program Balance and an Average Impact Score tile with a star rating. Underneath, a Resolution Rate % gauge sits beside Total Funds Raised by Chapter and Total Cases Resolved by Advocacy Type, with Resolution Rate % by Case Manager running across the bottom.
Slicers frame the page – Month and Chapter down the left, Case Manager and Case Stage down the right. They are synced across all five pages, so a filter you set here holds as you navigate.
Worth noting what the Average Impact Score card actually is: an average of a numeric column in your data. The stars are formatting. If you do not keep such a score, leave the column blank or repurpose it – the card will read whatever you put there, and it means nothing the template invents on its own.
Page 2 – Funding Trend
The time-series page. Funds Raised vs Pledged Funding by Month is the useful one for most teams: committed money and received money on the same twelve rows, so the gap between a pledge and a deposit is visible rather than assumed. Total Funds Raised by Quarter gives the condensed four-point version for a board pack.
Alongside those, Total Cases Resolved vs Total Cases Opened by Month plots workload coming in against workload going out on a shared axis, and Total Funds Raised by Region splits the annual figure five ways.
Page 3 – Program Areas
This page answers the cost question. Funds Raised vs Outreach Cost by Program Area puts spend next to income for each programme label, so you can read the two together rather than in separate reports. Total Clients Served by Program Area counts people reached. Cases Resolved vs Cases Opened by Program Area pairs the two counts per programme, and Total Case Records by Funding Band groups records into low, medium and high bands.
The demo file uses seven programme labels. They are there to populate the axis and nothing more – rename them to your own programme list and refresh, and the seven become however many you actually run.
Page 4 – Chapter Impact
The same data cut by location and by staff member. Cases Resolved vs Cases Opened by Chapter ranks the ten sample chapters with both counts side by side. Total Funds Raised by Case Manager and Total Case Records by Case Manager split the same figures eight ways, and Total Clients Served by Chapter shows reach per location.
A caution about this page, since it names individuals: a case count is a volume measure, not a performance measure. Two case managers carrying very different counts may be carrying very different work. The dashboard shows the distribution; interpreting it is a management conversation, not something the chart settles.
Page 5 – Case Pipeline
A stage view of the open file. Total Case Records by Case Stage counts records sitting at each of the five stages in the sample data. Total Pledged Funding by Case Stage puts committed funding beside those same stages. Total Case Records by Case Status splits the file four ways – resolved, in progress, under review and referred out.
Stage and status names are, again, text columns. If your workflow has three stages or nine, edit the values and refresh.
How It Is Built
Nothing exotic, which is the point – anyone comfortable in Excel can open it up and see how it works.
- One flat data sheet. A single table, one row per case record, with the case, chapter, manager, programme, stage, status, funding and cost columns alongside each other.
- Pivot tables on a support sheet. Each chart is fed by its own pivot table. Nothing is hard-coded to a cell range that breaks when you add rows.
- Pivot charts on the report pages. Seventeen of them across the five pages.
- Page-synced slicers connected to every relevant pivot, which is what makes a Month or Chapter selection persist across pages.
- No macros. It is a plain .xlsx. No security warning, no Enable Content prompt, no VBA to audit.
Loading Your Own Data
- Open the .xlsx and click through all five pages with the demo data in place, so you can see which column feeds which chart.
- Go to the data sheet and delete the 500 sample rows. Leave the header row alone.
- Paste your own records under the same headers.
- Rename the programme, advocacy type, stage and status values to your own terms.
- Press Data > Refresh All.
That is the whole workflow. Every pivot table, chart, card and slicer updates from that one action. If a chart looks empty afterwards, it is almost always because a column header was renamed or a slicer still has an old value selected – clear the slicers and refresh again.
Limitations Worth Knowing Before You Buy
No template is a fit for everyone, and a few of these are structural rather than cosmetic:
- Slicers need desktop Excel. The file opens in Excel for the web and the charts render, but slicer and pivot-chart behaviour is limited there. Use the desktop app.
- It is a single-user file. There is no concurrent editing model beyond whatever your file-sharing setup provides.
- It reports the past. There is no forecasting, no target-setting and no variance-to-plan logic.
- The month dimension is a Month column, not a full date hierarchy. If you need day-level drilldown you will be extending it yourself.
- Data protection is your responsibility. Case records about individuals may be sensitive in your jurisdiction. The template does not encrypt, redact or restrict anything – where you store the completed file and who can open it are decisions you make.
Frequently Asked Questions
Does this dashboard measure discrimination or assess legal merit?
No. It is arithmetic over your own records – counts and sums, presented as charts. It reaches no conclusions of any kind about the matters it reports on.
Is the data in the screenshots real?
No. All 500 rows are invented demo data supplied for preview only. Delete them before use.
Can I rename the programme areas and case stages?
Yes, and you should. They are plain text columns and the charts pick up whatever you type after a refresh.
Does it have macros?
No. Plain .xlsx, nothing to enable.
What Excel version do I need?
Excel 2016 or later on Windows or Mac, or Microsoft 365.
Can I rebrand it?
Yes – colours, fonts, logo and layout are all editable for your own or your client’s internal use.
Is there a Power BI version?
Yes. The Civil Rights Organizations Dashboard in Power BI covers the same five pages for teams already working in Power BI Desktop.
Get the Template
The Civil Rights Organizations Dashboard in Excel is available now on NextGenTemplates – instant download, one .xlsx workbook in a ZIP, unlimited re-downloads.
Related templates you may find useful:
- Civil Rights Organizations Dashboard in Power BI – same five pages, Power BI Desktop
- Civil Rights Organizations KPI Dashboard in Excel – a compact monthly scorecard rather than an analytical dashboard
- Channel Development Teams Dashboard in Excel
- Climate Tech Startups Dashboard in Excel
- Cloud Gaming Dashboard in Excel
