MS Excel 2007 Formulas and FunctionsFormulas and Functions
This tutorial is for advanced users who need to perform calculations that may otherwise be impossible. Formulas and worksheet functions are essential to manipulating data and obtaining useful information from the Excel workbooks. This tutorial present a wide variety of formula examples that uses many of Excel's functions.
You'll learn how to use formulas and functions, manipulate text, how dates and times function works, count and sum data, lookup values by using formula, work with financial applications and how to use array formulas.