Succeed in Excel 2013 - Master formulas

Dan W., Anything is possible

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
31 Videos (1h 29m)
    • Word of caution

      1:27
    • The If formula - How to deal with conditions

      2:08
    • If Part 2

      4:04
    • Sum formula with a condition

      3:21
    • How to sum with several conditions

      5:00
    • Let us count

      2:18
    • Let us count with several criterias

      2:01
    • The counta formula

      1:21
    • Max min small large ?

      2:45
    • The Vlookup function

      2:23
    • Vlookup Part 2

      3:31
    • Hlookup - the vlookup brother

      2:05
    • Match formula

      1:46
    • Vlookup with several tables

      4:49
    • Index & match

      3:00
    • Days and time

      4:39
    • Sumproduct formula

      4:17
    • Array introduction

      1:58
    • Basic statistical formulas

      2:44
    • Excel for finance - Future Value

      2:40
    • Excel for finance - Pmt formula

      1:44
    • Excel for finance - Rate formula

      2:10
    • Excel for finance - Nper formula

      2:12
    • Excel for finance - Net present value

      1:56
    • Excel for finance - Internal Rate of Return

      1:58
    • Excel for finance - XIRR & XNPV Formulas

      3:20
    • Goal Seek

      2:29
    • Data Tables

      5:31
    • Consolidate data

      2:25
    • Forget Filter use Dsum instead

      2:48
    • Create a dynamic chart

      3:42