Skill Development Microsoft Excel - Beginner to Pro by CA Agrika Khatri

Index

Topic

1. Opening first Excel worksheet, Introduction of every element on sheet and defining range
2. Navigation, Data Entry, Formatting and basic calculation
3. Copying formulas, Relative and Absolute Referencing
4. Comprehensive practice of Relative and absolute referencing
5. Referencing further practice
6. Quick revision, explaining ribbon and excel shortcuts
7. Backstage of excel ie. File Tab and introducing the operational shortcuts L1
8. Backstage of excel ie. File Tab and introducing the operational shortcuts L2
9. Customizing the ribbon intro to formula tab
10. TRUE, FALSE, IF, AND, OR function
11. IF Function together with AND, OR function.
12. Nested if function
13. Autosum functions and mathematical exercises
14. Paste special function
15. Paste link, transpose, insert, delete and format cells function
16. Linking data between the sheets and its benefit
17. Conditional formatting
18. Count Function
19. Rank function, minimum, MAX, large and Small Function
20. Sumif, SumIFS
21. CountIF, Averagelf Function
22. Mround, Ceiling, Floor
23. Rounddown, RoundUp functions
24. Integer and Trunc functions
25. Trim and Proper Function
26. Find and Search Function
27. Upper, lower and Proper Function
28. AND FUNCTION
29. Concatenate Function.mp4
30. Repeat and Substitute Function
31. Substitute function practice
32. Substitute and repeat Function
33. Replace Function
34. Date and Time Function Introduction
35. Customise your own date format
36. Today Function and addition, subtraction to dates
37. EDATE Function
38. EOM Function
39. Introduction to chart and different ways of inserting a chart
40. introducing all the chart elements and formatting each element
41. improving your chart by using various charts layouts, colours and designs
42. Data series editing, saving a template and other basic chart details
43. When to use which chart type-an intro & winding up session
44. VLOOKUP Function
45. MATCH & HLOOKUP Function
46. Tell me what do you want option in excel
47. Protecting, freeze panes, show and customize the ribbon
48. Undo last step vs. Undo many steps at one go
49. Table making, designing, Sort & Filter in table mode and with the use of Slicer option
50. AutoCorrect function for short hand writing, Automatic decimal entry and various miscellaneous points in FILE Tab
51. Intro to advance course, solution of error in answers when we decrease the decimal
52. Advance Date Function, YEARFRAC, DATEDIF, combined uses of many functions together
53. DATEVALUE, VALUE Function, Custom Formatting to solve many excel problems
54. Combined use of DATEVALUE and Function
55. Revision of all date time functions, DAY function, DAYS Function, combined use of DATE YEAR MONTH AND DAYS Function
56. Lets do some finance on excel. Beginning with NPV
57. IRR and XIRR Function
58. Modified IRR
59. Its easy to create a loan amortisation schedule on excel. Using PMT Function
60. PMT and IPMT Function
61. Effective annual rate of interest. EFFECT Function
62. Depreciation schedule made easy. DB Function
63. Future Value Function
64. Perform Net Present Value on Excel (Finance Function)
65. Concept of Beta in Finance and its calculation on Excel
66. Address Function
67. Area Function
68. Row, Column Function and FormulaText Function
69. FormulaText Function practice and Hyperlink creation
70. Index and Match Function
71. Some Practice
72. Transpose Function Vs. Paste Special
73. Offset Function
74. Offset as an array function
75. Minute and Month Function
76. Month Function additional exercises
77. Network Days Function
78. Array Function help save time
79. Databse Function
80. Validation
81. Protection and Hiding
82. Goal Seek Analys/
83. Subtotal Function
84. What if analysis Data Table
85. Scenario Manager
86. Summary of Scenario Manager
87. Shortcut Revision and more advance shortcuts
88. Advance Shortcut Continued (Part I)
89. Advance Shortcut Continued (Part II)
90. Add or create a PPT or WORD within your Excel sheet
91. Advance Fill Sequence
92. Audit tools in excel - Evaluate formula
93. 3D and consolidate data function
94. Let excel speak to you