Skill Course By Satish Dhawale

Menu
Login
  • Home
  • Courses
  • Excel MIS & Dashboard Expert Course

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
★★★★★ 5/5
  • 2103 Students Enrolled
  • Created By Satish Dhawale
  • In Hindi
  • 29 Lessons

₹499

₹1999

85% off

Enroll Now
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

Free BONUSES-
✅ 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

  • MIS & Dashboard information
  • Features of MIS & Dashboard
  • 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

Materials Included

  • 25+ Video tutorial
  • 5 Hours on demand lectures
  • Real Job Problem scenario
  • Downloadable Practice file available
  • Course completion ISO certificate
  • WhatsApp and Call Support

Course Curriculum

Excel MIS & Dashboard : Module - 1

Preview

Play Video

01 - Pivot Table Introduction

Preview

Play Video

02 - Pivot Table and Pivot Chart

Preview

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 www.learnmoreindia.in 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

₹499

₹1999

85% off

Enroll Now

Course Rating By Summary

5.0
Rated 5.0 out of 5
5.0 out of 5 stars (based on 9 reviews)
Excellent100%
Very good0%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

​

Khakendra Beeke

Rated 5.0 out of 5
February 9, 2023

Satish sir good teaching.

Khakendra Beeke
Verified

Ramesh Kumar

Rated 5.0 out of 5
February 9, 2023

THANK YOU SO MUCH SIR FOR THIS COURSE.

Ramesh Kumar
Verified

Rahul Shimpi

Rated 5.0 out of 5
February 9, 2023

nice

Rahul Shimpi
Verified

Mahesh Singh

Rated 5.0 out of 5
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
Verified

Saurabh Srivastava

Rated 5.0 out of 5
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
Verified

VIMAL RANGJIBHAI CHAUDHARI

Rated 5.0 out of 5
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.

VIMAL RANGJIBHAI CHAUDHARI
Verified

Praveen Pandey

Rated 5.0 out of 5
February 9, 2023

This is a wonderful course

Praveen Pandey
Verified

Bhavin Goklani

Rated 5.0 out of 5
February 9, 2023

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

Bhavin Goklani
Verified

DEEPAK KUSHWAH

Rated 5.0 out of 5
February 9, 2023

Good Good

DEEPAK KUSHWAH
Verified

Send your doubt

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