Cash Flow Dashboard in Excel
This video is designed to show you, in a practical and simple way, how to create a dashboard in Excel from scratch, step by step.
A cash flow dashboard will allow you to analyze the behavior of financial data, view key metrics, improve decision-making, and create strategies for continuous business improvement.
To create this cash flow dashboard, we will use visualizations such as: cards, line charts, column charts, doughnut charts, and bar charts.
A creative, fully interactive, and easy-to-use dashboard.
🎞️Chapters
00:00 Introduction
03:04 Databases
05:17 Panel Funds
06:15 Metrics - Operating Balance, Debt, Accounts Payable, etc.
18:15 Cash Flow
30:08 Line Chart - Income and Expenses
37:47 Column Chart - Main Income
42:27 Line Chart - Net Balance or Cash Flow for the Period
49:38 Bar Chart - Main Expenses
55:16 Line Chart - Monthly Income
01:08:12 Slicers
📌Download the course materials.
https://drive.google.com/file/d/1hoMg...
------------------------------------------------------------------------------------------------------------------------------------------------------------
📌If you'd like the complete dashboard, you can get it here:
https://go.hotmart.com/Y94011044O?dp=1
Song: Fwends
Artist: Reed Mathis