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

₹299

₹1999

85% off

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

01 - Pivot Table Introduction

Preview

02 - Pivot Table and Pivot Chart

Preview

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

₹299

₹1999

85% off

Course Rating By Summary

5.0

5.0 out of 5 stars (based on 9 reviews)

Excellent100%

Very good0%

Average0%

Poor0%

Terrible0%

Submit Your Feedback

Khakendra Beeke

February 9, 2023

Satish sir good teaching.

Khakendra Beeke

Ramesh Kumar

February 9, 2023

THANK YOU SO MUCH SIR FOR THIS COURSE.

Ramesh Kumar

Rahul Shimpi

February 9, 2023

nice

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

VIMAL RANGJIBHAI CHAUDHARI

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

Praveen Pandey

February 9, 2023

This is a wonderful course

Praveen Pandey

Bhavin Goklani

February 9, 2023

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

Bhavin Goklani

DEEPAK KUSHWAH

February 9, 2023

Good Good

DEEPAK KUSHWAH