Excel Mastery Course

Satish Dhawale

Excel Mastery Course

Last Updated:May 22, 2021

Course Duration:50h

Total Enrolled:74

rating:

5.00(1 Ratings)

₹999.00

₹999.00

5.00(1 Ratings)

Material Includes

200+ Video Tutorials
Lifetime Access
Course Test
Course Completion Certificate
Practical Videos of 50+ Hours

Benefits of the course

materials include

course content

Ratings & Reviews

course description

This Course Includes ▶️ 200+ Video Tutorials of Excel Beginners to advance, MIS in Excel as well as Excel Power Query after learning this course you will be master in excel. You will learn a complete practical work of Back office, Banking and corporate sector. This course is for ⌛ Lifetime Access Including 👩‍💻 Course Test and 👨‍🎓 Course Completion Certificate with ▶️ Practical Videos of ⌚ 50+ Hours.

👉 अगर आप एक्सेल में MASTER बनाना चाहते हो तो मै आपको ये कोर्स पैकेज सजेस्ट करूँगा एक्सेल मास्टरी कोर्स

Including 3 Excel Courses

👉 Excel Beginners to Advance 150+ Videos
👉 Excel MIS Course 25 Videos
👉 Excel Powerquery Course 25 Videos

Benefits of the course

Excel Beginners to Advance 150+ Videos
Learn all formulas and Options of excel
Excel MIS Course 25 Videos
Create Dashboard, Reports and Charts
Excel Powerquery Course 25 Videos
Import and Transform Data

materials include

200+ Video Tutorials
Lifetime Access
Course Test
Course Completion Certificate
Practical Videos of 50+ Hours

course content

201 Lessons50h

Excel Beginners to Advance 150+ Videos

1 – Excel Introduction00:13:55

2 – Basic Formula in Excel00:20:14

3 – If Formula in Excel00:18:13

4 – If and If or Formula00:09:02

5 – Nested IF Formula in Excel00:10:30

6 – Nested if Calculate Discount00:14:51

7 – Salary Sheet Basic Formula00:13:08

8 – Salary Sheet Nested if00:15:32

9 – Attendance Sheet00:14:02

10 – Attendacne Sheet Countif Formula00:12:06

11 – Sort, Custom Sort & Filter00:17:41

12 – Conditional Formatting Basic00:13:23

13- Conditional Formatting Advance00:10:16

14- C F Higlight Alt Rows00:08:38

15 – Advance Filter00:12:26

16 – Advance filter Macro00:14:00

17 – Auto Sort Macro00:07:39

18 – Text to Columns00:05:00

19 – Flash Fill in Excel00:13:30

20 – Remove Duplicate and Consolidate00:08:40

21 – 3D Formula00:07:15

22 – Data Validation00:28:16

23 – Scenario Manager00:06:21

24- Goal Seek00:08:51

25 – Data Table00:05:31

26 – Home Tab 100:12:24

27 – Home Tab 200:11:10

28 – Home Tab 300:06:32

29 – Home Tab 400:09:53

30 – Find and Replace00:12:40

31 – Goto Special00:20:14

32 – Paste Special00:17:32

33 – Pivot Table Introduction00:13:28

34 – Pivot Table Filter Use00:08:23

35 – Pivot Table Options00:11:42

36 – Slicer and Timeline00:15:10

37 – Pivot Chart in Excel00:10:56

38 – Auto Refresh Pivot Table00:06:21

39 – Table in Excel00:10:56

40 – Insert Tab – 100:08:41

41 – Insert Tab200:08:05

42 – Excel Chart00:12:21

43 – Excel Chart and Formatting00:08:16

44 – Excel Sparkline Chart00:05:30

45 – Hyperlink in Excel00:04:32

46 – Insert Tab 300:11:58

47 – Watermark in Excel00:05:40

48 – Pagelayout Tab Themes and Margins00:11:13

49 – Pagelayout Tab Print Settings00:11:14

50 – Pagelayout Tab 200:07:03

51 – Pagelayout Tab300:11:38

52 – Formula Tab Name Manager00:11:24

53 – Formula Tab Formula Auditing00:09:02

54 – Data Tab Get External Data00:08:08

55 – Data Tab SubTotal00:07:22

56 – Data Tab Solver add ins00:06:28

57 – Reveiw Tab00:09:38

58 – View Tab00:10:34

59 – Macro Recording00:12:12

60 – Create your own Tab00:05:57

61 – Vlookup 1 Intro00:16:38

62 – Vlookup 2 Use of Range Lookup00:13:02

63 – Vlookup 3 Double Vlookup00:08:28

64 – Vlookup 4 Nested Vlookup00:07:46

65 – Vlookup 5 Vlookup Project00:09:24

66 – Vlookup 6- Unique Example of Vlookup00:05:39

67 – CountA and Count Blank Formula00:07:10

68 – Countif Formula00:05:59

69 – Countifs Formula00:11:33

70 – Sumif and Sumifs00:07:22

71 – Averageif and Averageifs00:06:57

72 – Frequency Formula00:07:25

73 – Index and Match00:07:10

74 – Lookup Formula00:05:06

75 – SumProduct , Left and Find formula00:07:13

76 – Right and Find00:05:01

77 – Mid and Find Formula00:05:57

78 – Repeat and Substitute Formula00:04:25

79 – PMT, PV, FV Formula00:10:51

80 – IPMT AND PPMT00:08:34

81- V lookup with Match00:10:20

82 – Text Formulas00:06:46

83 – Date in Quarter00:06:19

84 – Datedif Formula00:06:43

85 – Date Formula00:05:13

86 – Switch Date00:06:31

87 – More Date Formulas00:07:23

88 – Ranking Formula00:05:19

89 – Concatenate and Vlookup00:04:05

90 – Sheet Tips00:06:32

91 – Excel To Powerpoint00:06:14

92 – Change Excel Icon00:06:25

93 – Number to Word00:06:14

94 – Custom Cells Tips00:08:00

95 – Picture Lookup 00:11:27

96 – Picture Game00:08:22

97 – Data Entry form00:04:22

98 – File Menu00:06:06

99 – Excel Settings00:11:00

100 – Short formulas00:11:07

101 – Excel – Database function DGET Formula of Excel00:10:36

102 – Excel – DSUM Formula in Excel00:07:24

103 – Excel – DAVERAGE Formula00:02:41

104 – Excel – DCOUNT, DCOUNTA Formula00:04:11

105 – Excel -DMAX Formula, DMIN Formula, DPRODUCT Formula00:06:10

106 – Excel – Vlookup on Multiple Tables00:06:54

107 – Excel – Offset Formula Introduction00:11:01

108 – Excel – Offset Formula Calculate Sum of Last 6 Days00:09:37

109 – Excel – Offset Formula Real Job Use00:05:21

110 – Excel – Sumifs, Index, Match Real Job Use00:08:24

111 – Excel – Practical use of Isblank and Istext Formula00:04:35

112 – Excel – Counting Words in Excel Interview Question00:08:54

113 – Excel – Build Login in Excel Formula00:05:55

114 – Excel – Create Dynamic List Using Index, Match Formula00:04:07

115 – Excel – Conditional Formatting with Text and Or Formula00:04:33

116 – Excel – Unique Example of Conditional Formatting00:05:53

117 – Excel – Auto Sort data using Countif, Match and Index Formula00:09:02

118 – Excel – Condition Inside Rank using CountIFS Formula00:05:40

119 – Excel – Camera, Autofilter, Form – 3 Hidden Features00:06:55

120 – Excel – Max IF and Min IF Formula using Array00:05:39

121 – Excel – Choose Formula in Excel00:07:14

122 – Excel – Swap range in Excel00:04:18

123 -Excel- Reverse Lookup Using Choose Formula00:05:37

124 – Excel – Reverse Lookup using Match and Index00:06:40

125 – Excel – Find & Vlookup Real Job Query00:09:41

126 – Excel – Vlookup Duplicate Names Issue00:04:09

127 – Excel – Vlookup with Chooze formula and array00:09:09

128 – Excel – Text Join Formula in Excel 201900:05:02

129 – Excel – IFS Formula in Excel 201900:04:47

130 – Excel – MaxIFS and MinIFS in Excel 201900:04:36

131 – Excel – Filter Formula of Office 36500:05:20

132 – Excel – Sort Formula of Office 36500:06:56

133 – Excel – Real Job use of Aggregate Formula in Excel00:10:34

134 – Excel – Xlookup In Office 36500:06:37

135 – Excel – Xlookup In Office 36500:06:42

136 – Excel – Xlooup Work Reverse00:09:47

137 – Excel – Xlooup In Office 36500:05:40

138 – Excel – Xlooup In Office 36500:09:56

139 – Excel – Xlookup in Office 36500:08:38

140 – Excel – Xlookup in Office 36500:06:22

141 – Excel – Xlookup in Office 36500:05:06

142 – Excel – Xlookup in Office 36500:05:36

143 – Excel – Xlookup in Office 36500:05:20

144 – EXCEL – XMATCH Formula office 36500:13:07

145 – Excel – Create Searchable Drop Down List In Office 36500:09:45

146 – Excel – Analyze Data And Get Ideas Office 36500:06:31

147 – Excel – Map Chart In Office 36500:08:04

148 – Excel – Dynamic Conditional Formatting00:09:53

149 – Excel – Unique Formula In Office 36500:05:15

150 – Excel – Sequence And Random Array Formula In Office 36500:04:34

Excel MIS Course 25 Videos

Excel Powerquery Course 25 Videos

Trial Paper and Final Exam for Certificate

Student Ratings & Reviews

5.0

Total 1 Ratings

1 rating

0 rating

Aarti Pawar

1 month ago

I wanted to learn excel in detailed here you offer this course in low price thank you so much I have checked lot of excel courses on internet none of them are advance but this is 50 hours excel course

Key Features

Enrolled:74

Course level:All Levels