Uploaded August 2023 | Updated November 2026, 2 days ago
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: myonlinetraininghub.com/excel-functions-for-financial-modeling
📚RELATED LESSONS
- 5 Excel Sum Function Tricks: myonlinetraininghub.com/5-excel-sum-function-tricks
- SUMPRODUCT Function: myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs
- IF, Nested IF, IFS Formulas: youtube.com/watch?v=0zTeXujtOZI
- IF Formula Builder Tool: myonlinetraininghub.com/excel-if-and-or-functions-explained
- XLOOKUP Function: youtu.be/2ViMm-wuM3U
- VLOOKUP Function: youtube.com/watch?v=4-5-TBhOP6Q
- INDEX Function - 5 Secret Features: 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: 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: 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: 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
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: myonlinetraininghub.com/excel-functions-for-financial-modeling
📚RELATED LESSONS
- 5 Excel Sum Function Tricks: myonlinetraininghub.com/5-excel-sum-function-tricks
- SUMPRODUCT Function: myonlinetraininghub.com/excel-sumproduct-an-alternative-to-sumifs
- IF, Nested IF, IFS Formulas: youtube.com/watch?v=0zTeXujtOZI
- IF Formula Builder Tool: myonlinetraininghub.com/excel-if-and-or-functions-explained
- XLOOKUP Function: youtu.be/2ViMm-wuM3U
- VLOOKUP Function: youtube.com/watch?v=4-5-TBhOP6Q
- INDEX Function - 5 Secret Features: 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: 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: 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: 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










