Excel: Top 50 Microsoft Excel Formulas! | Bash (BizTech Matters) | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Excel: Top 50 Microsoft Excel Formulas!

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### Lessons in This Class

21 Lessons (1h 1m)

0:31

0:57

7:53

0:21

1:08

4:01

0:16

1:00

5:04

0:17

0:59

12:20

0:15

0:41

5:54

0:13

2:15

3:58

0:40

1:26
• ### 21. Vlookup - Practical Examples

10:55
• --
• Beginner level
• Intermediate level
• 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.

4,705

Students

1

Project

Last time you opened a spreadsheet and are overwhelmed by the formulas and functions being used. You don't know how to make the most out of them, or change them into what you need.

But it doesn't have to be this way!

You Will Walk Away With...

• MORE TIME!
• Learn the top 50 Excel formulas!
• Understand the essenceÂ of these formulas,Â without memorizing them!
• See how each of these formulas is usedÂ with real examples!

After this class you will be able to:

• Actually SMILE when you open a spreadsheet :-)
• Brag to your friends about how you can use Excel formulas and Excel functions confidently!

If you're like me, you use Microsoft Excel on a daily basis for important tasks, text processing, or calculations. Whether it's for business or personal related projects, everyone wants to be able to use these formulas freely and easily.

If you're ready to gain full control of Excel FormulasÂ TODAY, take this course right now and learn the following formulas:

• Text Formulas:
• Concatenate
• Find
• Left
• Len
• Lower
• Mid
• Proper
• Rept
• Substitute
• Trim
• Upper
• Value
• Mathematical Formulas:
• Average
• Int
• Mod
• Rand
• Round
• Sum
• Date and Time Formulas:
• Day
• Hour
• Minute
• Month
• Networkdays
• Now
• Second
• Today
• Weekday
• Year
• Logic Formulas:
• And
• Countblank
• Countif
• If
• Large
• Max
• Min
• Not
• Or
• Small
• Sumif
• Vlookup
• Financial Formulas:
• Fv
• Npv
• Pmt
• Ppmt
• Informational Formulas:
• Column
• Isblank
• Iserror
• Isnumber
• Istext
• Row

### Bash (BizTech Matters)

Online Teaching Excel Expert

Teacher

Hi! I'm Bash and over here at BizTech Matters, I love sharing what I know through online classes, with my over 10 years of IT and teaching experience. Whether it's creating websites, programs, spreadsheets, editing photos, or anything computer-related, I ensure that I will give you the tools to succeed.

My goal is to show you the essence behind on whatever I'm teaching you. Hop in for a fun ride into learning in the technology world!

Join me in learning the following this growing list of skills:

- Mastering Top Microsoft Excel Formulas

- Mastering SQL Queries

- Create your own Power BI Dashboard!

- Use Excel Power Query to Clean your Dirty Data

- Use the Top 50 Excel Keyboard Short... See full profile

## Class Ratings

Expectations Met?
Exceeded!
• 0%
• Yes
• 0%
• Somewhat
• 0%
• Not really
• 0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects