Excel Mastery Course.
rating:
Enrolment validity: Lifetime
Login
Course Benefits
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 👩💻 Course Test and 👨🎓 Course Completion ISO Certificate ▶️ Practical Videos of ⌚ 50+ Hours.
👉 अगर आप एक्सेल में MASTER बनाना चाहते हो तो मै आपको ये कोर्स पैकेज सजेस्ट करूँगा एक्सेल मास्टरी कोर्स
Including 3 Excel Courses
👉 Excel Beginners to Advance 150+ Videos
👉 Excel MIS Course 28 Videos
👉 Excel Powerquery Course 27 Videos
Course Benefits
- Excel Beginners to Advance 150+ Videos
- Learn all formulas and Options of excel
- Excel MIS Course 27 Videos
- Create Dashboard, Reports and Charts
- Excel Powerquery Course 27 Videos
- Import and Transform Data
materials include
- 200+ Video Tutorials
- Course Test
- Course Completion ISO Certificate
- Practical Videos of 50+ Hours
course content
Excel Introduction
Excel Beginners to Advance 150+ Videos
5 – Nested IF Formula in Excel10: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
151 – EXCEL – Assignment 1 With Answer 36500:13:17
152 – EXCEL – Assignment 2 With Answer 36500:06:40
153 – EXCEL – Assignment 3 With Answer 36500:04:37
154 – EXCEL – Assignment 4 With Answer 36500:03:14
155 – Excel Interview Questions-100:41:51
156 – Excel Interview Questions-200:26:12
157 – Use your Brain – Interview Question00:35:50
158 – Interview Question – Mode Function00:11:54
159 – Interview Question – Goto and Conditional Formatting00:08:02
Excel MIS Course (28 Videos)
2 – Pivot Table and Pivot Chart00:11:06
3 – Design Tab of Pivot Chart00:12:33
4- Slicer in Pivot Table & Slicer Settings00:15:59
5 -Time Line in Pivot Table00:11:03
6 – Get Pivot Data in Excel00:23:28
7 – Pareto Chart in Excel00:05:56
8 – INFOGRAPHIC CHART IN EXCEL00:13:54
9 – Trend Chart using SumIFS Formula00:20:11
10 – Map Chart using XY Scatter Chart00:23:59
11- Key Performance Indicator in Excel00:13:51
12 – Chart with Hyperlink00:12:32
13 – Chart with Conditional Formatting00:35:23
14 – Create Bar Charts with Pictures MIS Series00:10:02
15 – Speedometer Chart in Excel00:16:42
16 – See Saw Comparison Chart00:17:19
17 – MIS – Hyperlink with Column and Pie-Chart00:14:06
18 – MIS – Male, Female Comparison Chart00:13:05
19 – Excel MIS – Create Dynamic Month Dashboard using Offset Formula00:27:56
20 – Excel MIS – Create Dashboard on Day Wise Report00:12:31
21 – Excel MIS – Sales Ranking Dashboard00:21:40
22 – Excel MIS – Create Weekly Sales Dashboard using Listbox00:18:29
23- MIS IN EXCEL – Daily Task Reminder Dashboard00:22:16
24 – MIS IN EXCEL – Create Year wise report using Vlookup, Match, Index00:14:58
25- MIS IN EXCEL- Create Dasboard Using VLOOKUP, INDEX, COUNTIF00:19:38
26 – MIS – Amazing Dashboard00:14:32
27 – MIS – Time Dashboard Project00:23:37
28 – MIS – Gantt Chart with Conditional Formatting00:10:45
Excel Powerquery Course (27 Videos)
2 – Power Query – Create Connections with Excel Table00:07:20
3 – Power Query – Create Connections with Text file and Access Database00:09:23
4 – Power Query – Reconnect Data in Power Query00:07:14
5 – Power Query – Create Pivot table on Text file data00:07:31
6 – Power Query – Merge Multiple sheets using M Language00:10:40
7 – Power Query – Create Pivot table on Multiple Sheets00:04:27
8 – Power Query – Close and Load to Explain – Home tab – Query Group00:07:32
9 – Power Query – Home Tab – Manage Column and Rows Group00:11:05
10 – Power Query – Home Tab – Split Column into rows and columns00:07:29
11 – Power Query – Home Tab – Group by using Basic and Advance Option00:00:00
12 – Power Query – Home Tab – Data type & Replace Values00:06:05
13 – Power Query – Transform data Dynamically00:08:51
14 – Power Query – Combine 1000+Tables with 1 Function00:07:11
15 – Power Query – Alternate options of Vlookup inside Power query00:07:54
16 – Power Query – Multiple columns lookup00:13:44
17 – Power Query – Remove Weekends and Holidays00:10:27
18 – Power Query – Calculate Age with simple Method00:04:48
19 – Power Query – Calculate Task Timings00:05:00
20 – Power Query – Add Column Date Options in Detail00:09:21
21 – Power Query – Time and Duration Options in Details00:07:42
22 – Power Query – Transform Raw Data – Real Job Query00:11:00
23 – Power Query – Few clicks to get Trim, Propercase and Merge Data00:08:13
24 – Power Query – Merge Workbooks and Create Pivot00:12:03
25 – PowerQuery – Merge Workbooks with File Name as Column00:21:40
26 – PowerQuery – Raw Data to Pivot00:13:07
27 – Power Query – Merge Vs Append00:10:22
Trial Paper and Final Exam for Certificate
Student Ratings & Reviews
4.9
Total 35 Ratings
Jeet Sharma
4 days ago
Satish sir is fantastic. Sir, your funny way teaching is something I will appreciate a lot. I am also a teacher, surely I learnt some skills from you. And the excel part is splendid. Keep up the nice work sir.
Rakesh Raushan
1 month ago
Bahut hi achha explain kiya hai sir ne, kaafi kuchh sikhne ke liye chize hai esme.
Thanks to Learnmore pro team.
Shailabh Srivastava
2 months ago
Nice Course
Sir have explained every topic v well. Best thing is after the course completion validity is there for lifetime. We can watch the videos anytime if we forget any topic. Thank you sir.
Pappu Brahaman
2 months ago
It is very good course, i am thank you for satish sir for hard working
Ajay Thorat
2 months ago
best
Kamaldeep Rajwade
2 months ago
best price best course
Dhananjay Hage
3 months ago
very good teaching style sir...
Sagar Bhagat
3 months ago
Value For Money ! Very Good Course & Recommended.
HIMANSHU KATHAYAT
3 months ago
Great experience...
Sarthak Pingale
4 months ago
Thank sir
Ironman2024
4 months ago
i watched you on you tube first time and from there today I am here.... I love this course
Saurabh Jangir
4 months ago
This is good learning app. please sir add a comment options in every lessons So that any question can ask you.
SUSHANT KUMAR
5 months ago
awesome
Krishna Rajbanshi
5 months ago
It was a very good experience and learned many new things in excel. It is very helpful and complete detail of ms excel, data entry!!
Sudipta Kanrar
5 months ago
very good course.i am happy
Perbez Khan
5 months ago
GREAT INDEPTH LEARNING EXPERIENCE
Jahid110786
5 months ago
Amazing Experience
I am learn in Excel basic to advanced , It is very useful material for other platforms,.
sushma saini
6 months ago
Amazing course
Babya Kondhalkar
6 months ago
The knowledge provides in this course is more than many expensive excel course
Steffi Peter
6 months ago
EXCELLENT COURSE, VERY WELL EXPLAINED.....THANKS, SATISH SIR :)
Ajay Gaikwad
6 months ago
Just कोर्स घेतला आहे , सतीश सरांचा अजून व्हिडीओ बघितले पण नाही तरी एवढ्या करता सांगतेय फक्त की इतक्या कमी पैशात इतका जबरदस्त कोर्स कुठेच मिळाला नसता सर thank you सतीश सर
Chaitanya Karmarkar
6 months ago
Complete Excel course which includes Excel's beginner and advance level material. MIS reports and Power Query. Highly recommended. Thanks Satish Sir.
Sridhar Sutrave
6 months ago
I'm very very happy with this course and also videos on youtube. I have purchased this course on offer. Your course is just like a dictionary where we Just search the word and get the meaning. I'm also a Teacher. Usually student will sleep after few minutes. But because of cracking jokes in between makes me to focus and you taught in very very simple manner. Agar mann lagake padhen gey to zero to hero jaroor banenge. God bless you sir.
Subhashis Das
8 months ago
Its a good course. You have explained it in a very simple language and also gave tips on solving issues. It was fun learning excel :)
Hemant Jadhav
8 months ago
Good course and good teaching methods
MEGHDEEP DHAR
9 months ago
Most Comprehensive MS-EXCEL course , to learn from.
In short, course content is perfect for professionals.
AJAY NAYAK
10 months ago
Excellent Education
Prowader
Amit Yadav
10 months ago
Good job sir
Dipali Bagul
11 months ago
khup bhari course ahe sir ani tumcha shikvan pn khuppch chan ahe thank you sir...........
Nitesh yadav
11 months ago
Very good course
Anurag0107
11 months ago
Good course
Akash Zine
1 year 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