Excel MIS

Management Information using Excel

MI via Excel can turn ordinary spreadsheets into a flexible, powerful, and inexpensive MI system based on the software you already own. An Excel system can be as agile as you need it to be, and it will scale to integrate with your existing accounting software as well.

We explore various tips and Tutorials below:

Using the Auto Filter

Counting Words

Advanced uses for the Sumproduct Formula

Pivot Tables