A Management Information System (MIS) provides organization with the information they require in an organized manner to take upon management and crucial decisions. MIS tools and knowledge is very important nowadays. There is a very high demand for MIS Professionals in the market and the manpower supply of it is very less because of the obvious reason that the skill-sets required is not a part of any academic curriculum. A professional training in it hence becomes mandatory.
This training will endow every student with the skill sets required to be a successful MIS professional. Our course curriculum comprises of all the important aspects requires in the real world to get the job done in MIS. The student will get the enhance knowledge in Data management, Reporting and Analysis through MS Excel, MS Access & RDBMS. Moreover training will be given on the most demanding technology, which is MACRO – Automation.
MIS training course involves “Learning by Doing” using state of the art projects for performing hands on exercises and real world simulations. This extensive hands on experience in MIS training ensures that you absorb the knowledge and skills that you will need to apply at work.
So, what are you waiting for, enroll now and take the next step in mastering MIS.
Title Bar, Tabs, Ribbons, Workbooks, Worksheets, Range etc
Customizing Ribbons and options
How to use operators in Excel to do equation
BODMAS in EXCEL
How to apply functions
SUM()
AVERAGE()
COUNT, COUNTA, COUNTBLANK
MAX, MIN
LARGE, SMALL
Nested Function
Data Validation Types
Input Message
Error Alert Customization
Introduction to Text Function
UPPER()
LOWER()
PROPER()
TRIM()
Nesting TRIM with other Function
LEFT()
RIGHT()
FIND()
Advance FIND()
Nesting FIND with RIGHT() & LEFT()
MID Function
Nested MID
CONCATENATE()
Nesting CONCATENATE with other Text Function.
REPLACE()
Nested REPLACE()
SUBSTITUTE()
REPT()
LEN()
Nested Function
How to use Text to Column
Delimited & Fixed Width
Date Format through Text to Column
Logical Test
Introduction to If Function
Nested If Examples
Nesting IF() with other Functions to get desired output
AND() Function
OR() Function
Nested IF() with AND() & OR()
Advance Examples
SUMIF()
COUNTIF()
AVERAGEIF()
SUMIFS()
COUNTIFS()
AVERAGEIFS()
Wild Card
How to create EMI Calculator
Apply PMT() Function
How to create data table
How to format data table
How to apply Goal seek
Get the desired output from complicated equation through Goal Seek
How to Apply Scenario Manager
How to merge Scenario
how to get summary
VLOOKUP()
HLOOKUP()
MATCH()
INDEX()
Nesting both to get desired result
OFFSET()
Nesting Offset and more example
How to use VLOOKUP() TRUE option
LOOKUP()
Drawbacks and how to apply it correctly
How to apply VLOOKUP() in all columns in a single go
Array VLOOKUP()
VLOOKUP() with IFERROR
VLOOKUP with IF
Nested Lookup Function
Advance Level Examples and problem solving
How to apply conditional formatting
Types of Conditional Formatting
How to Manage Rules - Edit & Delete
How to apply new Rules - Based on Formulas
Advance Customize options
Start with Excel Chart
Understanding Layout options
Chart Format
Chart Design
Handling Axis and Series
Handling Data Series and Legends
Customize options
How to create Pivot Table
Managing Fields Properly in Field area
Managing Value setting
How to get detailed report
Managing Field List, Buttons & Field Headers
Refresh Options
Designing Pivot Table
Pivot Table layout
Changing Source Data
Managing Slicer
Pivot Chart
Multiple Pivot Table
Handling Dates and Values through Group option
Doing Calculation through Calculated field.
How to protect workbook
how and when you may use this option
How to Protect sheet
how to allow cells for changes
How to hide formulas
How to customize protect related options
Making workbook password protected
How to enable share workbook option
how and when to use it
What are the common date entry mistakes?
How to overcome System Date format impact?
Date Format
Time Format
Adding Date and Time
DAY(), MONTH(), YEAR()
HOUR(), MINUTE(), SECOND()
DATE(), TIME()
Nesting Methodology
1904 Format Mystery
Date Format Mystery
How to find age
NETWORKDAYS()
How to correct wrong date entry
Google 
Facebook