Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.

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

You will learn the most important formulas in MS Excel 2013 as well as using them in the most efficient way.

I designed the course in a way which offers students with different excel knowledge the perfect environment to increase their skills and become proficient with one of the most important tools microsoft has to offer.

The course is structured in short efficient lectures with valuable content. Any student can decide on his/her own how fast he or she wants to complete the course.

26

Students

1

Project

0

Reviews (0)

Dan W.

Anything is possible

Daniel is a 26 year old entrepreneur and business man. He has a master degree in Finance and Acounting as well as several additional qualifications and work experience in the finance and consulting industry.

He is committed to support other people by offering them educational services to help them accomplishing their goals and becomming the best in their profession.