Excel 2010 formulas will let you perform a wide range of calculations on the data present in a spreadsheet. It is also possible to find the sum of data present on the various sheets. From basic to complex, you can perform a number of operations. The formulas are used in the calculation of payroll, income tax, profit & loss and various kinds of accounting routines.
Various ways to use Excel 2010 Formulas
You can enter the data and apply the formula. The result will appear in the relevant cell. On the other hand, it is possible to edit the data present in various cells so that the result will be modified automatically. If a range of cells is selected to create a chart, the chart will change automatically when the values are modified. Thus, excel is a very interactive and visual application to play with numbers.
Excel 2010 Formulas References
Three types of cell references are used in Excel 2010 formulas. They are relative, absolute and mixed. It is very much important to use the correct type of references so that the calculations will be correct. When you go for relative reference, the value will change relative to the column and row number. When you go for absolute reference, there will not be any change either in the column letter or row number. In case of mixed reference, the row or column that has a prefix of $ will not change and the other part will change.
Excel functions
The formulas in excel are nothing but pre-defined formulas. Some of the popular pre-defined formulas are summed, average and count. The excel functions can be used to perform various kinds of operations. They can be used to format text, change the color of one or more cells and analysis of data. By using a function, you can save a lot of time and effort. It is possible to organize the data and to analyze the data after applying various kinds of formulas.
If the function is not entered properly, an error message will appear. Hence, it is very much important to know the exact syntax before using them. You can go through the help provided through the excel so that you can find various inbuilt library functions and they can be used directly to perform various operations.
The most common functions are listed in the toolbar which can be used to perform Autosum operations. The functions can be explored in a great way by using the function library. If you go through formulas menu, you can various kinds of functions like Date, text, logical and financial functions. You can also use the insert function option so that you can search for the most appropriate function after going through the category.
‘What if’ analysis can be done in a useful way by using the functions present in Microsoft Excel. You will be able to perform various kinds of calculations and analysis by changing the numeric values. The productivity in the office will improve to a great extent by using the excel formulas as per the need.
Learn Excel 2010 Formulas in depth, visit our training website here.
No comments:
Post a Comment