Excel Formulas for Finance
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…
![[Audio] IC04 Topical Panel 02 – Brief Therapy – George Burns, B A . (Hons.), Steve de Shazer, M.S.S.W., Richard Fisch, M.D., Wendel Ray, Ph.D.](https://thecoursearena.com/wp-content/uploads/2024/08/Audio-Only-IC04-Topical-Panel-02-Brief-Therapy-George-Burns-B-A-.-Hons.-Steve-de-Shazer-M.S.S.W.-Richard-Fisch-M.D.-Wendel-Ray-Ph.D-250x343-1-250x300.png "[Audio] IC04 Topical Panel 02 – Brief Therapy – George Burns, B A . (Hons.), Steve de Shazer, M.S.S.W., Richard Fisch, M.D., Wendel Ray, Ph.D.")
![[Audio] IC04 Topical Panel 10 – Anecdotes & Metaphors – Norma Barretta, Ph.D., Rubin Battino, M.S., Stephen Lankton, M.S.W., Joyce Mills, Ph.D.](https://thecoursearena.com/wp-content/uploads/2024/08/Audio-Only-IC04-Topical-Panel-10-Anecdotes-Metaphors-Norma-Barretta-Ph.D.-Rubin-Battino-M.S.-Stephen-Lankton-M.S.W.-Joyce-Mills-Ph.D-250x343-1-250x300.png "[Audio] IC04 Topical Panel 10 – Anecdotes & Metaphors – Norma Barretta, Ph.D., Rubin Battino, M.S., Stephen Lankton, M.S.W., Joyce Mills, Ph.D.")
![[Download] Saravanan Ganesh – Rank n Rent (2021)](https://thecoursearena.com/wp-content/uploads/2023/11/fire-25-15-1-300x300.jpg "[Download] Saravanan Ganesh – Rank n Rent (2021)")
![[Download] Ecom Empires – Build Your Empire (2021)](https://thecoursearena.com/wp-content/uploads/2023/11/fire-21-2-1-300x300.jpg "[Download] Ecom Empires – Build Your Empire (2021)")