Ravindra BagaleCourses & study guides मराठी Track your progress

Excel Dashboards: 52 Free Dashboard Templates (Brand, Industry and Business)

All Excel dashboards on this site are on this one page. There are 4 groups: brand dashboards, industry dashboards, business systems with a dashboard, and lessons that teach you to build one. Every workbook is free to download.

About this page

Pick a group. Open a guide. Download the workbook. Change the drop-downs and see the KPIs change. All data is made up for practice.

Why, what and how

Why

Managers and interviewers ask: "Which KPIs would you track for this business?" A ready dashboard helps you answer and practise.

What

Group Count What you get
1. Brand dashboards 15 Themed dashboards inspired by famous businesses, 15 KPIs, 6 charts, 3 filters
2. Industry dashboards 11 One dashboard per industry, plus a Top 10 Companies dashboard
3. Business systems with a dashboard 26 Complete small-business systems (billing, stock, fees) with a dashboard sheet
4. Learn to build dashboards 9 Chapters, lessons, practice and interview questions

How

  1. Pick a group below.
  2. Open the guide page.
  3. Download the .xlsx file.
  4. Change the drop-down filters.
  5. Then build your own with group 4.

1. Brand dashboards (15)

Blinkit-style quick commerce dashboard in Excel with KPI cards and charts (example data)
Blinkit Dashboard in Excel: Quick Commerce KPIs, 10-Minute Delivery, AOV and Cancellations
A quick commerce app promises groceries in about 10 minutes. The owner must see speed, basket size and cancellations every day.
Open the guide · Download .xlsx
Swiggy-style food delivery dashboard in Excel with KPI cards and charts (example data)
Swiggy Dashboard in Excel: Food Delivery KPIs, Kitchen Prep Time, On-Time % and Rain Delays
A food delivery app must bring hot food fast. Kitchen time, rider time and rain all change how happy the customer is.
Open the guide · Download .xlsx
Zomato-style restaurant partner dashboard in Excel with KPI cards and charts (example data)
Zomato Dashboard in Excel: Restaurant Partner KPIs, Take Rate, Dining-Out, Complaints and Refunds
A food platform earns commission from restaurants. It must watch take rate, dining-out bookings, complaints and refunds.
Open the guide · Download .xlsx
PhonePe-style UPI payments dashboard in Excel with KPI cards and charts (example data)
PhonePe Dashboard in Excel: UPI Payment KPIs, Success Rate, TPV, Failures and Latency
A UPI app handles lakhs of payments. Every failed or slow payment is an unhappy user, so success rate and speed matter most.
Open the guide · Download .xlsx
Paytm-style merchant payments dashboard in Excel with KPI cards and charts (example data)
Paytm Dashboard in Excel: Merchant Payments, Soundbox, Settlement Time and Loan KPIs
A payments company serves shops. It earns fees and device rent, gives loans and must send money to shops quickly.
Open the guide · Download .xlsx
Facebook-style ads manager dashboard in Excel with KPI cards and charts (example data)
Facebook Ads Dashboard in Excel: Spend, CPM, CTR, CPC, Cost per Lead and ROAS
Small businesses spend money on Facebook ads. They must know which ads bring clicks, leads and sales for each rupee.
Open the guide · Download .xlsx
Instagram-style creator studio dashboard in Excel with KPI cards and charts (example data)
Instagram Creator Dashboard in Excel: Reach, Engagement Rate, Saves, Followers and Brand Deals
A creator posts reels, photos and stories. They must know which posts reach people, get engagement and earn brand deals.
Open the guide · Download .xlsx
Netflix-style streaming dashboard in Excel with KPI cards and charts (example data)
Netflix Dashboard in Excel: Subscribers, Churn Rate, ARPU and Watch Hours
A streaming app earns a monthly fee. It must keep people watching, or they cancel (churn).
Open the guide · Download .xlsx
Snapchat-style daily engagement dashboard in Excel with KPI cards and charts (example data)
Snapchat Dashboard in Excel: Daily Engagement, Snap Open Rate, Streaks, Lenses and Ad Revenue
A camera and chat app lives on daily habits. Time spent, streaks and lenses show if users love it; ads bring the money.
Open the guide · Download .xlsx
WhatsApp Business-style messaging dashboard in Excel with KPI cards and charts (example data)
WhatsApp Business Dashboard in Excel: Read Rate, First Reply Time, Resolution and Chat Sales
Shops and clinics talk to customers on WhatsApp. They must reply fast, solve problems and turn chats into orders.
Open the guide · Download .xlsx
Reliance-style conglomerate dashboard in Excel with KPI cards and charts (example data)
Reliance Dashboard in Excel: Segment Revenue, EBITDA Margin, Capex and Revenue Mix
A big group runs many businesses: oil, retail, digital, gas and new energy. The board compares revenue, profit and investment by segment.
Open the guide · Download .xlsx
Infosys-style IT services dashboard in Excel with KPI cards and charts (example data)
Infosys Dashboard in Excel: IT Services Revenue, Utilisation, Attrition and Operating Margin
An IT services company sells people's hours to clients. Utilisation, bill rate and attrition decide its profit.
Open the guide · Download .xlsx
Tata Motors-style dealer sales dashboard in Excel with KPI cards and charts (example data)
Tata Motors Dashboard in Excel: Car Sales, EV Share, Fuel Mix, Discount and Delivery Wait
A car maker sells through dealers. It watches units, EV and CNG share, discounts and how long buyers wait.
Open the guide · Download .xlsx
Taj-style luxury hotels dashboard in Excel with KPI cards and charts (example data)
Taj Hotels Dashboard in Excel: Occupancy, ADR, RevPAR, F&B and Guest KPIs
A luxury hotel sells rooms, food and spa. Occupancy, ADR and RevPAR tell the manager if rooms earn enough.
Open the guide · Download .xlsx
IPL-style T20 match centre dashboard in Excel with KPI cards and charts (example data)
IPL Cricket Dashboard in Excel: Ball-by-Ball Run Rate, Strike Rate, Powerplay and Death Overs
A T20 analyst studies every ball. Run rate, strike rate, boundaries and phase of the innings show who is winning.
Open the guide · Download .xlsx

2. Industry dashboards (11)

One practice dashboard for each industry. See also the industry dashboards guide.

Retail dashboard in Excel
Retail Dashboard in Excel
Open the guide · Download .xlsx
Banking dashboard in Excel
Banking Dashboard in Excel
Open the guide · Download .xlsx
Hospitals dashboard in Excel
Hospitals Dashboard in Excel
Open the guide · Download .xlsx
Hotels dashboard in Excel
Hotels Dashboard in Excel
Open the guide · Download .xlsx
Logistics dashboard in Excel
Logistics Dashboard in Excel
Open the guide · Download .xlsx
Pharma dashboard in Excel
Pharma Dashboard in Excel
Open the guide · Download .xlsx
Real Estate dashboard in Excel
Real Estate Dashboard in Excel
Open the guide · Download .xlsx
Restaurants dashboard in Excel
Restaurants Dashboard in Excel
Open the guide · Download .xlsx
Telecom dashboard in Excel
Telecom Dashboard in Excel
Open the guide · Download .xlsx
Education dashboard in Excel
Education Dashboard in Excel
Open the guide · Download .xlsx
Top 10 Companies Dashboard in Excel
Compare 10 big companies on one sheet.
Open the guide · Download .xlsx
Top 50 Company Dashboards in Excel
50 world-famous companies, one dashboard each, thousands of rows of example data. 10 live now, 40 coming soon.
Open the Top 50 hub · Power BI versions

3. Business systems with a dashboard (26)

Each one is a full Excel system for a small business. Each has a Dashboard sheet.

# System
1 Bakery Management System in Excel: Recipe Costing, Daily Production, Sales, Waste and Dashboard
2 Boutique and Tailoring Management System in Excel: Measurements, Orders, Delivery Dates, Job Cards and Dashboard
3 Car Service Garage Management System in Excel: Job Cards, Parts and Labour, GST Invoice, Service Reminders and Dashboard
4 Catering Management System in Excel: Packages, Events, Payments, Kitchen Quantities, Margin and Dashboard
5 Cloud Kitchen Management System in Excel: Menu Costing, Orders, App Commission, Net Margin and Dashboard
6 Co-working Space Management System in Excel: Plans, Members, Meeting Room Bookings, Monthly Billing and Dashboard
7 Courier Management System in Excel: Zone Rate Chart, Weight Slabs, Fuel Surcharge, Delivery Status and Dashboard
8 Dairy Milk Collection System in Excel: Fat and SNF Rate Chart, Shift Entries, Farmer Bills and Dashboard
9 Employee Attendance Management System in Excel: Monthly Codes, Leave Balance, Late Marks and Dashboard
10 Farm Management System in Excel: Plot-wise Expenses, Crop Sales, Profit per Acre, Cost per Quintal and Dashboard
11 Gym Membership Management System in Excel: Plans, Renewals, Check-ins, Receipts and Dashboard
12 Hardware Store Management System in Excel: GST Invoices, Contractor Credit, Ageing, Stock and Dashboard
13 Hostel and PG Management System in Excel: Rooms, Residents, Rent, Late Fee, Occupancy and Dashboard
14 Hotel Management System in Excel: Room Bookings, Daily Occupancy, ADR, RevPAR, GST Room Bill and Dashboard
15 Housing Society Maintenance System in Excel: Quarterly Bills, Sinking Fund, Interest on Arrears, Receipts, Expenses and Dashboard
16 Laundry Management System in Excel: Price List, Order Lines, Express Surcharge, Due Dates, Receipts and Dashboard
17 Mobile Repair Job Card System in Excel: Jobs, Parts Stock, Status Flags, Warranty and Dashboard
18 Pharmacy Management System in Excel: Items, Sales Bills, Stock, Expiry Alerts and Dashboard
19 Photography Studio Management System in Excel: Packages, Bookings, Date Clash Check, Delivery Tracking and Dashboard
20 Printing Press Management System in Excel: Job Estimator, Paper and Plates, Quotation, Delivery Status and Dashboard
21 Restaurant Management System in Excel: Menu, Orders, GST Bills, Printable Bill, Food Cost and Sales Dashboard
22 Sales CRM System in Excel: Leads, Stages, Weighted Pipeline, Follow-up Reminders, Win Rate by Source and Dashboard
23 School Fee Management System in Excel: Fee Structure, Instalments, Overdue List, Receipts and Dashboard
24 Software Project Management System in Excel: Task Tracker, Sprint Burndown, Risk Register and Project Dashboard
25 Travel Agency Management System in Excel: Tour Packages, Bookings, Payments, Balance Due and Dashboard
26 Tuition Centre Management System in Excel: Groups, Monthly Fees, Test Marks, Progress Card and Dashboard

4. Learn to build dashboards (9)

  1. 13. Excel Dashboards (full chapter: plan, KPIs, PivotTables, charts, slicers, layout)
  2. How to create a KPI card: link a shape to a cell
  3. PivotTable average and a pivot chart for a dashboard
  4. Final project, stage 4: build the dashboard
  5. Practice: KPI cards for a city dashboard
  6. Practice exercises: dashboards
  7. Interview questions: dashboards
  8. 27. 20 Industry Projects (report and dashboard practice)
  9. 22. KPI in All Industries (which KPI to show)

Example data only

All numbers are made up for practice. They are not real company data or official reports. Brand names are used only to describe the type of business.

More: Excel Interview Cards · Ravi Sir's Cards