Excel 2013 - Financial functions using Excel

Course details

The course is designed to enable its candidates learn about the various built in financial functions in Excel. These excel functions are great tools in financial analysis. It helps to analyze the financial data and improve the research process. Investment Bankers, Equity Analysts, Private Equity Professionals, Credit Research Professionals and Financial Analysts spend most of their time in Excel. If these professionals do not have a good hold of financial functions in excel, their work increases by manifold. They need to understand various shortcuts, several regularly used functions and have to be experts on those. This course is perfect for those professionals. This course is ideal for students and professionals looking forward to a great career in the world of Finance. This course can be taken by Anyone who wants to enhance their finance knowledge by learning it in excel and work more effectively and efficiently. The Pre-Requisites for this course is Basic knowledge of excel and finance. Participants are going to study various finance functions in excel and its application. We will be covering the following modules in this online course on Excel 2013:

• Future Value, SI, CI, PV, NPER, RATE
• Value of an investment with multiple cash flows

• Calculating Rate of Return

• NPV, XNPV, XIRR

• Analyzing loans and payments

• Bond Valuation