Material Includes
- 52 Lessons
- Video Tutorials
- Practice Files
- Course Completion Certificate
- Lifetime Access
Login
Material Includes
- 52 Lessons
- Video Tutorials
- Practice Files
- Course Completion Certificate
- Lifetime Access
Login
Key Features



Course Curriculum
Topics for this course
Pivot Chart & Info-graphics Charts
1- Pivot Table Introduction00:17:58
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:21
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:6
18 – MIS – Male, Female Comparison Chart00:13:5
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
Coming soon
Excel Power Query
2 – Power Query – Create Connections with Excel Table00:7:20
3 – Power Query – Create Connections with Text file and Access Database00:9:23
4 – Power Query – Reconnect Data in Power Query00:7:14
5 – Power Query – Create Pivot table on Text file data00:7:31
6 – Power Query – Merge Multiple sheets using M Language00:10:40
7 – Power Query – Create Pivot table on Multiple Sheets00:4:27
8 – Power Query – Close and Load to Explain – Home tab – Query Group00:7:32
9 – Power Query – Home Tab – Manage Column and Rows Group00:11:5
10 – Power Query – Home Tab – Split Column into rows and columns00:7:31
11 – Power Query – Home Tab – Group by using Basic and Advance Option00:5:55
12 – Power Query – Home Tab – Data type & Replace Values00:6:3
13 – Power Query – Transform data Dynamically00:8:51
14 – Power Query – Combine 1000+Tables with 1 Function00:7:11
15 – Power Query – Alternate options of Vlookup inside Power query00:7:54
16 – Power Query – Multiple columns lookup00:13:43
17 – Power Query – Remove Weekends and Holidays00:10:27
18 – Power Query – Calculate Age with simple Method00:4:48
19 – Power Query – Calculate Task Timings00:5:00
20 – Power Query – Add Column Date Options in Detail00:9:21
21 – Power Query – Time and Duration Options in Details00:7: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
आगे के टुटोरिअल्स जल्द ही अपलोड होंगे
MIS Test
Course Overview
Description
Ye Course 2 Combine Course ka Package hai 94% Discount ke Sath
ये कोर्स उन सभी के लिए है जो एक्सेल में MIS Executive की जॉब करना चाहते है, अपने आपको MIS EXECUTIVE के रूप में देखना चाहते है, जिनको कंपनी में होता लार्ज सैलरी पैकेज जिसमे पाइवोट चार्ट, पाइवोट टेबल, इन्फोग्राफिक चार्ट, लाइन चार्ट, पाय चार्ट, COMPARISON चार्ट ये कवर किये और वो भी डिटेल में एक्सप्लेन किए है, साथ ही में उसकी प्रैक्टिस फाइल की लिंक भी आपको मिलेगी | और इसमें आपको पावर क्वेरी कोर्स भी मिलेगा अलग से पावर क्वेरी कोर्स लोगे तो उसका चार्ज अलग है |
This is the course for those who are looking to become MIS Executive in their office or finding job related MIS Everything I have covered in this complete course including all kind of dashboards and reports
पावर क्वेरी : Power query : will help you to refine raw data, इसका मतलब ये के आपके पास अगर टेक्स्ट फाइल, एक्सेस फाइल या फिर SQL SERVER से डाटा आता है और वो प्रोपर नहीं है तो उसे प्रॉपर करने का काम ये क्वेरी करती है, डाटा को अच्छेस से सॉर्ट फ़िल्टर या फिर क्लीन करके के अच्छे डाटा में कन्वर्ट करना इसमें आपको सीखने मिलेगा | और बहुत सारे MIS REPORT तैयार करने के पहले डाटा को क्लीन एंड नीट करना बहुत जरुरी होता है |
94% Discount for Next 10 Students Hurry Up !
What Will I Learn?
- Create Management Reports
- Create Dashboards on Large Data
- Create Sales Revenue Reports
- Top Sales Reports & Charts
- Pivot Table Slicers and Timeline
- Charts with Hyperlink
- Bar Charts with Pictures
- Create Map Chart
- Speedometer Chart
- Comparison Chart
- Info-graphic Chart
- See-Saw Charts
- Pareto Chart
- Monthly Dashboard Offset Formula
- Power Query - Refine Data
- Create Pivot table on Multiple Sheets
- Create Pivot on Text File
- Transform Data Dynamically
Material Includes
- 52 Lessons
- Video Tutorials
- Practice Files
- Course Completion Certificate
- Lifetime Access
About Instructor
16 Courses
12009 students
Student Ratings & Reviews
5.0
Total 14 Ratings
ROBIN MICHAEL DABRE
3 weeks ago
Thanking you sir and your team for all the efforts to make one of the best courses in the market and that too at very affordable prices.
GURDEEP SINGH
1 month ago
EXCELLENT COURSE
NITESH PATIL
2 months ago
nice course sir, microsoft power bi ka bhi course introduces karo
Mukesh Prajapati
3 months ago
it is very good platform to learn
Bilawal Hameed
3 months ago
Hi Sir,
Salam from Pakistan.
Really really appreciate and will treasure it.
I'm Grateful
Akash Kale
6 months ago
Best course For Excel Mis and power query ever I found on the internet. Thanks a lot sir
Vaibhav Pawar
7 months ago
खूप छान सर खुप छान
आम्हाला घरी बसून तुम्ही एवढे चांगले चांगले आणि स्वस्तात तुम्ही हे कोर्स लॉन्च करत आहेत याबद्दल खूप खूप धन्यवाद हे कोर्स खूप छान आहेत खूप काही नवीन शिकण्यासारखे आहे.
असेच चांगले चांगले कोर्स आमच्यासाठी रेडी करा आम्ही परचेस करायला तयार आहोत. आणि परत एकदा खूप खूप धन्यवाद आम्हाला चांगल्या प्रकारे नीट समजून शिकवण्यासाठी.
Biswa Bhusan Mishra
8 months ago
Sir it is very good platform to learn your course provided in learn more pro ......
I salute it. Jay Hind.....
Ajay Jadhav
8 months ago
I learn useful dashboard and charts thanks for this course
Vikas Singh
8 months ago
अब मुझे पता चला की MIS EXECUTIVE क्या काम करते है और पावर क्वेरी का क्या यूज़ होता है बहुत ही सरल भाषा में आपने ये सिखाया है |
Deepak Sharma
8 months ago
All the best
Ashish Shiriskar
9 months ago
Sir Very Nice way to teaching. Keep Rocking. You and Your Team Hardwork seen in every video. Thanks for sharing knowledge with us...
Md Saddam Hussain Ansari
9 months ago
Sir You are really great man