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 de Caja diario ...  
✅Consolidated Archives with PQ    •  Como Consolidar Archivos en uno sol...  
✅ Average Line Graph    •  Grafica Barras con Linea Promedio, ...  

⏱ 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   / loganexcel100835328334225  
Blog http://loganexcel.wordpress.com/
Instagram https://www.instagram.com/loganexcel/...