Excel for Finance - 25 Functions You NEED to KNOW (File Included)

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.

📚RELATED LESSONS

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

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

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


🎁 SHARE this video and spread the Excel love.

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

⏲ 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

[xant]

Sometimes I watch these videos and feel disappointed because I already knew everything in them. And then I remember how frustrating it is to receive spreadsheets from colleagues who _don’t_ know these formulas, and I feel grateful you're teaching so many essential but non-universal excel skills!
Thank you!

[sachinrv]

Thanks for this video for Finance & Accounts (F&A) persons like me. Excel has been the BEST FRIEND of finance & accounts people. Actually use of any formula depends on the data type, the data size and need of the situation. Excel is so vast that there are more than couple of approches to do the same thing. One with which the user is comfortable is to be adopted. In my work area of financial compliance, SUMIF, SUMIFS, COUNTIF COUNTIFS, XLOOKUP, SUMPRODUCT, FILTER, UNIQUE, TAKE, IFS are good enough to handle most of the situations. Thanks again :)

[IvanCortinas_ES]

Excellent summary Mynda. As always a delight for the eyes.

[mrefai]

you are my go-to person when it comes to excel. well done!

[patapo]

Thank you, my Super Teacher. Thanks again to you and to all your team.

[tibibara]

Super useful, detailed, very high quality tutorial, thank you! 🙏

[biljanamajstorova]

Thanks Mynda, i confirm using most of the ones mentioned here 😊 and would like to add one more very powerfull function - the OFFSET function, which in combination with SUM and MATCh function will do amazingly well to agregate data for MTD, YTD, QTD or FY figures, controlling it through slicers. MIN and MAX can add flavour as well here ...Very powerfull for financial statemets and variance analysis...😉

[joshuamanampiu]

You made my day. Never laughed so hard... Sum(63, 000, 5000 etc...😶

[OPiguy]

Superb recap/tutorial - thank you! Best videos on excel (which is a high bar)

[skvalparn]

Hoped for more advanced modelling like forecasting headcount in best way with the values changeing alot during periods(and similar thing). Hopefully you Will do more advanced world applicable excersises in the future!

Thanks!

[alexanderbaranov]

Thanks! I use IRR for checking lease transactions while auditing.

[miteshvohra]

Thanks for your insightful videos. Can you please explain how and/or if SUMPRODUCT can be used to calculate tax payable if we provide the tax slabs?

[bntenza]

Great tutorial as usual, with easy explanations. How do you use index and partial match, if for example the first two characters of the unique number are replaced and rest of the unique number remained the same?

[TomWolfer-ow]

Looks interesting. Does it include time series segment analysis and forecasting capability?

[gregsdoodles]

Excellent video as always, but....where can I buy that t-shirt???