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

Introduction to Financial Accounting
University of Pennsylvania via Coursera Accounting Cycle: The Foundation of Business Measurement and Reporting
Utah State University via Canvas Network La contabilidad, el lenguaje de los negocios
Miríadax Financial Accounting for Non-Financial Managers
Rollins College via Open Education by Blackboard Evaluation financière de l'entreprise
HEC Paris via Coursera