arrow_back
00. Message form Educator
01. Opening first Excel worksheet, introduction of every element on sheet and defining range
02. Navigation, Data Entry, Formatting and basic calculation
03. Copying formulas, Relative and Absolute Referencing
04. Comprehensive practice of Relative and absolute referencing
05. Referencing further practice
06. Quick revision, explaining ribbon and excel shortcuts
07. Backstage of excel i.e. File Tab and introducing the operational shortcuts L1
08. Backstage of excel i.e. File Tab and introducing the operational shortcuts L2
09. 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, AverageIf 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
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 and winding up session
44. VLOOKUP Function
45. MATCH and 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 and 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. Let's 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. Use 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 Formula Text Function
69. Formula Text 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. Database Function
80. Validation
81. Protection and Hiding
82. Goal Seek Analysis
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 L1
89. Adv shortcut continue L2
90. Add or create a PPT or WORD within your Excel sheet90. 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
95. Easy to view the same excel sheet side by side for easy analysis
96. Make your excel sheet print ready. Print and page setup
97. Pivot L1
98. Pivot L2
99. Pivot L3
100. Pivot L4
101. Macro VBA introduction L1
102. Macro VBA introduction L2
Ebook & Practice Workbook
Excel Worksheet 1
Excel Worksheet 2
Excel Worksheet 3
Excel Worksheet 4
Excel Worksheet 5
Excel Worksheet 6
Excel Worksheet 7
Excel Worksheet 8
Excel Worksheet 9
Excel Worksheet 10
Excel Worksheet 11
Excel Worksheet 14
Excel Worksheet 15
Excel Worksheet 16
Excel Worksheet 17
Excel Worksheet 18
Excel Worksheet 19
Excel Worksheet 20
Excel Worksheet 21
Excel Worksheet 22
Excel Worksheet 23
Excel Worksheet 24
Excel Worksheet 25
Excel Worksheet 26
Excel WorkSheet 27
Excel WorkSheet 28
Excel WorkSheet 29
Excel WorkSheet 30
Shortcuts PDF
Excel Shortcuts