Рет қаралды 37,855
🎯 Manage financial resources in this Daily Flow Dashboard, control cash inflows and outflows, Liquidity KPIs, Cash Rotation, Investments, etc.
How many times do we not have control of the financial resources and we do not know where the money is going, with the creation of this Dashboard we are going to analyze and manage the resources, bank records, payment of suppliers, financing, etc.
We will see how an analysis can be made of the daily template and create metrics that will help us control the treasury from day to day, if we have sufficient resources for the operation, as well as the priority of the day's payments.
We will use dynamic tables, graphs to measure, data segmenter and the entire automation process for a better understanding of the data, we will format and colors for a better visual presentation and greater impact, this will help us to have a real visualization of the flows and making financial decisions appropriately.
#LoganExcel #Excel #Dashboard #Treasury #Finance
🔴 Subscribe 👉 / @loganexcel
📃 Download File
📌Related Videos
✅ Flow template • 💰 Como hacer un Flujo ...
✅Consolidated Archives with PQ • 🤯 Como Consolidar Arch...
✅ Average Line Graph • 🔴 Grafica Barras con L...
⏱️ Timestamps ⏱️
00:52 Sample Daily Flow Dashboard
03:53 1.- Explanation of the database
04:58 2.- Metrics to Determine
11:45 3.- Template and automation of metrics
16:20 4.- Filling in the Text boxes
19:07 5.- Creation of graphs
39:26 6.- Time Scale Segmenter
43:00 7.- Data analysis
Also follow me on my Networks 📲:
🔹Facebook / logan-excel-1008353283...
🔹Blog loganexcel.wordpress.com/
🔹Instagram loganexcel...