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

Project Description

You can master excel in 1 day!

Together we will go on a journey to explore one of the most important tools Microsoft has to offer. We learn the power of MS Excel, how to use formulas to work efficiently and smart. The knowledge which you acquire here will surely help you  at work, university, school,...

I am excited and happy that you decided to join me on this awesome trip to master MS excel.

I have attached the excel file for the course. Your project consits of 2 tasks. At first I want you you to accompany me through the class. After finishing you will be able to do all the tasks from the excel workbook yourself. After you have finsihed these, I want you to work on a specific problem in excel at work, university or school. After you have mastered it please post it with a description (and if you can with an shortcut image) and share it with all the other students.

                                       Show the world that you have mastered Excel

Resources(1)

Student Projects