Essential Excel Functions for Financial Modelers - Incl. FREE Example File

Описание

Excel functions are the backbone of a financial modeler’s day to day work and as such, it’s essential to have a good understanding of the functions that are commonly used to build financial models. In this video I cover the top Excel functions that you must know as a financial modeler.

⬇️DOWNLOAD the example file here: https://www.myonlinetraininghub.com/excel-functions-for-financial-modeling

?RELATED LESSONS

- 5 Excel Sum Function Tricks: https://www.myonlinetraininghub.com/5-excel-sum-function-tricks

- SUMPRODUCT Function: https://www.myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs

- IF, Nested IF, IFS Formulas: https://www.youtube.com/watch?v=0zTeXujtOZI

- IF Formula Builder Tool: https://www.myonlinetraininghub.com/excel-if-and-or-functions-explained

- XLOOKUP Function: https://youtu.be/2ViMm-wuM3U

- VLOOKUP Function: https://www.youtube.com/watch?v=4-5-TBhOP6Q

- INDEX Function - 5 Secret Features: https://www.youtube.com/watch?v=pP7AMLJa0Vc


❓What functions do you think are essential to financial modeling? Let me know in the comments.


? LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

? SUBSCRIBE if you’d like more tips and tutorials like this.

? Please leave me a COMMENT. I read them all!

? CONNECT with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

? SHARE this video and spread the Excel love.

Or if you’re short of time, please click the ?

? EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum



⏲ TIMESTAMPS
0:00 Excel Functions for Financial Modeling
0:27 Standard Aggregating Functions
1:31 Conditional Aggregating Functions
2:59 Logical Functions
8:41 Lookup Functions
11:47 Financial Functions
15:51 Date Functions