Most Common Excel Formulas - Excel at Your Job

Most Common Excel Formulas - Excel at Your Job

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

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

Get better and more efficient at work!

Url: View Details

What you will learn

• Students will know all intermediate level Excel formulas and functions
• Students will be significantly faster at their jobs when using Excel

Rating: 4.05

Level: Intermediate Level

Duration: 1 hour

Instructor: BrainyMoney and Son Han, CFA, CPA