A management information system (MIS) is a computer system consisting of hardware and software that serve as the backbone of these operations. The major function of MIS is to gather information from multiple systems, soon after gathering the information, then it analyses the information and reports the data which eventually assist in decision making. 

MIS can be simplified as a collection of systems, hardware, procedures and people. All these segments work together to store, process and produce information that is useful to the organisation. 

Why do need MIS?

Following are reasons behind why MIS is essential for the career:

  1. Credible information is demanded to make rightful decisions and MIS assist to make this happen. 
  2. Facilitate internal and external communication in and outside of the organisation, employees within the organisation is able to access the required information for the day to day operations. MIS also creates short messages and email services offered to communicate to the customers and suppliers from within. 
  3. Recordkeeping, MIS also aid in keeping the record of all the business transactions of an organisation so that they can use it as a reference for the transactions. 

Components of MIS

For typical management information systems following are the major components:

  • People – people who use the information system
  • Data – the data that the information system records
  • Business Procedures – procedures put in place on how to record, store and analyze data
  • Hardware – these include servers, workstations, networking equipment, printers, etc.
  • Software – these are programs used to handle the data. These include programs such as spreadsheet programs, database software, etc.
  • Call us +91 99907 48956 | 96503 08956

  • info@analyticstraininghub.com

Enroll Now
  • Course Fees:- 26000/- 21000/- (INR)

  • Duration :- 50 Hours | 25 Classes + Assigments Hours

  • Tools:- Basic2Advanced Excel, VBA, SQL, Excel Dashboard

  • Learning Mode:- Classroom & Online Training

  • Batch Starting:- Saturday, 31st August’2019

Course Outline

Getting Started with Excel

  • Introduction to Excel 2013/2016/2019/Office 365
  • Application Interface and Key Components of Excel
  • Navigating Through Excel Ribbon Tabs
  • Exploring Important Excel Options*
  • Live Session Exercise
  • Splitting data of Single Column into multiple
  • 10 Examples to use Auto-fill and Flash Fill
  • Magics of Go-To Special
  • Merge/Unmerge Cells & Wrap Text
  • Extracting Unique Values & Important Ribbon, General and Data Entry Keyboard Shortcuts

Formatting Essentials

  • Formatting Essentials Introduction
  • Custom Cell Number Formats
  • Custom Date/Time Formats
  • Working with Comments / Notes
  • Format Painter – A Quick way to copy ‘Formatting Attribute’
  • Paste Special
  • Table, Table Styles & Formatting
  • Freeze Panes

Functions & Formulas

  • Introduction to Excel Functions and Formulas
  • Basics of Functions & Formulas
  • Working with Cell References Types
  • Most Used Basics & Advanced Functions & Formulas
  • Working with Array Formulas
  • Creating Customize Formulas Step-by-Step with Live examples
  • Creating and Working with Dynamic Ranges using Function and Excel Table features
  • Formulas Debugging / Formulas Auditing
  • Types of Formula Errors / Error Handling Tricks
  • Text Functions: – CLEAN, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, and TEXT etc.
  • Date & Time Functions: – DATE, DAYS, TIME, NOW, WEEKNUM, WORKDAY, and WORKDAY.INTL etc.
  • Math & Trig Functions: – INT, MOD, ROUND, ROUNDDOWN, SUMIF, SUMIFS, SUMPRODUCT etc.
  • Statistical Functions: – AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN, LARGE etc.
  • Logical Functions: – IF, IFS, AND, OR, and IFERROR.
  • Lookup & Reference Functions: – FORMULATEXT, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, and OFFSET
  • Newly Introduced Functions in Recent Version of Excel*: – CONCAT, TEXTJOIN, IFS, SWITCH, DGET, UNIQUE, FILTER etc.
  • Nested Conditions/Customize Formulas*

Data Analysis

  • Data Sorting
  • Data Filtering
  • Named Ranges
  • 10 different ways to use Conditional Formatting
  • 10 different use of Data Validation
  • What-If Analysis

Excel Charts

  • Introduction to Excel Charts
  • Exploring most commonly used Charts and Templates
  • Basics of Charts
  • Selecting Requirement based Charts
  • Working with Basic Charts:
  • Creating Customized / Advanced Charts
  • Creating Dynamic Chart
  • Working with Dynamic Interactive Charts in Excel using Drop Down
  • Working with Chart Elements, Formatting, Chart Styles, Properties etc.

Pivot Tables

  • Introduction to Pivot Table
  • Creating a Pivot Table
  • Use of Calculated Fields/Items
  • Pivot Table Formatting
  • Grouping Items & Summarizing data in Pivot Tables
  • Grouping and Bucketing data in Pivot Table
  • Changing/Modifying Data Sources
  • Working with Pivot Table Designs & Layouts
  • Exploring Important Pivot Table Options & Field Settings
  • Pivot Table Filters
  • Changing Pivot Table Summary Calculation
  • Use of Slicers in Pivot Table
  • Using Source Data to Convert into Infographic Summary
  • Introduction to Pivot Charts

Bonus Module

Getting Started with VBA

  • Quick Recap of Microsoft Excel
  • Introduction to Developer Ribbon Tab
  • Introduction to VBA
  • What is VBA / Macro in Excel?
  • Introduction to Visual Basic Editor Window
  • Getting Familiar with Visual Basic Editor (VBE)
  • Customizing the VBE Environment
  • The Macro Recorder
  • Executing / Modifying Recorded Macros
  • Saving Macro Workbook

VBA Nuts & Bolts 

  • Introduction to Sub and Function Procedures
  • Introducing the Excel VBA Object Model (A must know thing to become Pro in VBA)
  • Properties and Methods
  • Important and Useful Properties of Application Object
  • Working with Ranges Objects
  • Working with Comments
  • Variable, Data Types and Constant
  • Finding Last or Next available Row/Column
  • Selecting Rows/Columns/Table (Normally & Dynamically)

Working with Loops, Conditional Statements & Arrays

  • Introduction to VBA Loops & Conditional Statements
  • Working with Conditional Statements
  • Working with Loops
  • Working with Message & Inbox Box
  • With-End with Constructs
  • Controlling Program Flow
  • Introduction to Arrays

Formula Writing in VBA

  • Introduction to Excel VBA Functions and Worksheet Functions
  • Difference between R1C1 and A1 style referencing
  • Difference between Worksheet Functions Vs Active.cell Formula
  • Getting started with VBA Excel Functions
  • Getting started with WorksheetFunction
  • Working with Function Procedures
  • Getting started with User Defined Functions (UDF)
  • Fixing arguments of Formulas in VBA
  • Working and Creating Customize Functions
  • Error Handling & Debugging Techniques

UserForm & GUI

  • User Form Introduction
  • Exploring Form Controls & ActiveX Controls
  • Exploring UserForm Controls
  • Cycle/Sequence to follow to create UserForm
  • Validating User Inputs
  • Testing a UserForm
  • User Form Tricks
  • Understanding User Form Events

Working with Excel Features

  • Working with Pivot Tables
  • Charts
  • Sorting & Filtering

Interaction with Other Applications (Bonus)

  • Add-Inns
  • Type of different Excel events
  • Starting an application from Excel
  • Interacting with Microsoft Office Apps
  • Controlling Excel from another application
  • Sending Personalized emails via Outlook
  • Sending e-mail attachments from Excel
  • Working with Files & Folders
  • Converting / Saving Excel File into PDF

Getting Started with MySQL

  • An Introduction and Overview of MySQL
  • Installation and GUI Tools
  • An Overview

MySQL Fundamentals

  • Introducing SELECT statement
  • Introducing WHERE clause
  • Sort result with ORDER BY
  • Using FROM to specify the source tables
  • Importance of Clause Orders
  • Data Modification tricks

Creating Database and Tables

  • Creating a database
  • Creating a table
  • Creating Indexes
  • Controlling column behavior with constraints
  • Using foreign key constraints
  • Creating an ID column
  • Changing a schema with ALTER
  • Introducing NULL and NOT_NULL
  • Introduction to MySQL Data Types
  • Setting up default values
  • MySQL Warnings
  • Alerting a table

MySQL Functions and Clause

  • Introduction to MySQL Functions
  • String Functions – CONCAT, SUBSTRING, REPLACE, REVERSE, LENGTH, UPPER, LCASE etc.
  • Aggregate Functions – COUNT, MIN, MAX, SUM, AVG, ROUND etc
  • Date/Time Functions – CURDATE, CURTIME, CURRENT_DATE, LOCALTIME etc.
  • Control Flow Functions – IF, IFNULL, NULLIF etc.

Multiple Tables and JOINS

  • Introduction to JOINS
  • Different types of JOINS
  • JOINS and Aliases
  • Multiple Table Joins
  • Creating a simple Subselect
  • Understanding of Primary keys and Foreign keys

Transactions, Stored Routines & Triggers

  • Transactions & Stored Routines
  • Triggers

Bonus Module

  • Creating a New User Login
  • Granting access to new users
  • Backup and Restore databases
  • Important Keyboard Shortcuts Guide
  • Session Study Material
  • Situational Case Studies for Best Practice and Getting Ready for Corporate World
  • 6 Months Live Support via Phone/Email/Messages

Getting Started with Dashboard Introduction

  • Introduction to different type of Excel Dashboards
  • How to deal with raw data – Data Cleaning , Data Formatting etc.
  • What is KPI’s and why it is important to create dashboard
  • Understand management requirement
  • Purpose of Dashboard creation
  • Session Study Material

Customize Formulas – 50+ Formulas

Custom Formatting               

  • Conditional Formatting
  • Custom Formatting Date, Numbers, Currency etc.
  • Alignments, Height & Width, Uses of Colours, Insert Dashboard Related Pictures

10 different ways to use of Data Validation            

Customize Charts & Pivot Tables

  • How & where we should use charts in Dashboard?
  • 10+ Customize Chart such as Combo Chart, Pareto Analysis Charts, Thermometer Chart, Waterfall Chart, Gauge Chart etc.
  • Interactive Chart with Form Control                                                  

Dashboards Creation

  • Financial Dashboard / HR Dashboard / Operation Dashboard / Sales Dashboard