Top 15 Most Useful Excel Formulas

Focused View

Ruben Wollerich

1:17:26

44 View

01 - Introduction.mp4

00:42

02 - Class Outline.mp4

01:25

03 - NOW & TODAY.mp4

06:31

04 - SUM(IFS).mp4

05:31

05 - COUNT(IFS).mp4

04:08

06 - AVERAGE(IFS).mp4

04:43

07 - MIN & MAX.mp4

03:42

08 - CONCAT &.mp4

03:22

09 - TRIM.mp4

03:06

10 - UPPER, lower & Proper.mp4

02:47

11 - IF.mp4

05:44

12 - AND OR.mp4

06:10

13 - NOT.mp4

06:14

14 - RIGHT, LEFT & LEN.mp4

07:12

15 - PMT.mp4

07:20

16 - VLOOKUP.mp4

05:12

17 - IFERROR.mp4

03:37

Description

In this class I discuss the 15 most useful Excel formulas.

Everyone lesson covers a (group of) formula(s). The videos are built up in three ways:
1. What does the formula do?
2. What is it used for?
3. Demonstration

This class helps you to gain a head start in using Excel. These formulas are the basis of building more complex and useful formulas.

Attached, is the file used for the formulas. In case you want to look back into how the formulas are built up, feel free to download the spreadsheet and dive into it!

Enjoy the class!

What You'll Learn?

Business
Excel
Productivity
Microsoft Excel
Formula
Useful

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Ruben Wollerich

Instructor's Courses

I gained my experience teaching and working with Excel as a freelancer for medium and large-sized organizations such as ING, NN Investment Partners and Pfizer.

Besides, I have a master's degree in Digital Business & Innovation, where the majority was about big data, analytics and business intelligence.

During my experience, I learned what Excel features have been most valuable for people working in larger organizations. Besides, adopting the right way of working with Excel, unleashes it's full potential and helps you gain insights you wouldn't expected to have gained through Excel.

In my classes I walk you through some of Excel's most amazing features, but also some very basic tips and tricks that help you become an Excel master!

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.