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