Preview Microsoft Excel - Beginner to Pro (3 Months Subscription)

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

Preview - Microsoft Excel - Beginner to Pro (3 Months Subscription)