Como fazer Planilha Mensal de Gastos com Resumo Mês a Mês | Passo a Passo | Vitalício!

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: https://excelentejoao.com.br/sejaexce... 🔵PURCHASE SPREADSHEET: https://excelentejoao.com.br/planilha... ▶ Guys, the spreadsheet is free for you to do along with me during the class. But, if you don't want to do it, you can purchase it through the link above. Delivery is automatic and secure. 🙏👍 In this Excel video lesson, we're going to learn how to create a Monthly Expenses Spreadsheet in Excel, we'll see how to do it step by step from scratch. A monthly expense control spreadsheet in Excel can help you control your income and expenses, that is, it's an income and expense spreadsheet, a cash flow spreadsheet, a financial control spreadsheet in Excel. The first thing we're going to do in this spreadsheet is create a title. This way, we can easily identify what our Excel file is about, and if another person or user uses our spreadsheet, they can also easily identify what it's about. The second step is to add the days of each month to the header. So, for example, January 1st, January 2nd, and so on. Instead of using the months in each column, we'll use each day in a separate column. And we'll divide our spreadsheet by month; that is, we'll have a monthly expense control spreadsheet in Excel for the month of January, another for the month of February, another for the month of March, and so on. Now that the header is ready, let's freeze the panes, that is, freeze the header so that it's always visible. So, when we scroll down the spreadsheet, when we lower the view, the header remains fixed on the screen, and this way we don't lose the reference. We'll fix the header in the spreadsheet; we'll fix the rows in Excel; we'll lock the row. The second step is to create entry blocks: the first for income (i.e., revenue), the second for expenses (i.e., expenses), and the third where we will perform calculations such as the total spent each day, the overall balance for each day, and the accumulated total until the end of the month. The last calculation is the Grand Total, which is the final value (summing all income and subtracting all expenses), the final balance of the entire spreadsheet. You can add as many categories as you want to each block of the spreadsheet. You can have several income categories, several expense categories, etc. And if you need to add rows to the spreadsheet without changing the formulas, that's also possible; that is, adding a new row to the spreadsheet without messing up the formulas. #ExcellentJoão #Excel #Dashboard