Practice First: Working Hours & Expenses Analysis Excel Dashboard Dataset

The main purpose of this blog is to give you the dataset to practice building the Working Hours & Expenses Analysis Excel Dashboard for commercials production companies. Use this practice Spreadsheet Template to follow the steps below, then tailor KPIs, slicers, and visuals to your team.

How this fits your Dashboard Templates workflow

The structure adapts across professional Dashboard Templates: you can mirror it in a Google sheets dashboard, port metrics into a Power BI Dashboard, and present highlights in a PowerPoint Dashboard using your existing Power Point templates.


Unique Features

  • Analysis for 27+ types of data
  • Wide Screen – Full HD; preview images included
  • Free Font & Icons; Easy Customize
  • All objects and database are fully editable

Dashboard Contents & Analysis

Budgets, Hours & OPEX

  • Total Budget Allocated
  • Total Agreed Hours vs Actual Hours (with percentage)
  • Total OPEX Invoice Hours Paid (and percentage)
  • Extra vs Missing Working Hours and related payments

Workforce & Payroll

  • Total Employees & gender split (with percentages)
  • Employees by Positions (Cameraman, Assistant, Coordinator)
  • Employees by Nationality
  • Doughnut: Paid vs Unpaid Salaries and percentages

Trends & Interactivity

  • Expenses per Month with highest-amount highlight
  • Line chart: Actual Working Hours vs Invoice
  • Slicers for Employees’ Names

Package Includes

  • Excel – XLSX format (327 KB)
  • Three sheet tabs: Database, Pivot tables, Dashboard
  • Instruction File; Help & Contents File; Light Theme

Watch the Tutorial

Watch the full Working Hours & Expenses Analysis Excel Dashboard tutorial on our Other Levels YouTube Channel



Download Free Dataset

1 comment

    • Saira
    • November 6, 2024 at 12:32 pm

    Assalamualikum Brother I need data set of this Excel Profits & Loss Dashboard with creative slicer and dynamic indicator .

Leave a comment

This site is protected by hCaptcha and the hCaptcha Privacy Policy and Terms of Service apply.

Latest Stories

View all

Use Microsoft Excel on Mobile Devices Efficiently

Take your spreadsheets on the go! With Excel Mobile, manage data, edit reports, collaborate in real time, and update dashboards, right from your phone or tablet. Perfect for remote work, travel productivity, and cloud-powered business tasks.

Read more

How to Add Comments and Notes in Microsoft Excel

Enhance your spreadsheet workflow using Excel's Comments and Notes, perfect for team collaboration, remote reviews, feedback loops, and self-documenting reports. Streamline communication and reduce errors with built-in annotation tools.

Read more

Create QR Codes in Microsoft Excel Using Web Add-ins

Learn how to generate QR codes directly in Excel using Web Add-ins for interactive dashboards, inventory logs, event invites, and mobile-friendly invoices. No design software needed, just dynamic, scannable power built into your spreadsheet.

Read more