248,901 views
???? LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: http://excelentejoao.com.br/sejaexcel... ???? FREE SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this Excel video lesson, we will learn how to make a Financial Control Spreadsheet in Excel with a Graph to help us in our daily cash flow control and in our analyses so that we can have more precision and assertiveness in the Excel spreadsheet. Basically, the spreadsheet is composed of two parts. In the first tab of the spreadsheet, we have the management summary or even our Excel control. In the second part, we have the cash flow, where we will control all the income and expenses in our Excel table. The spreadsheet also has a small Excel dashboard to help us analyze the data. The Excel dashboard consists of a graph in Excel, a combination graph, where we will combine two column graphs and an area graph combined into just one graph, that is, we will combine several graphs into one. You can use this spreadsheet in your daily life or even in the job market to help you control income and expenses. You can also use the Excel spreadsheet to control cash flow. With this spreadsheet, you can also have the entire history of your account's inflows and outflows. 0:00 Explaining the Spreadsheet 2:28 Step by step #ExcelenteJoão #Excel #Dashboard