FormulaCamp
Completed
← Full curriculum
Track 4 · Confident User

Excel Functions

The essential functions for math, statistics, logic, text, dates and time, taught with real-world examples.

9 free lessons

0 of 25 completed · about 6.8 h

Start

25 lessons left until your certificate

Math and Counting

  1. 1The SUM FunctionFreelesson15 min
  2. 2AVERAGE, MIN, MAXFreelesson15 min
  3. 3Counting: COUNT, COUNTA, COUNTBLANKFreelesson15 min
  4. 4ROUND and Its RelativesFreelesson15 min
  5. 5INT, MOD, QUOTIENTFreelesson15 min
  6. 6Practice: Rounding and Whole NumbersFreepractice20 min

Logic

  1. 7The IF FunctionFreelesson15 min
  2. 8Nested IF and IFSFreelesson15 min
  3. 9AND, OR, NOTFreelesson15 min
  4. 10SWITCH, XOR, IFNA, EXACTlesson20 min
  5. 11Practice: Logicpractice20 min

Conditional Calculations

  1. 12COUNTIF and SUMIFlesson15 min
  2. 13Multiple Conditionslesson15 min
  3. 14Criteria from Cells and Wildcardslesson15 min
  4. 15Practice: Conditional Calculationspractice20 min

Text

  1. 16Text: & and UPPERlesson15 min
  2. 17Splitting Stringslesson15 min
  3. 18Cleaning Datalesson15 min
  4. 19The TEXT and VALUE Functionslesson15 min
  5. 20Practice: Textpractice20 min

Dates and Time

  1. 21Dates Are Numberslesson15 min
  2. 22Tenure, Deadlines, Weekdayslesson15 min
  3. 23Workdayslesson15 min
  4. 24Time and Paying Hourslesson15 min
  5. 25Practice: Dates and Timepractice20 min