logo

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

feature icon

Self-paced course

Price

Rating

Overview

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

Similar courses

course image
Accounting in Only ONE Hour! Learn all 3 Financials | Cash Flow | Balance Sheet | Income Statement
logo
Skillshare
course image
Secret Trading Strategies - Crash Course 2022
logo
Skillshare
course image
Technical Analysis Made Simple - Introduction to Stock Charts and Technical Analysis
logo
Skillshare
course image
Technical Analysis Made Simple: The Power of Trendlines, Support and Resistance
logo
Skillshare
course image
Technical Analysis Made Simple: Live Step-by-Step Stock Chart Analysis
logo
Skillshare
course image
Introduction to QuickBooks: Bookkeeping Basics
logo
Skillshare

Featured articles

Sep 12, 2022

WATCH these YouTube videos if you can't start learning a language

5

0
1
6K

Sep 12, 2022

How Memrise works + reviews [2022]

6

0
1
6K

Sep 12, 2022

5 tips to learn languages with YouTube videos [2022]

7

0
1
5K

Sep 12, 2022

How I Became a Marketing Manager at Microsoft

8

0
1
3K

Sep 24, 2022

How Edureka works + reviews [2022]

3

0
2
3K

Sep 27, 2022

How Codecademy works + reviews [2022]

3

0
2
2K
course image
feature icon

1628 students

feature icon

English

feature icon

Intermediate

Provided by

Authored by