# How To Make a Financial Spreadsheet in Excel | Productivity

You can create a financial spreadsheet in Excel to track your personal expenses and detail monthly income and expenses. Microsoft's program generates a balance sheet that tells you how much money you have saved over the month, or if your spending is overstated.

READ: Excel has a function that facilitates calculations and few know

In the following tutorial, learn how to make a financial spreadsheet in Excel. The procedure was performed on the latest version of Office 2016, but the tips also apply to users of previous editions of the program.

Learn how to create a financial spreadsheet in Excel Photo: Divulgao / Microsoft

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. Open Excel and create a new blank worksheet. Then make a table using the example image below to suit your needs. The objective is to establish a table for income (ie money earned during the month) and another table for expenditure (ms spending). Below each category, I need to enter the consumptions, their respective values ​​and payment date;

Example financial spreadsheet Photo: Reproduo / Helito Beggiora

Step 2. Now select the cells in which you added values ​​and change the style to "Currency". To do this, in the "Home" tab, just click "General" and select the indicates option;

Change number format to currency Photo: Reproduction / Helito Beggiora

Step 3. In the clause next to "Total" in expenses and income, enter the formula "= sum" (without quotation marks) and select all values ​​from each category. After you do this, press Enter. Excel automatically sum the ticked cells;

Calculating total spending and revenue Photo: Reproduction / Helito Beggiora

Step 4. In "Balance", you must type "=" (without quotation marks) and select the total revenue. Then type the minus sign and click on the total spend. Press Enter to calculate;

Calculating ms balance Photo: Reproduction / Helito Beggiora

Step 5. After making the desired editions, double click on "Folder1" and enter the name of the ms;

Rename folder to ms Photo: Play / Helito Beggiora

Step 6. For new months, you can copy the spreadsheet ready. To do this, right-click on the current month and go to "Move or Copy …";