What is MIS? How Management Information System helpful for an organization?

This article is all about Management Information System (MIS) that helps an organization to determine the products flow by using various statistics that gives result which helps an organization to improve on their production either to increase or decrease based on the data received and follow up via MS-Excel using Pivot table, VLook up and HLook up along with chart etc. it will explain you how to become MIS executive and how to be expert in MS-Excel using Pivot table, VLook up and HLook up etc.

Management Information System

Management Information System is nothing but it is a collective data of a particular product or group of products and their flow on the market. A particular product can be handled by many sales executive on the market to various sellers and MIS helps to track each sales executive's report and each sellers target achieved by their sales performance on set deadline.

Management Information System must have some data to follow up and it should have some technology helps which can help to audit and clear the statistics or numeric count and comparison.

How MIS (Management Information System) handled?

Once data collected from various source of organization operation, MIS executive then proceed based on the overall data received and it is handling via MS-Excel using three different operations such as using Pivot table, VLook up and HLook up along with chart etc. to determine the result of the product flow. Once they get the data and statistics results of the each product or each executive, they then forward it to management for further decision on each product where it has affected or improved, they can easily find out the positive and negative of the overall production cycle of each product by using this method including executive's performance and profit.

How MIS helps an organization?

Most of the production companies including Telecom companies uses this MIS method to determine where they lose or gain the profit either from the production or end users. These statistic via MIS helps a lot to each organization for further improving on their product business or further improve on their investment to gain later, Management Information System not only helps to show off the overall result of the past but it helps for the present and future of their cycle.

About MIS using MS-Excel Pivot table, VLook up and HLook up along with chart etc.

MS-Excel is one of the best and friendly calculation software packages that helps many; MS-Excel has an advanced options to be used by various users but advance option like Pivot table etc. using only the relevant professional and not all.

The above mentioned (MS-Excel Pivot table, VLook up and HLook up) calculation helps a lot to business professional by having MIS executives who handle them in a professional manner to track each product performance individually by using MS-Excel Pivot table, VLook up and HLook up along with chart etc. it has unique formula and multi sheets in the same worksheet where you can get all the detail pertaining to particular product with multi executives performances along with variation of each product with each executive's performance output shown. All are automatically calculated by its own formula and MIS executive just have to handle or design it properly per organization requirement.

Please note: If you would like to know more or to be expert in MS-Excel Pivot table, VLook up and HLook up then please visit the help key facility by pressing F1 in excel that will guide you step by step showing example for Pivot table, VLook up and HLook up formulas.

Article by Hafeezur Rahman
Hafeezur Rahman has joined ISC in 2009 and he is a Job Editor at ISC since 2010, he also a Blogger. Hafeez continue to contribute in various sections of ISC and its sister sites like Techulator, NewRecruitments & Goaspider etc. He is a renowned feature writer & social enthusiast. He loves to write in a simple manner and share his visionary write-ups with the readers on the topics related to his field of interests and different niche. All his write-ups have been popularly read & shared by global readers.

Follow Hafeezur Rahman or read 534 articles authored by Hafeezur Rahman

Related Articles

Evolution Of Management Infomation System

This article is about the management information system. Management information system is the combination of information systems which generate informations useful for managers in planning and control. Management information system is evolved from information system and management science.

What Is The Meaning Of Mis (Management Information System) And Reporting?

Decision making at the correct time is the main problem for the success of every organisation. MIS can helps the management in taking decision and thereby make the managerial functions smooth and . In this article I would like to say about the elements and types of MIS, installation of MIS in an organisation and meaning and objects of reports, methods of report, requirements of a good report, general principles of a good reporting system, kinds of reports and process of report writing.

Durgadevi Saraf Institute Management Programs Admissions For Working Executives

This article gives information on the Master's management degree courses for working executives offered by the Durgadevi Saraf Institute of Management Studies (DSIMS), Mumbai for the 2012-2015 session. You will get details about the course structure, , eligibility criteria, fees and apply for admissions to these programs.

Career Option In Event Management

In this article on career guidance to aspirants candidates I have discussed briefly about the most glamorous and hot job opportunities in Event Management Company. This new type of job will not only give satisfaction but also have career prospect and lucrative pay package.

More articles: Management information system Management Management


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: