Excel 2013: Understanding Formulas and Functions from scratch

Gilberto Berlanga, International Relationist / Industrial Engineer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
16 Videos (40m)
    • Introduction to formulas

      4:44
    • Order of operations

      3:42
    • Introduction to Functions

      5:22
    • What are Relative and Absolute references?

      4:34
    • Mouse selection tricks

      1:04
    • Mouse selection trick

      1:04
    • Filling a Range

      0:39
    • Defining a name range

      2:34
    • Clearing a Range

      1:10
    • Selecting 3D Ranges

      1:10
    • SUMIF Function

      1:54
    • COUNTIF Function

      0:59
    • AVERAGE IFS

      3:14
    • AVERAGE IF

      2:03
    • VLOOKUP FUNCTION

      3:42
    • Project Assignment

      2:33