Financial Statistics Dashboards System | Dynamic Excel Map Chart | Tutorial 2

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