Tags
Language
Tags
<<
December 2024
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31 1 2 3 4
  1. Home
  2. eBooks & eLearning
  3. Excel: Financial Functions in Depth [Updated: 7/29/2021]

Excel: Financial Functions in Depth [Updated: 7/29/2021]

Posted By: IrGens
Date: 27 Sep 2021 23:36:47
Excel: Financial Functions in Depth [Updated: 7/29/2021]

Excel: Financial Functions in Depth [Updated: 7/29/2021]
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 2h 35m | 307 MB
Instructor: Curt Frye

Analyzing financial data can seem intimidating, but Microsoft Excel has a wide range of functions to perform these calculations quickly and easily. This course shows users how and when to use each of the financial functions available in Excel. Author Curt Frye covers evaluating loan payments; calculating depreciation; determining rates of return, bond coupon dates, and security durations; calculating prices and yields; and more.

Note: This course was recorded in Office 365, but anyone using a recent version of Excel—including 2019, 2016, and some earlier versions—will be able to follow along.

Learning objectives

  • 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 security yields
  • Evaluating the yields of securities with odd periods

More Info

Excel: Financial Functions in Depth [Updated: 7/29/2021]
UPWARDS