LEARN MORE PRO

Excel Mastery Course

SD
by

Satish Dhawale

Excel Mastery Course

May 22, 2021
50h
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

5
1 rating
4
0 rating
3
0 rating
2
0 rating
1
0 rating

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

74
All Levels
50h

Course Curriculum

Topics for this course

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

Course Overview

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

What Will I Learn?

  • 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

Material Includes

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

About Instructor

4.87 (380 ratings)

18 Courses

20508 students

Student Ratings & Reviews

5.0

Total 1 Ratings

5
1 rating
4
0 rating
3
0 rating
2
0 rating
1
0 rating

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