Create-Your-Monthly-Budget-in-a-Snap.png' alt='Free Budget Template Microsoft Excel' title='Free Budget Template Microsoft Excel' />This Free Calendar Template on excel is the best thing that happened this year. It comes with a horde of brand new features and free fonts. Edit, save, print and. Template124 is all about Premium Excel Template for project management, Check out financial, Attendance, Company Reporting and dashboard tool for small business. Excel based budgeting spreadsheet software to track your financial accounts in registers, create a budget worksheet and custom categories, and produce reports and charts. Template-Auto-Computes-Totals-for-You-580x356.jpg' alt='Free Budget Template Microsoft Excel' title='Free Budget Template Microsoft Excel' />How to make a monthly budget template in Excel Companies usually make budgets as a plan to earn and spend money for the coming years. For a family or a person, we can also make budgets for saving money or decreasing family deficit. In this article, I will show you how to download a budget template from Office. Excel, and how to make or customize a personal budget template in Excel. Although there are so many budget templates for downloading, you may still want to make a custom monthly budget template based on your needs. The following steps will walk you through customizing a monthly budget template in Excel. Step 1 Prepare a table, and enter its row headers and column headers as following screen shot shown Step 2 Enter your budget data of income and expenses into the table, and calculate the total incomes of every month and every item 1 Calculate total income per month In Cell B7 enter SUMB4 B6, then drag the Fill Handle to apply this formula to Range C7 M7. Calculate total income of every item In Cell N4 enter SUMB4 M4, then drag the Fill Handle to apply this formula to Range N5 N6. Calculate the total income in the budget year in Cell N7 enter IFSUMN4 N6SUMB7 M7, SUMN4 N6, FALSE, and press the Enter key. Mac Os 9 2 Download Dmg File more. Step 3 Calculate the total expense of every month and every items. Calculate total expense of each month In Cell B1. SUMB1. 0 B1. 5, and drag the Fill Handle to apply this formula to Range C1. M1. 6. 2 Calculate total expense of each item In Cell N1. SUMB1. 0 M1. 0, and drag the Fill Handle to apply this formula to Range N1. N1. 5. 3 Calculate total expense in the budget year IN Cell N1. IFSUMB1. 6 M1. SUMN1. N1. 5, SUMN1. N1. FALSE, and press the Enter key. Step 4 Calculate the deficit or surplus in this budget year In Cell B1. B7 B1. 6, and drag the Fill Handle to apply this formula to Range C1. N1. 8. Step 5 Make a pie chart for the incomes in this budget year. Select the Range A4 A6, then hold the Ctrl key and select the Range N4 N6. Click the Pie button or Insert Pie and Doughnut Chart button in Excel 2. Insert tab, and then specify a pie chart from the drop down list. Step 6 Format the new added pie chart. Add labels for the pie chart with right clicking the pie and selecting the Add Data Labels from the right clicking menu. Add Chart title with clicking the Layout Chart Title Above Chart in Excel 2. In Excel 2. 01. 3, the Chart title is added automatically, and enter a chart title, such as Incomes in Budget. Step 7 Add a pie chart for the expenses in this budget year. Please select the A1. A1. 5, then press the Ctrl key and select the N1. N1. 5 and then follow the same methods we introduced in Step 5 2 and Step 6. Step 8 Save current workbook as template with clicking the File Save Computer Browse in Excel 2. File Office button Save in Excel 2. Step 9 In the coming Save As dialog box, enter your template name into the File name box, and click the Save as type box and specify the Excel Template. Save button. Now current workbook is saved as your personal template. Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer. The Best Free Microsoft Excel Templates You Arent Using. Timeline Scheduling Template or Printable for Microsoft Excel. Screenshot by Cindy Grigg, Courtesy of Microsoft. Timeline scheduling templates such as these can help individuals or teams stay organized. Looking for a more long term schedule of events The Timeline Template for Excel has a lot of potential, be it for school reports, planning, a visual corporate history, or even journaling. The Employee Shift Schedule Template for Excel is very scannable while still providing details about several individuals. Another application for this template could be organizing volunteers. Think outside the box. Instead of listing people, list something like school classes with corresponding times, for example. Also try Student Weekly Schedule Template for Excel. Open Excel, select New, then use the search box to search for this template by name.