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
Share:
Sales Performance Metrics Dashboard
Dynamic Microsoft Excel Sales Process Diagram | No Micros VBA | Tutorial #3
6 comments
sir/mam this data set shows only 1 sheet only not shown 4 sheet please provide all data
The dataset provided by you is incomplete, where can I get the full dataset?
there are not full data set in file
感謝提供此教學 謝謝
Hey. I want to have skills