It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.
MGAC02: Intermediate Financial Accounting II
The guide introduces Excel and TVM functions to MGAC02 students.
Introduction to Excel and Time Value of Money Functions
The original playlist consists of 4 modules and is intended for MGFB10 students. MGAC02 students may skip module 1 and 4 to take advantage of the Excel training.
Module 2 Basics of Excel 13:16
Module 3 Excel functions (TVM) 7:53
By the end of this workshop, you will know:
when to use absolute and relative cell referencing
how to write accurate formulae in Excel
know how to use Time Value of Money functions (FV, PV, RATE, NPER, PMT, NPV, etc)