The moment you open up a Microsoft Excel worksheet, you start filling in the relevant data in the cells of the columns and the rows of the worksheet. That is all very good, you have the information right in front of you, but what is the use of it if you do not apply Microsoft Excel formulas to calculate the final result. You have a column of numbers, but you do not have a calculator to calculate them. That is the amount of money which has spent in your business throughout the year. So, how are you going to add up that great sum?

If you know how to apply a formula to a column or row of numbers, it is very easy to get your work done in half the time.

Now I have added some amounts of money from A1 to A 10. I need to select that column. I am going to go to cell A1. Then I'm going to press F8. After that I'm going to cell A-10. The entire column is selected, because by pressing F8 I had anchored the cursor to A1 and got it ready to select a large number of cells. It is also very easy to select a large number of cells by dragging the mouse over them after you have left clicked it and kept your finger up on the left click button.

Any of the text, which is overlapping into another cell, can be wrapped up by typing out all the information in one cell. Example -- "Linda McIntosh -- expenses."

It is spilling over from cell A1 to A2. Pick up on the home button on the toolbar and then select the wrap text icon. Everything is going to fit into your cell. Now it is time to create a formula.

I want to calculate the sum of money I have been disbursing to Linda McIntosh. I have filled up the amount from B1 to B10. Now I want to see the sum of the money. I go to B11 and enter = there. That means I am going to put in a function. Then I go to the function button and click it. The moment, I go to SUM, a number of instructions come online, asking me what I want to do. I write add in that space, and voilà, the amount $5,186 appears on my screen. There are many different types of formulas which you can utilize like division, multiplication, exponentiation, addition and subtraction, equal to, concatenation which is going to put two different strings together. You can also calculate less than and greater than functions in the formulas in Microsoft Excel.

Apart from this, Microsoft Excel has a bewildering range of the formulas which can be calculated on it. You can display zero values, Lookup values, hide all the error indicators and error values which are present in a cell, calculate differences between dates and times, calculate running balances, calculate growth rates compounded and annual, find out averages, mediums, and modes of groups of numbers and this just happens to be a few of the things you can do with Excel formulas!