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
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |