Reporting and analytics
MIS Reporting includes Dashboards making, Creating Reports, Creating Graphs & Charts and Adding Meaningful Statistics to the reports
Pivot Table & Charts in Excel
Pivot Tables allow you to tabulate and report on data in your spreadsheets in ways that would take hours to achieve without using a Pivot Table.
Advanced filter, Array Functions in excel
When you use the Advanced Filter, you need to enter the criteria on the worksheet. Create a Criteria range (blue border below for illustration only) above your data set. Use the same column headers. Be sure there's at least one blank row between your Criteria range and data set.
Dashboard in Excel, Lookup Functions
Using Doughnut, Gantt, Pie and Bar Charts, You can get a quick, visual status update on your projects. Various Lookups VLookup, Index Match Indirect and Offset are popular functions in Excel