Tweet

# Excel For Noobs Tutorial: A Step by Step Creation of a Sales Report and Forecast

In this Excel For Beginners or Excel For Noobs tutorial we are going to teach you all of the primary functions of Excel by creating a sales report and sales forecast step by step. Through the creation of this report you should become familiar with the main functions of Microsoft Excel.

Step 1: Enter the content into Excel exactly as shown here.

Step 2: Now activate cells A2 through D2 and click on the Merge & Center command.

Step 3: While the merged cell A2 is activated click on the Fill Color command and select the color of your preference.

Step 4: Now select cells A3 through D3 cell A12 and use the Fill Color Command filling the cells with a color that will go well with the previous color you chose.

Step 5: Now select cells A4 through A11 and again fill the cells with the color of your choice.

Step 6 Now in cell B12 use the sum formula to find the total sales for FY2011.

Step 7: Now activate cell C12 and click the AutoSum command which can be found on the ribbon in the formula tab.

Step 8: In cell D4 enter in the following formula, =(C4/B4)-1 and then press ENTER. This formula is solving the percentage increase or decrease in sales for each item over the past year.

Step 9: Now make sure that cell D4 is still activated. Look at the bottom right of the thick border around cell D4 and you will see a small square box. Click on this box and drag it all the way down to cell D12. What you did was use Autofill insert the same formula into each relative cell. This is obviously much more efficient that typing the formula into each cell manually. However this can only be used when the formulas are referring to the same relative cells.

Step 10: Now select cells E2 through E3 and click on the Merge & Center command and then while the cell is still activated click on the Wrap Text Command which is located right above the Merge & Center command. Also fill the cell with color to distinguish the sales forecast from the sale report.

Step 11: Now select cells D4 through D12 and click on the Percentage which is located in the Drop-Down Manu of the Number Format Command in the Number Group on the ribbon under the Home tab. You can use the Increase or Decrease decimal button

Step 12: Now in cell E4 enter =C4*(1+D4). This is a simple formula to make a sales forecast for FY 2013 base on the % rate of sales increase or decrease from FY 2012. After you have entered the formula use the AutoSum feature to drag the formula down to cell E12.

Step 13: Now select every other row in the report that contains number and the fill those cells with a light color. This is done to make the report easier to read.

Step 14: Now select all the cells that contain numbers (not including the percentages) and then format the numbers to currency by selected currency from the Number Format command.

Step 15: Now select the entire report and the click on the down arrow on the Border command and clickAll Borders and then while the entire report is still selected, click on Thick Box Border.

Step 16: Now hold your cursor over Column Letter A, right click and click on Insert from the Short Cut Menu. This will insert a new column of cells.

Financial Dictionary
Property Management Brevard County FL
Condo Management Brevard County