Excel: Financial Functions in Depth
Focused View
Danielle Stein Fairhurst
2:23:15
342 View
01 - Perform financial analysis in Excel.mp4
00:43
02 - What you should know.mp4
01:28
03 - Disclaimer.mp4
00:38
01 - PMT Calculate a loan payment.mp4
04:12
02 - PPMT and IPMT Calculate the principal and interest payments.mp4
03:15
03 - Splitting interest and principal payments.mp4
03:24
04 - CUMPRINC and CUMIPMT Cumulative principal and interest.mp4
03:02
05 - EFFECT and NOMINAL Nominal and effective interest rates.mp4
03:16
06 - ACCRINT and ACCRINTM Calculate accrued investments interest.mp4
02:36
07 - RATE Discover the interest rate of an annuity.mp4
02:11
08 - PDURATION Calculate the periods to reach a goal.mp4
01:54
09 - NPER Calculate the number of periods in an investment.mp4
02:31
01 - SLN Depreciation using the straight line method.mp4
03:00
02 - DB Depreciation using the declining balance method.mp4
03:35
03 - DDB Depreciation using the double-declining balance method.mp4
02:39
04 - SYD Calculate depreciation for a specified period.mp4
01:22
05 - VDB Declining balance depreciation for a partial period.mp4
02:17
06 - Comparing depreciation functions.mp4
05:37
01 - FV Future value of an investment.mp4
03:14
02 - FVSCHEDULE Future value with variable returns.mp4
01:04
03 - Escalating with compounding interest or growth rates.mp4
03:03
04 - PV Present value of an investment.mp4
00:54
05 - NPV Net present value of an investment.mp4
04:58
06 - XNPV Net present value given irregular inputs.mp4
02:12
07 - IRR Internal rate of return.mp4
01:24
08 - XIRR Internal rate of return for irregular cash flows.mp4
01:07
09 - MIRR Internal rate of return for mixed cash flows.mp4
00:56
10 - RRI The interest rate for the growth of an investment.mp4
01:03
01 - STOCKHISTORY Get historical stock prices.mp4
03:40
02 - Live stock prices with Stocks data types.mp4
02:51
03 - Calculate exchange rates with Currencies data types.mp4
04:03
04 - FIELDVALUE Get field data.mp4
03:07
05 - STOCKHISTORY with data types.mp4
02:13
06 - Charting STOCKHISTORY with data types.mp4
06:01
01 - EOMONTH, EDATE, and timing flags.mp4
04:50
02 - Calculate pro data rental costs with date functions.mp4
04:09
03 - IF Building logical comparisons.mp4
05:21
04 - Calculating the payback period.mp4
04:27
05 - Using RATE or RRI for compound annual growth rate (CAGR).mp4
04:46
06 - Creating a debt schedule.mp4
04:50
07 - Using SLN and IF to calculate depreciation.mp4
03:10
08 - Creating a depreciation schedule.mp4
03:51
09 - Using dynamic arrays to create a depreciation waterfall.mp4
06:15
10 - Calculating weighted average cost of capital (WACC).mp4
06:21
11 - Using NPV to calculate a discounted cash flow (DCF).mp4
04:34
01 - Where to learn more about Excel.mp4
01:11
Description
Analyzing financial data can seem intimidating, but Microsoft Excel has a wide range of functions to perform these calculations quickly and easily. In this course, Microsoft MVP Danielle Stein Fairhurst shows you how and when to use each of the financial functions available in Excel. Danielle covers 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. Plus, she guides you through combining these functions to perform financial analysis.
More details
User Reviews
Rating
average 0
Focused display
Danielle Stein Fairhurst
Instructor's CoursesDanielle Stein Fairhurst is regularly engaged as a speaker, course facilitator, financial modelling consultant and analyst. She founded the Financial Modellers’ Meetup groups (which currently meet virtually) and she is the author of “Using Excel for Business and Financial Modelling” Third Edition and “Financial Modeling in Excel For Dummies”.
With many years of experience, a talent for financial modelling and professional approach, she helps her clients create meaningful financial models in the form of business cases, pricing models and management reports. She runs regular training seminars around Australia and globally, and her custom-built training courses have been described by attendees as well-presented, neatly structured, informative, practical, and extremely relevant to their everyday needs. She is available for presentations, workshops, training courses, lectures and seminars. Topics include Financial Modelling using Excel, Budgeting & Forecasting and Data Analysis & Reporting.
She holds a Master of Business Administration (MBA) from Macquarie Graduate School of Management, and has taught management accounting subjects at Sydney University. She is on the judging panel for the 2020 Financial Modelling Innovation Awards, the Advisory Board of the Financial Modeling Institute (FMI) and was on the Diversity Council for the ModelOff Financial Modeling World Championships.
Specialisations:
Financial modelling / Budgeting and Forecasting / Business cases and pricing models / Data Analysis / Activity Based Costing / Management Reporting
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 46
- duration 2:23:15
- Release Date 2023/03/01
