Income Statement | Dashboard in Excel
In this video, we'll create a basic dashboard focused on analyzing the Income Statement data of a fictitious company.
The dashboard will allow us to track metrics such as net income, remaining debt, fixed expenses, etc. We'll also create the basic structure of the income statement.
To create this dashboard, we'll use visualizations such as:
cards, progress charts, line and column charts.
All of this will help us design a great dashboard in Excel.
🎞️Chapters
00:00 Introduction
01:34 Prerequisite
01:49 Database
03:58 Income Statement Structure
23:08 Metrics - Remaining Debt, Fixed Expenses, and Depreciation
29:13 Line Chart - Net Income Change and Variation
33:48 Line Chart - Net Sales Change and Variation
37:20 Progress Chart - Gross Profit Margin and Operating Profit Margin
39:53 Column Chart - Cost Change and Variation
43:58 Treemap Chart
49:01 Data Slicers
📌Download the worksheet.
https://drive.google.com/file/d/1f4B3...
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
If you'd like the full Dashboard, you can get it here:
https://go.hotmart.com/L96718171L?dp=1
Song: Fwends
Author: Reed Mathis