Basic Formulas Power Hour

Learn the basics of Excel formulas, try some examples, and uncover the mystery of absolute cell references

Description

  • Create basic Formulas: Add, Subtract, Multiply, Divide, Autosum
  • Brackets / BODMAS rule – the order of calculation
  • Absolute cell references – to fix a cell reference in a formula
  • Functions (SUM, MAX, MIN, AVERAGE, COUNT, COUNTA)
  • Fx – Insert function
  • Quick Analysis