My wife just called an emergency budget meeting. Vet bill for our dog (abscessed tooth): $1,500 These were our expenses in the last two weeks:įlight tickets for our February vacation: $1,500 I’m supposed to be super smart about money.
Therefore, calculate the Difference between the Projected and Actual incomes.I’m a personal finance expert.At this time, enter the Projected and Actual Incomes of the Items.Thereupon, type the names of the Items and insert a border into the entire table.Besides, create the headings for the Items, Projected & Actual Incomes and finally the Difference between the Projected & Actual Incomes.Eventually, insert the Income heading for Week 1 & 2 (see screenshot).Likewise, make a Work Period table for Week 3 & 4.As a result, the Work Period table of Week 1 & 2 will be the same as the following picture.Subsequently, choose All Borders from the Border drop-down.After that, to provide a border, select the range C5:E5 > go to the Home tab > click on the Border drop-down.Then, type ‘ to’ in between the cells of the two dates (cell D5).In a similar manner, insert the end date ( ).Accordingly, type the start date ( ) of the Work Period.Hence, select cell C5 > go to the Home tab > Number group > click on the Number Format drop-down > select Short Date from the drop-down menu.So, we need to change the Number Format of the cells to Date.In cells C5 and E5, we want to enter the start and end dates of the first two weeks.Now, to format it, select cell B5 > go to the Home tab > click on Bold ( B) > change the Font Size to 12 > click on the Border drop-down > choose All Borders.Firstly, type ‘ Work Period’ in cell B5.This step will guide you to prepare the Work Period and Income tables in the budget sheet. Step 3: Prepare Work Period and Income Tables Read More: How to Create Actual Vs Budget Variance Reports in Excel In the same way, add a border to the ‘ Week 3 & 4’ heading (see screenshot).At this time, to provide a border to the ‘ Week 1 & 2’ heading, select the heading ( Week 1 & 2) > go to the Home tab > click on the Border drop-down > choose All Borders.Similarly, prepare the heading for Week 3 & 4 (see screenshot).Consequently, the heading of Week 1 & 2 will be like the picture below.Later, to change the font color of the heading, click on the heading > go to the Home tab > click on the Font Color drop-down > choose any color that you need.Now, to change the formatting of the cell, select the heading first > go to the Home tab > click on Bold ( B) > change the Font Size to 14 > click on the Fill Color drop-down > select any color you want.Then, type ‘ Week 1 & 2’ in the merged range ( B4:E4).Afterward, click on Merge & Center in the Alignment group.In this step, we will insert the headings for the 2 bi weekly budgets in Excel for the entire month. Step 2: Insert Heading for Two Bi Weekly Budgets in Entire Month
Therefore, click on the heading ( Bi-weekly Budget Sheet) > go to the Home tab > Font group > change the Font Size ( 16).In turn, the heading will look like the following picture.