Date and Financial Functions

Date and Financial Functions

$79.00 for 1 year

Course Overview:

This course covers Date and Financial Functions in Excel. Date functions enable you to easily manipulate dates in Excel and financial functions replace all the tables of financial functions in finance textbooks.

Key Topics:

  • Learn how to use 6 different functions to manipulate dates
  • How to input a static date (a date that doesn’t change) into a workbook
  • How to take the present value (NPV) of a sequence of uneven cash flows with regular and irregular spaced cash flows
  • How to find the internal rate of return (IRR) on a sequence of uneven cash flows with regular and irregular spaced cash flows
  • Learn all of the financial functions used to analyze loans and mortgages

Who Will Benefit?

Any professional that uses Microsoft Excel for finance or accounting. Excel was built for finance and this course shows how to utilize the most powerful date and financial functions Excel has to offer.

Category: