Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters
Offered By: Skillshare
Course Description
Overview
We will cover the following most common Excel formulas for intermediate users in the Finance world:
- Vlookup
- If Statements
- SumIF
- AverageIF
- CountIF
- TRIM
- Concatenate
- Left, Right, Mid
- Data Validation
- Removing Duplicates
- Conditional Formatting
- 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...
Syllabus
- 01 Excel Intro
- 03 What we will not cover
- 04 Excel File Explanation
- 05 Vlookup
- 06 If Statements
- 07 Sumif
- 08 Average If
- 09 Count If
- 10 TRIM
- 11 Concatenate
- 12 LEFT, MID, RIGHT
- 13 Nested Formulas
- 14 Data Validation
- 15 Remove Duplicates
- 16 Conditional Formatting and Data Filter
- 17 - Excel Outro
Taught by
BrainyMoney And Son Han, CFA,CPA
Related Courses
Excel Statistics and Finance Function PlaybookPluralsight Excel 2016: Managing and Analyzing Data
LinkedIn Learning Excel: You Can Do This
LinkedIn Learning Microsoft Excel Functions For Business
Udemy Excel 2016 for the Mac: Managing and Analyzing Data
LinkedIn Learning