About Workshop
Introduction
MIS (Management Information System) and Analytics are commonly used in most departments in an organization. From Executives to Chairman, everyone uses MIS on day to day basis. Many of us learned some theoretical MIS during university courses. On the contrary, this course is designed for practical applications of MIS and Analytics. Most well-known MIS and Analytics tool, Microsoft Excel 2007/2010 along with MS Access, MS Word and MS PowerPoint have been used for this training.
How participants will benefit after the course:
HANDS ON EXPERIENCES. Most widely practiced MIS & Analytical topics are covered in the course syllabus with practical exercises. Participants will do the live exercises along with the trainer to learn faster and effectively. Learning the widely used MIS techniques in this course will ensure participants high performance in their career.
Methodology
PRACTICAL EXAMPLES, EXCERCISES & CASE STUDIES WITH Q&A DISCUSSION SESSIONS. The course is designed for practical MIS & Analytics applications at participants’ works rather than theoretical notes. Course topics are ordered in real life practices for efficient learning. Participants will go through with many examples that they can relate to their office or educational works.
Workshop topics to be covered:
DAY 1
MIS & Analytics
Overview, Terminology, Types, Advantages, Enterprise applications
Data Import
Text, CSV, Excel, Access
Data Cleanup & Fix
Cleanup Duplicate data, Fix Number, Date & Text Problems
Dynamic Data
Excel Table with nomenclature
Data Analysis
Sort, Filter, Advanced Filter, Pivot Table in depth
Dashboard
Dynamic Management Dashboard, KPI (Key Performance Indicator) Dashboard
Data Lookup & Extracting
Vertical lookup, Horizontal lookup, 2 Way Lookup, Partial & Exact Lookup, Single & Multiple criteria lookup
Data Merge
Merge multiple data list and tables
DAY 2
Data Comparison
Compare multiple data sets
Data Matching
Match data between lists and tables
Data UnMatching
Extract unmatched data between lists and tables
Charts & Graphs
Pie Charts, Column Charts, Bar Charts, Line Charts, Area Charts, X-Y Scatter Charts, Multiple Chart Type
Trend Forecasting
Linear, Exponential, Polynomial, Moving Average
Data Export
Text, CSV, Excel, Access, PowerPoint, PDF
Printing
Page Setup, Print Repetitive Titles, Header/Footer with Page Numbering, Date/Time, File/Sheet Name, Set Print Area & Page Break
Mail Merge
Letter Mail Merge, E-Mail Mail Merge
Templates
Create and save various templates for reuse
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
