In this Excel video tutorial, we gonna see how to create a monthly budget spreadsheet in Excel with a Excel Dashboard step by step from scratch.

So, in this free Excel tutorial, we gonna create both interactive Dashboard in Excel and a dynamic cash flow spreadsheet in Excel.

This Excel spreadsheet file will included my both Income and expenses. But, we gonna divide expenses into two, fixed expenses and variable exepenses.

We also gonna create a remaining value formula to check our remaining cash by month, or I mean, how much we have left in the bank account. Moreover, we gonna also built a row to display the balance per month.

The only function that we gonna use is the SUM function in the Excel.

The SUM function in Excel add up values in a range. The SUM formula is a Math and Trigonometry function.

#JopaExcel #Dashboard #Excel