Course Details
1. Intro to advance course,solution of error in answers when we decrease the decimal
2. Advance Date Function, YEARFRAC, DATEDIF, combined uses of many functions together
3. DATEVALUE, VALUE Function, Custom Formatting to solve many excel problems
4. Combined use of DATEVALUE and Function
5. Lets do some finance on excel. Beginning with NPV
6. IRR and XIRR Function
7. Modified IRR
8. PMT and IPMT Function
9. Effective annual rate of interest. EFFECT Function
10. Depreciation schedule made easy. DB Function
11. Future Value Function
12. Perform Net Present Value on Excel (Finance Function)
13. Concept of Beta in Finance and its calculation on Excel
14. Address Function
15. Area Function
16. Row, Column Function and FormulaText Function
17. FormulaText Function practice and Hyperlink creation
18. Index and Match Function
19. Some Practice
20. Transpose Function Vs. Paste Special
21. Offset Function
22. Offset as an array function
23. Minute and Month Function
24. Month Function additional exercises
25. Network Days Function
26. Array Function help save time
27. Databse Function
28. Validation
29. Protection and Hiding
30. Goal Seek Analysis
31 . Subtotal Function
32 . What if analysis Data Table
33 . Scenario manager
34 . Summary of scenario manager
35 . Shortcut revision and more advance shortcuts
36 . Advance fill sequence
37 . Audit tools in excel, evaluate formula
38 . 3D and consolidate data function
39 . Let excel speak to you
40. Pivot
2. Advance Date Function, YEARFRAC, DATEDIF, combined uses of many functions together
3. DATEVALUE, VALUE Function, Custom Formatting to solve many excel problems
4. Combined use of DATEVALUE and Function
5. Lets do some finance on excel. Beginning with NPV
6. IRR and XIRR Function
7. Modified IRR
8. PMT and IPMT Function
9. Effective annual rate of interest. EFFECT Function
10. Depreciation schedule made easy. DB Function
11. Future Value Function
12. Perform Net Present Value on Excel (Finance Function)
13. Concept of Beta in Finance and its calculation on Excel
14. Address Function
15. Area Function
16. Row, Column Function and FormulaText Function
17. FormulaText Function practice and Hyperlink creation
18. Index and Match Function
19. Some Practice
20. Transpose Function Vs. Paste Special
21. Offset Function
22. Offset as an array function
23. Minute and Month Function
24. Month Function additional exercises
25. Network Days Function
26. Array Function help save time
27. Databse Function
28. Validation
29. Protection and Hiding
30. Goal Seek Analysis
31 . Subtotal Function
32 . What if analysis Data Table
33 . Scenario manager
34 . Summary of scenario manager
35 . Shortcut revision and more advance shortcuts
36 . Advance fill sequence
37 . Audit tools in excel, evaluate formula
38 . 3D and consolidate data function
39 . Let excel speak to you
40. Pivot
Duration of Classes and Fees
2 Month Duration:
Rs. 4000/-
Contact Details
Call:
011-43053800, 7210032621, 9310178329
Email:
ssmm.stargate@gmail.com
