Home / MS-Excel / Functions and Formula

MS-Excel Formulas

Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.

Formulas use data, stored in other cells, to calculate a new result that appears in another cell. To create even more complicated spreadsheets, you can even make a formula use data from other formulas so that changes in a single cell can ripple throughout an entire spreadsheet.

In this tutorial:

  1. Creating a Formula
  2. Copying formulas
  3. Using Functions
  4. Using the AutoSum command
  5. Using recently used functions
  6. Editing a Formula
  7. Auditing Your Formulas
  8. Finding where a formula gets its data
  9. Finding which formula(s) a cell can change
  10. Formulas Data Validation