Skill Course By Satish Dhawale

Enroll Now On Data Analytics Master Class => Click Here

Excel MIS & Dashboard Expert Course

Excel MIS Reporting and Analysis Training – Complete Data Management with Basic to Expert level MIS Reporting, Data Analysis, Charting, Dashboard and more
4.9 Rating



85% off

Play Video

Course Description

This course is for all those students who want to learn MIS in Excel and pursue a career as MIS EXECUTIVE.

In this course you will learn Excel MIS & Dashboard from Beginners to Advance. (Courses by Satish Dhawale Sir) सभी कोर्सेस आसान हिंदी भाषा में | Read More पे क्लिक करे और कोर्स के फीचर्स जानने के लिए |

Course Features
✅सभी कोर्सेस सरल हिंदी भाषा में
✅Excel MIS & Dashboard बेसिक से एडवांस कोर्सेस
✅25+ DETAIL वीडियोस
✅ कोर्स प्रैक्टिस फाइल्स उपलब्ध
✅कोर्स कम्पलीशन सर्टिफिकेट
✅इंस्टेंट एक्सेस –
⬇️ Download Video in APP

✅ PDF शॉर्टकट्स
✅ MS Excel e-book in हिन्दी

This course is Created by : Satish Dhawale
सतीश सर को कंप्यूटर के क्षेत्र में टीचिंग का लगभग 16 साल का अनुभव हैं जिसमे उन्होंने 14 साल तक ऑफलाइन कंप्यूटर संस्थान में 40000+ से अधिक स्टूडेंट्स को और अपने Online अपने Learn More Channel के माध्यम से लगभग 17,00,000+ से ज्यादा स्टूडेंट्स को कंप्युटर कि शिक्षा देने का कार्य किया हैं। YouTube : 7 Silver and 1 Gold Button Award Winner for their 7 YouTube Channels

Course Benefits

Materials Included

Course Curriculum

Excel MIS & Dashboard : Module - 1


Play Video

01 - Pivot Table Introduction


Play Video

02 - Pivot Table and Pivot Chart


Play Video

03 - Design Tab of Pivot Chart

04 – Slicer in Pivot Table & Slicer Settings 15:59 Min
05 – Time Line in Pivot Table 11:03 Min
06 – Get Pivot Data in Excel 23:28 Min

Excel MIS & Dashboard : Module - 2

01 – Pareto Chart in Excel 05:56 Min
02 – Info Graphic Chart in Excel 13:54 Min
03 – Trend Chart using SumIFS Formula 20:11 Min
04 – Map Chart using XY Scatter Chart 23:59 Min
05 – Key Performance Indicator in Excel 13:51 Min
06 – Chart with Hyperlink 12:32 Min
07 – Chart with Conditional Formatting 35:23 Min
08 – Create Bar Charts with Pictures MIS Series 10:02 Min
09 – Speedometer Chart in Excel 16:42 Min
10 – See Saw Comparison Chart 17:19 Min
11 – Hyperlink with Column and Pie-Chart 14:06 Min
12 – Male, Female Comparison Chart 13:05 Min

Excel MIS & Dashboard : Module - 3

01 – Create Dynamic Month Dashboard using Offset Formula 27:56 Min
02 – Create Dashboard on Day Wise Report 12:31 Min
03 – Sales Ranking Dashboard 21:40 Min
04 – Create Weekly Sales Dashboard using list box 18:29 Min
05 – Daily Task Reminder Dashboard 22:16 Min
06 – Create Year wise report using VLOOKUP, MATCH, INDEX 14:58 Min
07 – Create Dashboard Using VLOOKUP, INDEX, COUNTIF 19:38 Min
08 – Amazing Dashboard 14:32 Min
09 – Time Dashboard Project 23:37 Min
10 – Gantt Chart with Conditional Formatting 10:45 Min

Course Instructor

Satish Dhawale

Founder & CEO of CoursePe

Satish Dhawale has over 15 years of experience in the field of computer education, he has been promoting computer education through his blog and YouTube channel Learn More with 1.5 M+ subscribers for more than 5 years now. 1 Gold Play and 5 Silver Play Awards have been awarded by YouTube. Learn More YouTube channel provides tutorials related to computer and technology in the Hindi language to Learn and improve your life. 

Course Completion Certificate



85% off

Course Rating By Summary

5.0 out of 5 stars (based on 13 reviews)
Very good0%

Submit Your Feedback


July 12, 2024

certificate kab tak valid hai or kitne month ka hai ye course ??

kb tak access hai ??or kya vo bhi date hogi certificate par jam hmne complete kra hai ….ya uske saath jab course start kra tha vo bhi date mention hogi .. mtlb mujhe jab course start kra hai vo date nhi chihye jab test diya hai tab ki date mention ho bas.


Satish sir good teaching.

June 18, 2024

Just Mind-blowing.. Simple Language.. Easy Understanding…


sir ke jaise koi nahi padhata

May 10, 2024

thanks sir itne achhe se clear karne ke liye



May 8, 2024

sir’s teaching skill is very easy, every person can understand, i want to expert in excel. how can join the class.

ajhul pandit

Khakendra Beeke

February 9, 2023

Satish sir good teaching.

Khakendra Beeke

Ramesh Kumar

February 9, 2023


Ramesh Kumar

Rahul Shimpi

February 9, 2023


Rahul Shimpi

Mahesh Singh

February 9, 2023

Excellent learning Platform, Mr. Satish, you are awesome, you are explaining things in such a way that every body can understand. Thanks a lot for you courses at such a affordable prices!!!

Mahesh Singh

Saurabh Srivastava

February 9, 2023

This course is worthwhile. I’ve learnt lots of….Method of teaching is very excellent & interesting even I haven’t felt bore during study. I’ll recommend this course to all who want gain knowledge.

Saurabh Srivastava


February 9, 2023

Dear sir, I learned lots of things from this MIS course. It will help me in daily office work. Great and Interesting teaching techniques. Thanks lot.


Enroll Now On Data Analytics Master Class

For Indian Users

For International Users

Send your doubt

“Please note: You will receive a reply from our team on your email ID within 24 to 48 hours.”