Excel 2013: Financial Functions in Depth
Excel 2013: Financial Functions in Depth
MP4 | Video: 720p | Duration: 2:38:02 | English | Subtitles: VTT | 297.6 MB
MP4 | Video: 720p | Duration: 2:38:02 | English | Subtitles: VTT | 297.6 MB
Analyzing financial data can seem intimidating, but Excel 2013 has a wide range of functions that you can use to perform these analyses quickly and easily. This course shows users how and when to use each of the functions available to them in Excel 2013. Learn how to evaluate cash flows; calculate depreciation; determine rates of return, bond coupon dates, and security durations; and more.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
Topics include:
- Analyzing loans, payments, and interest
- Calculating depreciation
- Determining values and rates of return
- Calculating bond coupon dates and security durations
- Calculating security prices and yields
- Calculating prices and yields of securities with odd periods
- Analyzing simulation results