Excel Functions Tutorial With Examples

Detailed formula examples for key functions including vlookup index match rank sumproduct average small large lookup round countifs sumifs choose find search date and many more.

Excel functions tutorial with examples. Excel includes many common functions that can be used to quickly find the sum average count maximum value and minimum value for a range of cells. Calculate a periodic payment of loan which you need to pay. For example cell a3 below contains the sum function which calculates the sum of the range a1a2. Calculates the present value of financial investment or a loan.

As each function name is highlighted a description and example of use is provided below the two boxes. Functions perform specific calculations in a particular order based on the specified values called arguments or parameters. Calculates the future value of an investment. If youre using excel 2007 youll find these functions in the statistical or math trig categories on the formulas tab.

For more information about the new functions see statistical functions reference and math and trigonometry functions reference. From the paste function dialog box browse through the functions by clicking in the function category menu on the left and select from the function name choices on the right. Top excel tips and tricks. For example youll learn about roundup countif rounddown countblank median and much more.

In order to use functions correctly youll need to understand the. Functions are predefined formulas and are already available in excel. Introduction to microsoft excel. To master the art of excel check out cfis free excel crash course which teaches you how to become an excel power userlearn the most important formulas functions and shortcuts to become confident in your financial analysis.

Provides an advanced excel tutorial starting with an introduction to tables and a wide range of math and statistical functions. For example a2a2a3a4 is a formula that adds up the values in cells a2 through a4.