Excel formulas

Excel formulas, also known as worksheet functions, is one of the key features in Microsoft Excel. They are not defined as excel functions in our resource center because we feel that another group of tools in Excel are more qualified to be called excel functions.

Unknown to the novice Excel users, Excel has one of the most comprehensive set of formulas, not only to perform calculation but also to manage data records. Unlike most programs where the results are displayed on request, Excel has the ability to instantaneously re-calculates the results as the raw data changes. It is so powerful that it can perform the calculation faster than the user making those changes.

For example, Excel is able to find out the month of a particular date through the use of excel functions. By itself, it does not seem to offer any advantage. But if you are required to find out the month of a hundred dates, a thousand dates or even ten thousand dates, the month function would help you get those results out in minutes.

I have classified the formulas into different categories so that it is easier for you to refer to them.