Excel: Financial Functions in Depth

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.

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

About the Author

Curt Frye is the president of Technology and Society, Incorporated. He is the author of more than 40 books, including Microsoft Excel 2019 Step by Step for Microsoft Press, and has created and recorded more than 60 courses for Lynda.com and LinkedIn Learning. As a speaker, he has presented talks on topics including “Rhetorical Mathematics” for CLE credit at the Law and Magic conference, “Business Storytelling Using Microsoft Excel” at the ATD-Cascadia annual conference, and his Improspectives® approach to applying the techniques of improv theater to business and life for numerous audiences. As a performer, he has appeared in over 1,300 improv comedy shows with ComedySportz Portland and presents his Magic of the Mind show to theatrical and corporate audiences. Curt earned his BA in political science from Syracuse University and his MBA from the University of Illinois.

Video Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Intermediate
• Video Duration: 2h 35m
• Instructor: Curt Frye