Excel for Accounting & Finance: Functions & Formulas
Excel for Accounting & Finance: Functions & Formulas
.MP4, AVC, 1920x1080, 30 fps | English, AAC, 2 Ch | 5h 30m | 2.49 GB
Instructor: Irfan Sharif
.MP4, AVC, 1920x1080, 30 fps | English, AAC, 2 Ch | 5h 30m | 2.49 GB
Instructor: Irfan Sharif
Master Functions, Formulas, Tips & Tricks meant specifically for Accounting and Finance.
What you'll learn
- Accounting functions in Microsoft Excel
- Finance functions in Microsoft Excel
Requirements
- Excel 2010 or later edition
- Basic working knowledge of Excel
- Depreciation and common methods of depreciation
- Basic knowledge of Finance like time value of money, compounding and discounting
- Concept of NPV and IRR
Description
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.
Who should take this course:
- Accounting students
- Finance students
- Accounting professionals
- Finance professionals
- Entrepreneurs and Business Owners with Finance knowledge
- Investors with Finance knowledge
Why you should learn Excel for Finance and Accounting:
This course will change the way you work and will save your hours otherwise spent on complex calculations. You will be able to calculate the values you need for analysis and decisions just by writing small and easy formulas. The rest of your time can then be spent on tasks that matter!
Prerequisite:
This course expects you to have basic knowledge of Excel, Finance, and Accounting. Let me be more precise on what you should know before starting this course.
Excel:
- Basic navigation and cell formatting
- Basic maths functions like plus, minus, multiply and divide
Accounting:
- Concept of depreciation and methods of depreciation
Finance:
- Concept of Time Value of Money
- Present Value and Future Value concept
- Conversion from present value to future value, and from future value to present value
- Concept of Discount factor and Annuity
- Concept and calculation of NPV
- Concept of calculation of IRR
Topics Covered:
- Calculation of depreciation with Excel formulas
- Calculation of PV and FV with Excel formulas
- Calculation of NPV with Excel formulas
- Calculation of IRR with Excel formulas
Who this course is for:
- Accounting and Finance Students
- Accounting and Finance Professionals
- Aspiring Financial Analysts
- Business owners with finance knowledge
Excel for Accounting & Finance: Functions & Formulas
