Financial Analysis in MS Office Search for: Current Status Not Enrolled Price $INR 1799/- for a Year Get Started Buy Now Course Content 1. Warning 2. Excel Functions 3. Insert Hyberlinks Into Excel Spreadsheet 4. Macors Are A Great Timesaver! 5. Using Absolute & Relative Cell References 6. Find And Select Cells That Meet Specific Conditions 7. How To Create Dynamic Name 8. Using Named Ranges To Make Formulas More Readable 9. Custom Formatting 10. Using Custom Sort 11. Saving Time In Excel 12. Multiply By 1 13. Find And Replace – References 14. Find And Replace – Formatting 15. References 16. Key Excel Functions If 17. Key Excel Functions Sumif, Sumifs 18. Key Excel Functions Count, Counta, Countif, Countifs 19. Key Excel Functions Average & Averageif 20. Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, & 21. Working With Text In Excel 22. Use Round In Your Financial Models 23. Excel’s Lookup Functions Vlookup & Hlookup 24. Index, Match, And Their Combination – The Perfect Substitute Of Vlookup 25. Using Excel’s Iferror Function To Trap Spreadsheet Errors-1 26. The Rank Function 27. Creative Flexible Financial Models With Choose 28. Analysis With Excel’s Data Tables Functionality 29. Discounting Cash Flows 30. Calculating Internal Rate Of Return (IRR) 31. Date Functions 32. Using The Pmt Function To Create A Complete Loan Schedule 33. Using Lookup Functions (Vlookup) To Fill The Database Sheet 34. Using Sumif To Complete The Database Sheet 35. Using Index & Match As A Substitute For Vlookup 36. Financial Accounting 37. P & L Sheet 38. A Practical Example 39. P & L Sheet With Sumif 40. How To Find Mistakes With Countif 41. Calculating Growth Rates In Excel 42. Practical Exercise 1- Sumifs 43. Practical Exercise 2- Sumifs 44. Making Your Excel Charts Sexier – Proven Tips 45. Trends With Sparklines 46. Stacked Column Chart With A Secondary Axis 47. Doughnut Chart