MIS in Excel + Power Query

About Course

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 !

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

Course Content

Pivot Table Introduction

1- Pivot Table Introduction

17:58

Pivot Chart & Info-graphics Charts (27 video)

2 – Pivot Table and Pivot Chart

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
7 – Pareto Chart in Excel

05:56
8 – INFOGRAPHIC CHART IN EXCEL

13:54
9 – Trend Chart using SumIFS Formula

20:21
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
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

Excel Power Query (27 video)
Filter and Refine your data in smart way

1 – Power Query – Introduction and Installation

06:42
2 – Power Query – Create Connections with Excel Table

07:20
3 – Power Query – Create Connections with Text file and Access Database

09:23
4 – Power Query – Reconnect Data in Power Query

07:14
5 – Power Query – Create Pivot table on Text file data

07:31
6 – Power Query – Merge Multiple sheets using M Language

10:40
7 – Power Query – Create Pivot table on Multiple Sheets

04:27
8 – Power Query – Close and Load to Explain – Home tab – Query Group

07:32
9 – Power Query – Home Tab – Manage Column and Rows Group

11:05
10 – Power Query – Home Tab – Split Column into rows and columns

07:31
11 – Power Query – Home Tab – Group by using Basic and Advance Option

05:55
12 – Power Query – Home Tab – Data type & Replace Values

06:03
13 – Power Query – Transform data Dynamically

08:51
14 – Power Query – Combine 1000+Tables with 1 Function

07:11
15 – Power Query – Alternate options of Vlookup inside Power query

07:54
16 – Power Query – Multiple columns lookup

13:43
17 – Power Query – Remove Weekends and Holidays

10:27
18 – Power Query – Calculate Age with simple Method

04:48
19 – Power Query – Calculate Task Timings

05:00
20 – Power Query – Add Column Date Options in Detail

09:21
21 – Power Query – Time and Duration Options in Details

07:42
22 – Power Query – Transform Raw Data – Real Job Query

11:00
23 – Power Query – Few clicks to get Trim, Propercase and Merge Data

08:13
24 – Power Query – Merge Workbooks and Create Pivot

12:03
25 – PowerQuery – Merge Workbooks with File Name as Column

21:40
26 – PowerQuery – Raw Data to Pivot

13:07
27 – Power Query – Merge Vs Append

10:22

About Course

What Will You Learn?

Course Content

Pivot Table Introduction

1- Pivot Table Introduction

Pivot Chart & Info-graphics Charts (27 video)

2 – Pivot Table and Pivot Chart

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

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

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

Excel Power Query (27 video) Filter and Refine your data in smart way

1 – Power Query – Introduction and Installation

2 – Power Query – Create Connections with Excel Table

3 – Power Query – Create Connections with Text file and Access Database

4 – Power Query – Reconnect Data in Power Query

5 – Power Query – Create Pivot table on Text file data

6 – Power Query – Merge Multiple sheets using M Language

7 – Power Query – Create Pivot table on Multiple Sheets

8 – Power Query – Close and Load to Explain – Home tab – Query Group

9 – Power Query – Home Tab – Manage Column and Rows Group

10 – Power Query – Home Tab – Split Column into rows and columns

11 – Power Query – Home Tab – Group by using Basic and Advance Option

12 – Power Query – Home Tab – Data type & Replace Values

13 – Power Query – Transform data Dynamically

14 – Power Query – Combine 1000+Tables with 1 Function

15 – Power Query – Alternate options of Vlookup inside Power query

16 – Power Query – Multiple columns lookup

17 – Power Query – Remove Weekends and Holidays

18 – Power Query – Calculate Age with simple Method

19 – Power Query – Calculate Task Timings

20 – Power Query – Add Column Date Options in Detail

21 – Power Query – Time and Duration Options in Details

22 – Power Query – Transform Raw Data – Real Job Query

23 – Power Query – Few clicks to get Trim, Propercase and Merge Data

24 – Power Query – Merge Workbooks and Create Pivot

25 – PowerQuery – Merge Workbooks with File Name as Column

26 – PowerQuery – Raw Data to Pivot

27 – Power Query – Merge Vs Append

FINAL EXAM

How will You get Certificate?

TRIAL PEPER FOR FINAL EXAM

MIS + POWER QUERY FINAL EXAM

Student Ratings & Reviews

Quick Links

Imp. Links

Weekly Newsletter

Excel Power Query (27 video)
Filter and Refine your data in smart way