Succeed in Excel 2013 - Master formulas | Dan We | Skillshare

# 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