Excel Formulas for Finance | BrainyMoney And Son Han, CFA,CPA | Skillshare

## Excel Formulas for Finance

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

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
17 Videos (1h 10m)
• 01 Excel Intro

1:53
• 02 Course Overview

2:11
• 03 What we will not cover

0:37
• 04 Excel File Explanation

2:41
• 05 Vlookup

7:58
• 06 If Statements

6:45
• 07 Sumif

6:10
• 08 Average If

3:45
• 09 Count If

4:37
• 10 TRIM

5:14
• 11 Concatenate

4:22
• 12 LEFT, MID, RIGHT

8:08
• 13 Nested Formulas

3:23
• 14 Data Validation

5:50
• 15 Remove Duplicates

2:44
• 16 Conditional Formatting and Data Filter

2:17
• 17 - Excel Outro

1:47

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...

37

Students

--

Projects

• --
• Beginner
• Intermediate
• 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.