Excel MIS Beginner to Advance

About Course

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.

ये कोर्स उन सभी के लिए है जो एक्सेल में MIS Executive की जॉब करना चाहते है, अपने आपको MIS EXECUTIVE के रूप में देखना चाहते है, जिनको कंपनी में होता लार्ज सैलरी पैकेज जिसमे पाइवोट चार्ट, पाइवोट टेबल, इन्फोग्राफिक चार्ट, लाइन चार्ट, पाय चार्ट, COMPARISON चार्ट ये कवर किये और वो भी डिटेल में एक्सप्लेन किए है, साथ ही में उसकी प्रैक्टिस फाइल की लिंक भी आपको मिलेगी | और इसमें आपको पावर क्वेरी कोर्स भी मिलेगा अलग से पावर क्वेरी कोर्स लोगे तो उसका चार्ज अलग है |

अब तक इस कोर्स के 20 टुटोरिअल्स अपलोड किये प्रैक्टिस फाइल्स के साथ आगे के टुटोरिअल्स जल्द ही अपलोड होंगे | Tutorials List is given Below

अगर आपको Excel का पूरा कोर्स करना है, तो आप इस पे क्लिक करके सिख शकते है |

92% Discount for Next 10 Students Hurry Up !

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

Course Content

Pivot Table and Charts
Detail Explanation of Pivot table

1- Pivot Table Introduction (Watch Free)

17:58
2 – Pivot Table and Pivot Chart (Watch Free)

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

MIS Info-graphics Chart (12 video)

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

Dashboard in Excel (10 video)

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

About Course

What Will You Learn?

Course Content

Pivot Table and Charts Detail Explanation of Pivot table

1- Pivot Table Introduction (Watch Free)

2 – Pivot Table and Pivot Chart (Watch Free)

3 – Design Tab of Pivot Chart

4- Slicer in Pivot Table & Slicer Settings

5 -Time Line in Pivot Table

6 – Get Pivot Data in Excel

MIS Info-graphics Chart (12 video)

7 – Pareto Chart in Excel

8 – INFOGRAPHIC CHART IN EXCEL

9 – Trend Chart using SumIFS Formula

10 – Map Chart using XY Scatter Chart

11- Key Performance Indicator in Excel

12 – Chart with Hyperlink

13 – Chart with Conditional Formatting

14 – Create Bar Charts with Pictures MIS Series

15 – Speedometer Chart in Excel

16 – See Saw Comparison Chart

17 – MIS – Hyperlink with Column and Pie-Chart

18 – MIS – Male, Female Comparison Chart

Dashboard in Excel (10 video)

19 – Excel MIS – Create Dynamic Month Dashboard using Offset Formula

20 – Excel MIS – Create Dashboard on Day Wise Report

21 – Excel MIS – Sales Ranking Dashboard

22 – Excel MIS – Create Weekly Sales Dashboard using Listbox

23- MIS IN EXCEL – Daily Task Reminder Dashboard

24 – MIS IN EXCEL – Create Year wise report using Vlookup, Match, Index

25- MIS IN EXCEL- Create Dasboard Using VLOOKUP, INDEX, COUNTIF

26 – MIS – Amazing Dashboard

27 – MIS – Time Dashboard Project

28 – MIS – Gantt Chart with Conditional Formatting

Trial Paper and Final Exam for Certificate

How will You get Certificate?

Trial Paper For Final Exam

MIS Final Exam

Student Ratings & Reviews

Quick Links

Imp. Links

Weekly Newsletter

Pivot Table and Charts
Detail Explanation of Pivot table