4.89
(36 Ratings)

MIS in Excel + Power Query

Wishlist Share
Share Course
Page Link
Share On Social Media

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 तैयार करने के पहले डाटा को क्लीन एंड नीट करना बहुत जरुरी होता है |

 

 

 

 

Show More

What Will You Learn?

  • 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)

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

FINAL EXAM

Student Ratings & Reviews

4.9
Total 36 Ratings
5
32 Ratings
4
4 Ratings
3
0 Rating
2
0 Rating
1
0 Rating
TK
1 month ago
delicious and complete course
MP
3 months ago
Off course Courses are decent.
RS
3 months ago
Good
NF
4 months ago
Nice course and course content.
AK
4 months ago
ok
P
5 months ago
such a class all video kindly request you to provide the dashboard video (25 to 30 different data video)
PD
6 months ago
Great teacher. Best platform to learn computer
DT
10 months ago
Sir please SAP FICO par video banaiye
Dear sir,
power query will help me to analyze data. Thank you so much for this course.
KK
12 months ago
I am speechless to tell anything about this course, I have learnt MIS and Power Query first time through this course, I learn first time in my life about MIS and how to present in excel,
Thanks a million to Satish Sir and their team for this valuable course,
I personally suggest that this course should be updated time to time with new ideas and project .

I personally thanks to Satish Sir , because I have learnt so many things about excel through their video
DK
1 year ago
Good
NP
1 year ago
Ek dam best Course Banvla ahe sir Fkt Data khup challi geli online bagun bagun.. Offline course banva sir ny tr youtube sarkh download option dya download houn jail pn konalahi sent ny honar m.g tumch pn ky loss nahi ani jastit jast student course purchase krnar
DS
1 year ago
YOUR TEACHING STYLE IS THE BEST TEACHING STYLE.AAP PCS KI PREAPARATION BHI KARAOGE TO MUJHE LAGTA HAI MAI PCS BHI NIKAL DUNGA
P
1 year ago
Best course
SK
1 year ago
Very informative.
SA
1 year ago
Mind-blowing!! The way of teaching is so simple that you will be able to understand each and every concept very easily. Real-life example were shared which help me to understand the practical use of the above course. Thanks a lot Satish Sir!!!
Excellent dear
AR
1 year ago
Main sbko recommend krta hun ye course value for money hain worth it bhi hain jarrror join kare plz
AM
1 year ago
सगळे कोर्स एक नंबर, कड़क ,धन्यवाद
ST
2 years ago
Excellent course, learn new things in misreport, Explain in each & every point detail to understandnQuick Query Solver To understand concepts in detail.