Hit The Ground Sprinting
Providing Straightforward Solutions To Complex Problems
Message Arrow

Formulae

If Cells are the Bricks of Spreadsheets then Formulae are the Mortar which holds it together!

Formulae can be as easy or as complicated as you choose to make them, but the best way to show you is BY EXAMPLE!

Clarification Before We Start!
"Formulae" in Spreadsheets are also known as "Functions" and for our purposes a "Function" is a "Pre-Defined Formula". We will start by looking at a simple one, the "If" Function. You are advised to watch this because, although it is a simple function explanations are given as to HOW Excel helps users when they are building functions. Please DOWNLOAD or OPEN and print a PDF first then watch the VIDEO!
Other Functions With Videos
  1. How VLOOKUP works: DOWNLOAD or OPEN PDF. VIDEO.

  2. How to create a Flexible VLOOKUP: DOWNLOAD or OPEN PDF. VIDEO.

  3. How to hide #N/A in VLOOKUP: DOWNLOAD or OPEN PDF. VIDEO.

  4. Multi-Column VLOOKUP: DOWNLOAD or OPEN PDF. VIDEO.

  5. SUMIF and SUMIFS explained: DOWNLOAD or OPEN PDF. VIDEO.

  6. Hide Errors: DOWNLOAD or OPEN PDF. VIDEO.

  7. Text Date Conversion: DOWNLOAD or OPEN PDF. VIDEO.

  8. Trim blank spaces: DOWNLOAD or OPEN PDF. VIDEO.

  9. Days and Months: DOWNLOAD or OPEN PDF. NO VIDEO!
Future Functions
Tell me what YOU would like to see demonstrated!