Microsoft® Excel 2010 formulas
How can you use formulas in Microsoft® Excel 2010?
Microsoft® Excel is an application under the Microsoft® Office. It is basically a computing software which uses spreadsheets for more advanced calculations and management. Various applications are available in Excel® like pivot tables, graphical tools etc. Excel® forms the backbone for data management in most industries. Microsoft® Excel 2010 comes with some solid enhancements over Excel® 2007. Analysis, processing and sharing information is made faster and simpler, thereby, contributing to more effective decisions. It is an advanced and improved communication tool which plays an incredible role in saving both money and effort. Its most strengthening feature is the more advanced list of formulas and functions. Excel® is equipped with formulas which help you calculate values dynamically without having to labor over complex and time-consuming mathematical formulas. All the formulas must start with “=”. The formulas in Microsoft® Excel 2010 can be used for various purposes like calculating total household expenditure, loan repayments etc.
The description of the formulas used in Microsoft® Excel 2010 is mentioned below.
- In-built formulas
- Defining your own formula
- Addition of complex formulas
AutoSum is a formula which is already defined in Excel® 2010. It helps make addition much simpler and faster. To calculate the sum of a list of values, activate the cell which is to contain the sum. Then, click on Home and select the Editing option. The AutoSum icon is then selected. AutoSum automatically identifies its input variables and places a selection around them. A Formula Bar appears in the main menu which together with the active cell contain the formula and the associated variables. The formula starts with ‘=’ sign followed by SUM. The arguments are given in brackets and they represent the range of cells being summed. An AutoSum formula might take the form ‘=SUM(B2:B7)’.
Excel® 2010 also has a vast list of built-in formulas like aggregates, eigen function, binomial theorem etc. These help you perform complex mathematical operations in a matter of seconds. These formulas are arranged in an organized manner which is easy to view. Once you are familiarized with the functions of each formula, select Insert Function from the Formulas tab. Then, choose your required operation.
Activate the cell where you require to make use of the formula. First, type ‘=’ in the Formula Bar followed by the column references containing the input variables and the required mathematical symbols. On clicking Enter, the required calculation is performed in the activated cell. In order to apply this formula to the subsequent entries in this column, drag the bar down to contain all the cells where the required calculation is to be performed. You could define a formula of the form ‘=C2*12%’. Excel® 2010 can handle percentages so you may use ‘% ‘symbol.
Excel® 2010 features Macabacus Macros which enables you to add more improved and complex formulas to its list. Using the Macabacus Macros tab you can add advanced formulas and data. This feature is build to enhance the speed of construction of financial models.