![how to use microsoft excel online how to use microsoft excel online](https://icdn4.digitaltrends.com/image/how-to-select-all-excel-2-1500x1001.jpg)
When you find appropriate one, click it and that style will be applied to your table. When you will hover your mouse pointer over the table styles, you will get the preview. ‘Tables Tools’ contextual tab will be visible when you will select any cell within the table.
![how to use microsoft excel online how to use microsoft excel online](https://i.pinimg.com/736x/53/9a/10/539a10c31a658797272079deffc036e2--microsoft-excel-how-to-use.jpg)
You can choose more Table styles from from the Table Tools ➪ Design ➪ Table Styles group. Worksheet after converting range into Excel table. If you change the revenue of January month, you will see that the revenues have been changed for other months. Notice that the cell B2 only holds number (100000), other cells B3, B4, … …, and B13 hold formulas and the internal formulas are generating the numbers in these cells. Read More: Hide and Unhide Excel Worksheets from a Workbook Click the B3 cell’s fill handle, drag down to cell B13, and release the mouse button.
#HOW TO USE MICROSOFT EXCEL ONLINE HOW TO#
Read how to create and copy formula using relative references in Excel. We are going to copy the formula of cell B3 for cell B4. We can manually put this formula for every cell but we are using Excel and Excel thinks about the best convenient way you can perform your job. If you press Enter, B3 cell will display 105000. Let’s select the cell B3 and type this formula: =B2*1.05. 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%.
![how to use microsoft excel online how to use microsoft excel online](https://imag.malavida.com/mvimgbig/download-fs/excel-online-18756-3.jpg)
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.
#HOW TO USE MICROSOFT EXCEL ONLINE DOWNLOAD#
Download Working File Start a new Excel Workbook