Formula Fundamentals — Excel Course

Create formulas using =, arithmetic operators, parentheses and cell references. Learn it step by step with guided practice on Excelquro.

Understand

A formula begins with = and combines values, cell references, operators and sometimes functions. Excel evaluates the expression and returns a result.

Worked example

=B2*B3

Follow along

  1. Type = in an empty cell.
  2. Select or type a cell reference such as B2.
  3. Add an operator such as + or *.
  4. Add another reference such as B3.
  5. Press Enter and compare the result with the source values.

Interactive practice runs in your browser.