Succeed in Excel 2013 - Master formulas

Dan We, Anything is possible

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

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

      2:08
    • 3. If Part 2

      4:04
    • 4. Sum formula with a condition

      3:21
    • 5. How to sum with several conditions

      5:00
    • 6. Let us count

      2:18
    • 7. Let us count with several criterias

      2:01
    • 8. The counta formula

      1:21
    • 9. Max min small large ?

      2:45
    • 10. The Vlookup function

      2:23
    • 11. Vlookup Part 2

      3:31
    • 12. Hlookup - the vlookup brother

      2:05
    • 13. Match formula

      1:46
    • 14. Vlookup with several tables

      4:49
    • 15. Index & match

      3:00
    • 16. Days and time

      4:39
    • 17. Sumproduct formula

      4:17
    • 18. Array introduction

      1:58
    • 19. Basic statistical formulas

      2:44
    • 20. Excel for finance - Future Value

      2:40
    • 21. Excel for finance - Pmt formula

      1:44
    • 22. Excel for finance - Rate formula

      2:10
    • 23. Excel for finance - Nper formula

      2:12
    • 24. Excel for finance - Net present value

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

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

      3:20
    • 27. Goal Seek

      2:29
    • 28. Data Tables

      5:31
    • 29. Consolidate data

      2:25
    • 30. Forget Filter use Dsum instead

      2:48
    • 31. Create a dynamic chart

      3:42
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!