My very first course “Financial Functions in Depth” has just been released and I couldn’t be more excited about it. I had so much fun recording with the fantastic team at LinkedIn and I can’t wait to share it with you. There are so many functions now available in Excel and in this course, we cover the tools specific to Finance such as evaluating loans, payments, and interest; calculating depreciation; determining rates of return; calculating prices and yields as well as applying some of the new features of Excel for Microsoft 365 to financial data.
Excel for Microsoft 365 is evolving all the time and there are now over 500 different functions in Excel! One of the best things you can do for your career in Finance is to improve your Excel skills – and keep them up to date. In this course, we’ll cover the most important, need to know functions and look at examples of how to apply them in the real world.
The 24 hours will begin as soon as you start watching and will unlock this course only. If you sign up for the 30-day trial, you'll get access to my course as well as thousands of others. You'll need to put in your credit card details but you'll be reminded 7 days before you get charged. Note that the subscription option is an affiliate link, so I may be compensated if you purchase something from LinkedIn Learning.
In this course:
- Analyzing Loans, Payments and Interest
- PMT: Calculate a loan payment
- PPMT and IPMT: Calculate the principal and interest payments
- Splitting Interest and Principal Payments
- CUMPRINC and CUMIPMT: Cumulative principal and interest
- EFFECT and NOMINAL: Nominal and effective interest rates
- ACCRINT and ACCRINTM: Calculate accrued investments interest
- RATE: Discover the interest rate of an annuity
- PDURATION: Calculate the periods to reach a goal
- NPER: Calculate the number of periods in an investment
- Calculate Depreciation
- SLN: Depreciation using the straight line method
- DB: Depreciation using the declining balance method
- DDB: Depreciation using the double-declining balance method
- SYD: Calculate depreciation for a specified period
- VDB: Declining balance depreciation for a partial period
- Comparing Depreciation functions
- Determining Values and Rates of Return
- FV: Future value of an investment
- FVSCHEDULE: Future value with variable returns
- Escalating with compounding interest or growth rates
- PV: Present value of an investment
- NPV: Net present value of an investment
- XNPV: net present value given irregular inputs
- IRR: internal rate of return
- XIRR: Internal rate of return for irregular cash flows
- MIRR: internal rate of return for mixed cash flows
- RRI: the interest rate for the growth of an investment
- Functions and Data Types in Excel for Microsoft 365
- STOCKHISTORY: Get historical stock prices
- Live stock prices with Stocks Data Types
- Calculate exchange rates with Currencies Data Types
- FIELDVALUE: Get field data
- STOCKHISTORY with Data Types
- Charting STOCKHISTORY with Data Types
- Combining functions perform financial analysis
- EOMONTH, EDATE and timing flags
- Calculate pro rata rental costs with date functions
- IF: building logical comparisons
- Calculating the payback period
- Using RATE or RRI for Compound Annual Growth Rate (CAGR)
- Creating a debt schedule
- Using SLN & IF to calculate depreciation
- Creating a depreciation schedule
- Using dynamic arrays to create a depreciation waterfall
- 10 Calculating Weighted Average Cost of Capital (WACC)
- 11 Using NPV to calculate a Discounted Cash Flow (DCF)
Conclusion
- Where to learn more about Excel
