Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters | BrainyMoney And Son Han, CFA,CPA | Skillshare

Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters

BrainyMoney And Son Han, CFA,CPA, Personal Finance Made Easy!

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
16 Lessons (1h 8m)

1:53

0:37

2:41

7:58

6:45

6:10

3:45

4:37

5:14

4:22

8:08

3:23

5:50

2:44

2:17
• 16. 17 - Excel Outro

1:47
13 students are watching this class
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

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.

1,005

Students

--

Projects

We will cover the following most common Excel formulas for intermediate users in the Finance world:

1. Vlookup
2. If Statements
3. SumIF
4. AverageIF
5. CountIF
6. TRIM
7. ConcatenateÂ
8. Left, Right, Mid
9. Data Validation
10. Removing Duplicates
11. Conditional Formatting
12. Data Filters

We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells).Â

This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc...Â

BrainyMoney And Son Han, CFA,CPA

Teacher

We're here to teach about personal finance and to keep you motivated.

Learning what you need to know to take control of your finances is easy. What's hard is staying motivated.

We're here to teach you about personal finance and to keep you motivated!

I love connecting with my students so feel free to add me on LinkedIn!

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.

• Supportive online creative community
• Learn offline with Skillshareâ€™s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects