Microsoft Excel for Finance, Accounting & Financial Analysis
- Descrição
- Currículo
- FAQ
- Revisões
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
Money-Back Guarantee:
Nothing to lose! If you will not be satisfied with the course, Udemy offers 30 days money-back guarantee!
Introduction to the teacher:
Chartered Accountant | 12 years of work experience | 12 years of teaching experience as visiting faculty
I am a Certified Chartered Accountant (ACCA) from the UK with 12 years of professional work and teaching experience and have taught more than 4,000 students in class and 80,000+ students on Udemy!
I have implemented accounting software and ERP at various organizations and have expertise in financial transformation. I have been leading accountancy practice for small and medium-sized entities for the last 4 months and have frequent interaction with entrepreneurs. So I know what exactly do entrepreneurs need to know to well manage their books. So, Microsoft Excel is what I use most of my day! I love this software, not just because it enables us to do a lot with data, but also because it is very simple and easy to use.
-
1Navigating the course and course setupTexto
-
2Getting started with ExcelVídeo Aula
-
3Understanding and working with CellVídeo Aula
-
4Understanding and working with ColumnVídeo Aula
-
5Understanding and working with RowVídeo Aula
-
6Mastering Copy PasteVídeo Aula
-
7Mastering AutofillVídeo Aula
-
8Intelligent Navigation with Excel dataVídeo Aula
-
9Basic Mathematical functionsVídeo Aula
-
10Unlocking Keyboard shortcuts with MasterkeyVídeo Aula
-
11Homework: Entering 10 records in ExcelVídeo Aula
-
12Best practices - entering data in ExcelVídeo Aula
-
13Revising the Accounting concept of deprecationVídeo Aula
-
14Section ResourcesTexto
-
15SLN - Straight Line MethodVídeo Aula
-
16DB - Declining Balance MethodVídeo Aula
-
17DDB - Double Declining BalanceVídeo Aula
-
18SYD - Sum of Years Digits MethodVídeo Aula
-
19VDB - Variable Declining BalanceVídeo Aula
-
20Homework: Practice of Depreciation with Excel formulasTexto
-
21Introduction to PV and FVVídeo Aula
-
22Section ResourcesTexto
-
23Calculating Future Value from Present Value, & Present Value from Future ValueVídeo Aula
-
24Revising Annuity ConceptVídeo Aula
-
25Calculating PV of AnnuityVídeo Aula
-
26Calculating FV of AnnuityVídeo Aula
-
27Calculating FV with changing interest ratesVídeo Aula
-
28Homework: Calculating PV & FVTexto
-
29Calculating Discount Rate =RATEVídeo Aula
-
30Calculating Number of Periods: =NPERVídeo Aula
-
31Section Outline and Practice filesTexto
-
32NPV - Revising the NPV ConceptVídeo Aula
-
33Net Present Value - NPVVídeo Aula
-
34XNPVVídeo Aula
-
35Revising the concept of IRRVídeo Aula
-
36IRR - Internal Rate of ReturnVídeo Aula
-
37XIRRVídeo Aula
-
38Homework: Calculate NPV and IRRTexto
-
39MIRRVídeo Aula
-
40PDURATIONVídeo Aula
-
41RRIVídeo Aula
