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:- 25000/- 21000/- (INR)

  • Duration :- 40 Hours | 20 Classes + Assigments Hours

  • Tools:- MS Excel, MS PowerPoint, MS Outlook, Google Drive

  • Learning Mode:- Classroom & Online Training

  • Batch Starting:-Saturday, 12th October’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 PowerPoint      

  • The PowerPoint Environment
  • The Title Bar
  • The Ribbon
  • File Tab & Backstage View
  • Quick Access Toolbar
  • The Scroll Bars
  • Presentation View Buttons
  • The Zoom Slider
  • The Status Bar
  • The Mini Toolbar
  • Keyboard Shortcuts

Creating Basic Presentation  

  • Opening Presentation
  • Closing Presentation
  • Creating New Presentation
  • Saving Presentation
  • Inserting New Slides
  • Applying Slide Layouts
  • Using the Save and Send Features
  • Working with PowerPoint File Formats

Using Presentation Views      

  • Normal View
  • Slider Sorter View
  • Notes Page View
  • Slide Show View

Using Text      

  • Adding Text to Slides
  • Basic Object Manipulation
  • Font Formatting
  • Paragraph Formatting
  • Applying Custom Bullets & Numbering
  • Using Tabs
  • Setting Text Box Option
  • Checking Spelling

Using Clip Art 

  • inserting Clip Art & Pictures
  • Basic Graphic Manipulation
  • Using Picture Tools
  • The Format Picture Dialog Box

Using Smart Art         

  • Inserting and Manipulating SmartArt
  • Formatting Smart Art

Using Slide Show View           

  • Running a Slide Show
  • Using Custom Show

Printing Your Presentation    

  • Usage Page Setup
  • Setting the Slide Header and Footer
  • Previewing and Printing Presentation

Helping Yourself        

  • Using PowerPoint Help

Applying Animation   

  • Adding Slide Transition Animation
  • Adding Object Animation

Introduction of MS Outlook                                     

  • Stay Organized and collaborate effectively
  • What can you do with Outlook?

Get Started                                        

  • Add an email account
  • Navigate the interface

Work with Email                                           

  • Read your mail
  • Organize your mail
  • Search your mail
  • Create, reply to and forward an email
  • Work with attachment

Work with People                                         

  • Create a new contact
  • Create a contact group

Work with Calendar                                      

  • Navigate the Calendar
  • Create an appointment
  • Create a meeting
  • Respond to a meeting invitation

Getting Started with Google Drive

  • Google Drive Basic Controls
  • Uploading, Downloading, Deleting and Restoring Files
  • Google Apps Within Drive
  • Adding and Removing Third Party Apps
  • Offline Drive Options
  • Sharing Files

Google Spreadsheet

  • Google Sheets Basic Controls
  • Toolbar Options in Sheets
  • Sorting and Protecting Data
  • Filtering Data
  • Pivot Tables
  • Functions and Formulas
  • Creating Charts
  • Conditional Formatting
  • Data Validation
  • Google Sheets Add-ons

Google Docs

  • Google Docs Basic Controls
  • Toolbar Options in Docs
  • Inserting Images, Links, Charts, and Drawings
  • Footnotes, Page Numbers, Headers and Footers
  • The Tools Menu in Docs
  • Creating and Formatting Tables in Docs
  • Suggesting Mode
  • Google Docs Add-ons

Google Slide

  • Google Slides Basic Controls
  • Themes and Slides
  • Inserting Images, Videos, and Slide Numbers
  • Formatting and Alignment in Slides
  • Ordering and Rotating Objects in Slides
  • Animations and Transitions

Google Forms

  • Google Forms Basic Controls
  • Question Types and Editing a Form
  • Making a Form into a Self Correcting Quiz
  • The Responses Tab
  • Google Forms Add-ons