93255 35979 Radicalcomputertechnology@gmail.com

 

 

 

01. Microsoft Excel Introduction

 

02. Basic Formulas-1

 

03. If Formula-1

 

04. If And If Or Formula-1

 

05. Nested If-1

 

06. Nested If Calculate Discount-1

 

07. Salary Sheet Basic Formulas-1

 

08. Salary Sheet Nested If-1

 

09. Attendance Sheet-1

 

10. Attendance Sheet Countif Formula-1

 

11. Sort, Custom Sort & Filter-1

 

12. Conditional Formatting Basic-1

 

13. Conditional Formatting Advance-1

 

14. C.F Highlight Alt Rows-1

 

15. Advance Filter-1

 

16. Advance Filter Micro-1

 

17. Auto Sort Macro-1

 

18. Text To Columns-1

 

19. Flash Fill-1

 

20. Remove Duplicate And Cosolidate-1

 

21. 3D Formula-1

 

22. Data Validation-1

 

23. Scenario Managerl-1

 

24. Goal Seek-1

 

25. Data Table-1

 

26. Home Tab-1-1

 

27. Home Tab 2-1

 

28. Home Tab 3-1

 

29. Home Tab-4

 

30. Find And Replace-1

 

31. Goto Special-1

 

32. Paste Special-1

 

33. Pivot Table - Introduction-1

 

34. Pivot Table - Filter User

 

35. Pivot Table - Options -1

 

36. Slicer And Timeline-1

 

37. Pivot Chart In Excel

 

38. Auto Refresh Pivot Table

 

39. Table In Excel-1

 

40. Insert Tab-1

 

41. Insert Tab-2

 

42. Excel Chart📉

 

43. Excel Chart and Formatting

 

44. Excel Sparkline Chart

 

45. Hyperlink in Excel

 

46. Insert Tab-3

 

47. Watermark in Excel

 

48. Pagelayout Tab- Themes and Margins-1

 

49. Pagelayout Tab- Print Settings-1

 

50. Pagelayout Tab-2

 

51. Pagelayout Tab 3-1

 

52. Formula Tab - Name Manager -1

 

53. Formula Tab- Formula Auditing-1

 

54. Data Tab - Get External Data

 

55. Data Tab- SubTotal

 

56. Data Tab - Solver add- Ins

 

57. Review Tab

 

58. View Tab-1

 

59. Macro Recording-1

 

60. Create Your Own Tab

 

61. V- lookup intro-1

 

62. V-lookup 2- Use Of Range Lookup-1

 

63. V-lookup 3 Double V-lookup

 

64. V-lookup 4 Nested V-lookup

 

65. V-lookup 5 - V-lookup Project

 

66. V-lookup 6 - Unique Example Of V-lookup

 

67. Count A and Count Blank Formula

 

68. Countif Formula

 

69. Countif Formula

 

70. Sumif-and sumifs

 

71. Averageif and Averageifs

 

72. Frequency Formula

 

73. Index and Match

 

74. Lookup Formula

 

75. Sum Product, Left and Find Formula

 

76. Right and Find

 

77. Mid and Find Formula

 

78. Repeat and substitute Formula

 

79. PMT, PV, FV Formula

 

80. IPMT AND PPMT

 

81. V-lookup with Match

 

82. Text Formulas-1

 

83. Date in Quarter

 

84. Datedif Formula

 

85. Date Formula

 

86. Switch Date-1

 

87. More Date Formula-1

 

88. Ranking Formula

 

89. Concatenate and V-lookup

 

90. Sheet Tips-1

 

91. Excel To PowerPoint

 

92. Change Excel Icon

 

93. Number To Word

 

94. Custom Cells Tips-1

 

95. Picture Lookup

 

96. Picture Game

 

97. Date Entry Form

 

98. Fiel Menu

 

99. Excel Settings-1

 

100. Short Formulas-1

 

101. Excel- Database Function Dget Formula Of Excel-1

 

102. Excel Dsum Formula In Excel-1

 

103. Excel Daverage Formula-1

 

104. Excel Dcount, Dcounta Formulas-1

 

105. Excel Dmax Formula , Dmin Formula , DProduct Formy-1

 

106. Excel- V-lookup On Multiple Tables-1

 

107. Excel-Offset Formula Introduction -1

 

108. Excel Offset Formula Calculate Sum of Last 6 Days-1

 

109. Excel Offset Formula Real Job Use-1

 

110. Excel Sumif, Index, Match Real Job Use-1

 

111. Excel Practical Use Of Isblank and Istext Formula-1

 

112. Excel Counting Words in Excel Interview Questions-1

 

113. Excel Build Login in Excel Formulas-1

 

114. Excel Create Dynamic List Using Index , Match Formula-1

 

115. Excel- Conditional Formatting with Text and  Or Formulas-1

 

116. Excel- Unique Example Of Conditional Formatting-1

 

117. Excel-Auto Sort Data Using Countif, Match and Index Formulas-1

 

118. Excel-Condition Inside Rank Using Countifs Formula-1

 

119. Excel- Camera, Autofilter ,Form-3 Hidden  Features-1

 

120. Excel Max If and Min If Formula Using Array-1

 

121. Excel Choose Formula in Excel

 

122. Excel Swap Range in Excel-1

 

123. Excel- Reverse Lookup Using Choose Formula-1

 

124. Excel-Reverse Lookup Using Match and Index-1

 

125. Excel-Find & V-lookup Real Job Query-1

 

126. Excel- V-lookup Duplicate Names Issue-1

 

127. Excel V-lookup with Choose Formula and Array-1

 

128. Excel-Text join Formula in Excel 2019-1

 

129. Excel-ifs Formula in Excel 2019-1

 

130. Excel - Maxifs and Minifs in Excel 2019-1

 

131. Excel Filter Formula of Office 365

 

132. Excel- Sort Formula of Office 365

 

133. Excel-Real Job Use Of Aggregate Formula in Excel

 

134. Excel- Xlookup in Office 365-1

 

135. Excel- Xlookup in Office 365-2

 

136. Excel Xlookup Work Reverse 3

 

137. Excel - Xlookup in Office 365-4

 

138. Excel - Xlookup in Office 365-5

 

139. Excel -Xlookup in Office 365-6

 

140. Excel-Xlookup in Office 365-7

 

141. Excel-Xlookup in Office -8-1

 

142. Excel- Xlookup in Office 365- 9- 1

 

143. Excel-Xlookup in Office 365 -10 -1

 

144. Excel - Xmatch Formula Office 365-1

 

145. Excel - Create Searchable Drop Down List in Office 365-1

 

146. Excel-Analyze Data and Get ideas Office 365-1

 

147. Excel - Map Chart in Office 365-1

 

148. Excel- Dynamic Conditional Formatting-1

 

149. Excel- Unique Formula in Office 365-1

 

150. Excel Sequence and   

Random

         Array Formula in Office      365-1

 

151. Excel-Assignment 1 with     

         Answer -365-1

 

152. Excel - Assignment 2 with

         Answer 365

 

153. Excel - Assignment 3 with

        Answer 365

 

154. Excel-Assignment 4 with      

         Answer365

 

155. Excel Interview Questions 1-1

 

156. Excel Interview Questions 2

 

157. Use Your Brain 🧠- Interview

         Questions

 

158. Interview Question - Mode

        Function

 

159. Interview Question - Goto and

        Conditional Formatting

 

160. Vstack Formula in Office 365

 

 âœ…🖥ï¸?🖱ï¸?💯ðŸ‘?ðŸ?»