Excel for Accounting & Finance: Functions & Formulas

$0.99
Instructor:
Irfan Sharif ACA ACCA | #1 Best Selling Instructor of Accounting & Bookkeeping
Category:

Microsoft Excel has hundreds of functions and formulas to store, analyze, and alter data efficiently. However, no one really needs to know all of them to be able to work effectively on Excel.

In this course, you will learn key functions that are required most used by Finance and Accounting users when they are working with their business data. These functions include finding, replacing, sorting, filtering, summarizing, and analyzing data. Additionally, you will also learn how to bring in a particular data against a specific row parameter from other excel sheets.

 

What you’ll learn
  • Accounting functions in Microsoft Excel
  • Finance functions in Microsoft Excel
Course content
12

12 sections • 72 lectures • Total duration 5 h 33 min

Getting to know Excel
Depreciation with Excel
Present Value & Future Value
Net Present Value and IRR
Loan & Mortgage Repayment
Nominal and Effective Rate of Interest
Bond Valuation
What-if Analysis
Financial Statement Preparation with Pivot Tables
Financial Statement Vertical and Horizontal Analysis:
Other miscellaneous
Bonus Section