So, in the month of February, it will be January’ revenue+5% of January’s revenue. We have fixed that in every month our revenue will increase by 5%.

Now, we want to know the projected revenues for February and other months.

We shall use the dollar sign ($) and comma in our revenue numbers later in our ‘formatting number’ section. Move the cell pointer to B2 and type 100000, the projected revenues for January. Click here to know Keyboard Shortcuts for Moving around Excel Spreadsheets.

Select the cell B2 using mouse or keyboard whatever you prefer.

Assume that January’s revenues are projected to be $100,000, and this revenue will increase by 5 percent every month. Next, you provide the sales projection numbers in column B. Worksheet, after entering the column headings and month names.

Release the mouse button, and Excel automatically will fill in the month names in abbreviated form.

Move your Mouse Pointer over the fill handle, click the fill handle, and drag down until you’ve selected cells from A2 to A13. This small square box is called Fill Handle. Notice that there is a small square box at the bottom-right corner of this active cell. This is now the active cell with a heavy border around it.

Select cell A2 clicking your mouse pointer on this cell.

But we are using Excel, so we should take some advantages of this software. You can manually fill the cells A3, A4, A5, … …, and A13 with ‘Feb’, ‘Mar’, ‘Apr’, … …, and ‘Dec’ respectively.

Move the cell pointer to cell A2 and type ‘Jan’ from your keyboard.

We shall fill in our column A with the month names. The text extends beyond the B1 cell width, we shall fix it very soon, don’t worry.

Select of Move the cell pointer to B1, type ‘Projected Revenue’, and press Enter.

The cell pointer movement can be different. By default, the cell pointer will move down by one cell.

Type ‘Month’ into cell A1 and press Enter.

You can select A1 using your mouse pointer or the navigation keys. A1 is located at the upper-left corner in the worksheet. The first column will contain the name of months, and the second column will store the projected Revenue volumes. The monthly revenue projection table will be made up of two columns.

A fresh and empty workbook will be displayed.

If you don’t have any old Excel file, just right click your mouse on any folder (Desktop is a folder and my computer is not a folder, remember it) and select ‘Microsoft Excel Worksheet’ from ‘New’ options. To create a new, blank workbook, press CTRL + N (also you can use this command line: File➪ New➪Blank Workbook). To do this, open any of your old Excel files. Download Working File Start a new Excel Workbook

How to use microsoft excel online