Practice First: Financial Statistics Dashboards System Excel Dashboard Dataset

The main purpose of this blog is to give you the dataset to practice building the Financial Statistics Dashboards System as an Excel Dashboard. Use this practice Spreadsheet Template to follow the steps below, then customize charts and KPIs for your business.

How this fits your Dashboard Templates workflow

This approach scales across professional Dashboard Templates: adapt it into a Google sheets dashboard or a Power BI Dashboard, and present highlights in a PowerPoint Dashboard using your existing Power Point templates.


Why This Template Works

Great Microsoft Excel template for managing and analyzing financial performance—ready to use. All values, names, numbers, charts, and elements are editable directly in Excel with no VBA required.

Unique Features

  • Video Tutorial (Click here)
  • Analysis for +47 types of data
  • Notes and comments to help you use and update
  • Hyperlink buttons • Wide Screen – Full HD
  • Preview images included • Free Font & Icons
  • Easy Customize • All objects and database are fully editable

Dashboard Contents & Analysis

1) Income Sources Dashboard

  • Dynamic web chart detailing all income sources with top source highlight
  • Creative doughnut chart showing percentage achieved vs target
  • Total income, target, and monthly income line chart
  • Counts and percentages of income items; average monthly income
  • Two marketing strategy comparisons; all controlled by yearly slicer

2) Profits by Countries Dashboard

  • Dynamic map chart with most profitable country highlighted
  • Tax details and doughnut percentage achieved; fully controlled by yearly slicer

3) Sales Process Status Dashboard

  • Pipeline diagram of sales stages with counts per stage
  • Doughnut of total sales vs target and refunded orders percentage
  • Sales and orders by points of sale (bar charts)

4) Projects Workflow Report

Several core KPIs in a clean layout, updated directly from the data table.


Watch the Tutorial

Watch the full Financial Statistics Dashboards System tutorial on our Other Levels YouTube Channel


Download the Dataset

Download Free Dataset

6 comments

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

    sir/mam this data set shows only 1 sheet only not shown 4 sheet please provide all data

    • kool hero
    • November 6, 2024 at 12:32 pm

    The dataset provided by you is incomplete, where can I get the full dataset?

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

    there are not full data set in file

    • 敬哲
    • November 6, 2024 at 12:32 pm

    感謝提供此教學 謝謝

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

    Hey. I want to have skills

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