Microsoft Excel

Formulas and Functions in Excel 2007

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.

The following points will be covered in this tutorial:

  • Learn how to fill a range with a particular value or formula, what is fill handle, create text and numeric series with AutoFill and create your own AutoFill list.
  • Calculate the depreciation of an investment by using the SYD function, which returns the sum-of-years' digits depreciation of an asset for a specified period.
  • 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.