MS EXCEL -AN EFFECTIVE AID IN MIS AND DATA ANALYSIS A CASE STUDY

The article probes into usefulness of Microsoft Excel as an effective aid in MIS and Data Analysis given-the fact that various statistical packages are not readily available or may not be useful owing to different requirements. Simple inbuilt functions of MS Excel and its special features have been explained with the help of a Case Study for better understanding. Exhibits have been appended to demonstrate various steps in Data Analysis. C13llouts have been inserted into Exhibits for easy understanding. This artic e aims at facilitating the micro application of MS Excel in analysis of Ad-hoc Research Projects. It would provide guidelines to officials working in SME Sector and researchers.