4.87
(63 Ratings)
Excel Mastery Course.
About Course
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
What Will You Learn?
- 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
Course Content
Excel Introduction
-
1 – Excel Introduction (Watch Free)
13:55
Excel Beginners to Advance 150+ Videos
Excel Course Basic to Advance for Everyone Including All Formulas and Excel Options
-
2 – Basic Formula in Excel (Watch Free)
20:14 -
3 – If Formula in Excel (Watch Free)
18:13 -
4 – If and If or Formula (Watch Free)
09:02 -
5 – Nested IF Formula in Excel
10:30 -
6 – Nested if Calculate Discount
14:51 -
7 – Salary Sheet Basic Formula
13:08 -
8 – Salary Sheet Nested if
15:32 -
9 – Attendance Sheet
14:02 -
10 – Attendacne Sheet Countif Formula
12:06 -
11 – Sort, Custom Sort & Filter
17:41 -
12 – Conditional Formatting Basic
13:23 -
13- Conditional Formatting Advance
10:16 -
14- C F Higlight Alt Rows
08:38 -
15 – Advance Filter
12:26 -
16 – Advance filter Macro
14:00 -
17 – Auto Sort Macro
07:39 -
18 – Text to Columns
05:00 -
19 – Flash Fill in Excel
13:30 -
20 – Remove Duplicate and Consolidate
08:40 -
21 – 3D Formula
07:15 -
22 – Data Validation
28:16 -
23 – Scenario Manager
06:21 -
24- Goal Seek
08:51 -
25 – Data Table
05:31 -
26 – Home Tab 1
12:24 -
27 – Home Tab 2
11:10 -
28 – Home Tab 3
06:32 -
29 – Home Tab 4
09:53 -
30 – Find and Replace
12:40 -
31 – Goto Special
20:14 -
32 – Paste Special
17:32 -
33 – Pivot Table Introduction
13:28 -
34 – Pivot Table Filter Use
08:23 -
35 – Pivot Table Options
11:42 -
36 – Slicer and Timeline
15:10 -
37 – Pivot Chart in Excel
10:56 -
38 – Auto Refresh Pivot Table
06:21 -
39 – Table in Excel
10:56 -
40 – Insert Tab – 1
08:41 -
41 – Insert Tab2
08:05 -
42 – Excel Chart
12:21 -
43 – Excel Chart and Formatting
08:16 -
44 – Excel Sparkline Chart
05:30 -
45 – Hyperlink in Excel
04:32 -
46 – Insert Tab 3
11:58 -
47 – Watermark in Excel
05:40 -
48 – Pagelayout Tab Themes and Margins
11:13 -
49 – Pagelayout Tab Print Settings
11:14 -
50 – Pagelayout Tab 2
07:03 -
51 – Pagelayout Tab3
11:38 -
52 – Formula Tab Name Manager
11:24 -
53 – Formula Tab Formula Auditing
09:02 -
54 – Data Tab Get External Data
08:08 -
55 – Data Tab SubTotal
07:22 -
56 – Data Tab Solver add ins
06:28 -
57 – Reveiw Tab
09:38 -
58 – View Tab
10:34 -
59 – Macro Recording
12:12 -
60 – Create your own Tab
05:57 -
61 – Vlookup 1 Intro
16:38 -
62 – Vlookup 2 Use of Range Lookup
13:02 -
63 – Vlookup 3 Double Vlookup
08:28 -
64 – Vlookup 4 Nested Vlookup
07:46 -
65 – Vlookup 5 Vlookup Project
09:24 -
66 – Vlookup 6- Unique Example of Vlookup
05:39 -
67 – CountA and Count Blank Formula
07:10 -
68 – Countif Formula
05:59 -
69 – Countifs Formula
11:33 -
70 – Sumif and Sumifs
07:22 -
71 – Averageif and Averageifs
06:57 -
72 – Frequency Formula
07:25 -
73 – Index and Match
07:10 -
74 – Lookup Formula
05:06 -
75 – SumProduct , Left and Find formula
07:13 -
76 – Right and Find
05:01 -
77 – Mid and Find Formula
05:57 -
78 – Repeat and Substitute Formula
04:25 -
79 – PMT, PV, FV Formula
10:51 -
80 – IPMT AND PPMT
08:34 -
81- V lookup with Match
10:20 -
82 – Text Formulas
06:46 -
83 – Date in Quarter
06:19 -
84 – Datedif Formula
06:43 -
85 – Date Formula
05:13 -
86 – Switch Date
06:31 -
87 – More Date Formulas
07:23 -
88 – Ranking Formula
05:19 -
89 – Concatenate and Vlookup
04:05 -
90 – Sheet Tips
06:32 -
91 – Excel To Powerpoint
06:14 -
92 – Change Excel Icon
06:25 -
93 – Number to Word
06:14 -
94 – Custom Cells Tips
08:00 -
95 – Picture Lookup
11:27 -
96 – Picture Game
08:22 -
97 – Data Entry form
04:22 -
98 – File Menu
06:06 -
99 – Excel Settings
11:00 -
100 – Short formulas
11:07 -
101 – Excel – Database function DGET Formula of Excel
10:36 -
102 – Excel – DSUM Formula in Excel
07:24 -
103 – Excel – DAVERAGE Formula
02:41 -
104 – Excel – DCOUNT, DCOUNTA Formula
04:11 -
105 – Excel -DMAX Formula, DMIN Formula, DPRODUCT Formula
06:10 -
106 – Excel – Vlookup on Multiple Tables
06:54 -
107 – Excel – Offset Formula Introduction
11:01 -
108 – Excel – Offset Formula Calculate Sum of Last 6 Days
09:37 -
109 – Excel – Offset Formula Real Job Use
05:21 -
110 – Excel – Sumifs, Index, Match Real Job Use
08:24 -
111 – Excel – Practical use of Isblank and Istext Formula
04:35 -
112 – Excel – Counting Words in Excel Interview Question
08:54 -
113 – Excel – Build Login in Excel Formula
05:55 -
114 – Excel – Create Dynamic List Using Index, Match Formula
04:07 -
115 – Excel – Conditional Formatting with Text and Or Formula
04:33 -
116 – Excel – Unique Example of Conditional Formatting
05:53 -
117 – Excel – Auto Sort data using Countif, Match and Index Formula
09:02 -
118 – Excel – Condition Inside Rank using CountIFS Formula
05:40 -
119 – Excel – Camera, Autofilter, Form – 3 Hidden Features
06:55 -
120 – Excel – Max IF and Min IF Formula using Array
05:39 -
121 – Excel – Choose Formula in Excel
07:14 -
122 – Excel – Swap range in Excel
04:18 -
123 -Excel- Reverse Lookup Using Choose Formula
05:37 -
124 – Excel – Reverse Lookup using Match and Index
06:40 -
125 – Excel – Find & Vlookup Real Job Query
09:41 -
126 – Excel – Vlookup Duplicate Names Issue
04:09 -
127 – Excel – Vlookup with Chooze formula and array
09:09 -
128 – Excel – Text Join Formula in Excel 2019
05:02 -
129 – Excel – IFS Formula in Excel 2019
04:47 -
130 – Excel – MaxIFS and MinIFS in Excel 2019
04:36 -
131 – Excel – Filter Formula of Office 365
05:20 -
132 – Excel – Sort Formula of Office 365
06:56 -
133 – Excel – Real Job use of Aggregate Formula in Excel
10:34 -
134 – Excel – Xlookup In Office 365
06:37 -
135 – Excel – Xlookup In Office 365
06:42 -
136 – Excel – Xlooup Work Reverse
09:47 -
137 – Excel – Xlooup In Office 365
05:40 -
138 – Excel – Xlooup In Office 365
09:56 -
139 – Excel – Xlookup in Office 365
08:38 -
140 – Excel – Xlookup in Office 365
06:22 -
141 – Excel – Xlookup in Office 365
05:06 -
142 – Excel – Xlookup in Office 365
05:36 -
143 – Excel – Xlookup in Office 365
05:20 -
144 – EXCEL – XMATCH Formula office 365
13:07 -
145 – Excel – Create Searchable Drop Down List In Office 365
09:45 -
146 – Excel – Analyze Data And Get Ideas Office 365
06:31 -
147 – Excel – Map Chart In Office 365
08:04 -
148 – Excel – Dynamic Conditional Formatting
09:53 -
149 – Excel – Unique Formula In Office 365
05:15 -
150 – Excel – Sequence And Random Array Formula In Office 365
04:34 -
151 – EXCEL – Assignment 1 With Answer 365
13:17 -
152 – EXCEL – Assignment 2 With Answer 365
06:40 -
153 – EXCEL – Assignment 3 With Answer 365
04:37 -
154 – EXCEL – Assignment 4 With Answer 365
03:14 -
155 – Excel Interview Questions-1
41:51 -
156 – Excel Interview Questions-2
26:12 -
157 – Use your Brain – Interview Question
35:50 -
158 – Interview Question – Mode Function
11:54 -
159 – Interview Question – Goto and Conditional Formatting
08:02
Excel MIS Course (28 Videos)
Learn Create Dashboard, Create Reports and Charts in Advance level
-
1- Pivot Table Introduction
17:58 -
2 – Pivot Table and Pivot Chart
11:06 -
3 – Design Tab of Pivot Chart
12:33 -
4- Slicer in Pivot Table & Slicer Settings
15:59 -
5 -Time Line in Pivot Table
11:03 -
6 – Get Pivot Data in Excel
23:28 -
7 – Pareto Chart in Excel
05:56 -
8 – INFOGRAPHIC CHART IN EXCEL
13:54 -
9 – Trend Chart using SumIFS Formula
20:11 -
10 – Map Chart using XY Scatter Chart
23:59 -
11- Key Performance Indicator in Excel
13:51 -
12 – Chart with Hyperlink
12:32 -
13 – Chart with Conditional Formatting
35:23 -
14 – Create Bar Charts with Pictures MIS Series
10:02 -
15 – Speedometer Chart in Excel
16:42 -
16 – See Saw Comparison Chart
17:19 -
17 – MIS – Hyperlink with Column and Pie-Chart
14:06 -
18 – MIS – Male, Female Comparison Chart
13:05 -
19 – Excel MIS – Create Dynamic Month Dashboard using Offset Formula
27:56 -
20 – Excel MIS – Create Dashboard on Day Wise Report
12:31 -
21 – Excel MIS – Sales Ranking Dashboard
21:40 -
22 – Excel MIS – Create Weekly Sales Dashboard using Listbox
18:29 -
23- MIS IN EXCEL – Daily Task Reminder Dashboard
22:16 -
24 – MIS IN EXCEL – Create Year wise report using Vlookup, Match, Index
14:58 -
25- MIS IN EXCEL- Create Dasboard Using VLOOKUP, INDEX, COUNTIF
19:38 -
26 – MIS – Amazing Dashboard
14:32 -
27 – MIS – Time Dashboard Project
23:37 -
28 – MIS – Gantt Chart with Conditional Formatting
10:45
Excel Powerquery Course (27 Videos)
Powerful tool of excel to Import data and transform data
-
1 – Power Query – Introduction and Installation
06:43 -
2 – Power Query – Create Connections with Excel Table
07:20 -
3 – Power Query – Create Connections with Text file and Access Database
09:23 -
4 – Power Query – Reconnect Data in Power Query
07:14 -
5 – Power Query – Create Pivot table on Text file data
07:31 -
6 – Power Query – Merge Multiple sheets using M Language
10:40 -
7 – Power Query – Create Pivot table on Multiple Sheets
04:27 -
8 – Power Query – Close and Load to Explain – Home tab – Query Group
07:32 -
9 – Power Query – Home Tab – Manage Column and Rows Group
11:05 -
10 – Power Query – Home Tab – Split Column into rows and columns
07:29 -
11 – Power Query – Home Tab – Group by using Basic and Advance Option
00:00 -
12 – Power Query – Home Tab – Data type & Replace Values
06:05 -
13 – Power Query – Transform data Dynamically
08:51 -
14 – Power Query – Combine 1000+Tables with 1 Function
07:11 -
15 – Power Query – Alternate options of Vlookup inside Power query
07:54 -
16 – Power Query – Multiple columns lookup
13:44 -
17 – Power Query – Remove Weekends and Holidays
10:27 -
18 – Power Query – Calculate Age with simple Method
04:48 -
19 – Power Query – Calculate Task Timings
05:00 -
20 – Power Query – Add Column Date Options in Detail
09:21 -
21 – Power Query – Time and Duration Options in Details
07:42 -
22 – Power Query – Transform Raw Data – Real Job Query
11:00 -
23 – Power Query – Few clicks to get Trim, Propercase and Merge Data
08:13 -
24 – Power Query – Merge Workbooks and Create Pivot
12:03 -
25 – PowerQuery – Merge Workbooks with File Name as Column
21:40 -
26 – PowerQuery – Raw Data to Pivot
13:07 -
27 – Power Query – Merge Vs Append
10:22
Trial Paper and Final Exam for Certificate
-
How will You get Certificate?
04:13 -
Trial Paper
-
Final Exam for Certificate
Student Ratings & Reviews
4.9
Total 63 Ratings
5
56 Ratings
4
6 Ratings
3
1 Rating
2
0 Rating
1
0 Rating
Excellent course.
Great Sir! Great teaching style, wonderful website, my dad suggested me, Thanks a lot... Sir...!
Good Course very useful for excel learning.
Very good course I learned a lot about excel
how great are you I cant even imagine it is above my imagination.
nice
Satish Sir is an Excellent teacher.
I enjoy this course
Course looks good
I found the best Excel course online and too at an affordable price. Thank you! Satish sir for the wonderful course with the ISO certificate.
I suggest you explain the topic as a new to excel, sometimes I found it difficult to understand the topic.
I suggest you explain the topic as a new to excel, sometimes I found it difficult to understand the topic.
excellent and great teaching and the course was really beneficial ..THank you sir for this excellent course
Thanks you sir ji for nominal price me itna powerful content available karaya hai but sir ji ek request hai aap se power query me join's ko achche se samjh me nhi aaya please ek chapter add kre thanks sir ji Love Learning
one of the best online learning plateform
Confidence vadhla sir thank you
VERY HELPFUL
It's Amazing Course!
Good
Thank you sir , your's teaching style and skills very interesting. Every topic explain so detail
Very very very good
very nice course thank you so much sir