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