About the Course
Management information systems involve three primary resources: people, technology, and information or decision making. Management information systems are distinct from other information systems in that they are used to analyze operational activities in the organization. This seminar is designed in such a way that the people from the relevant field can have insight about the tools and techniques to develop a customizable MIS system.
Topics CoveredDay 1 & 2 : (Main Focus EXCEL)
Focus on real scenarios of Reporting / Data Management / Automation
Difference between basic and advance Excel
Data Management and Analysis
Pivot Table, Macros
Concepts of VBA
Excel Data Handling with VBA
Use of SQL Queries
User Form, List Box, Combo Box, Buttons etc.
Day 3 & 4: (MAIN Focus ACCESS)
Database, Tables, Fields and Properties
SQL Queries, Reports and Data Management
VBA Programming and Data Management
Forms, Reports & Application Design
Who should attendMS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments
Pre-requisitesKnowledge of basic excel is mandatory.
What you need to bringnotepad, pens, pencils
Key TakeawaysAt the end of training participants will be able to know:
Various MIS technique with the help of Excel VBA Programming
Get an overview of different Analytical Process
Data handling with the help of Access
Reporting and Formatting by different angles
Macro generation and application design
Writing customize queries as per the need
Fundamentals of data handling, MIS, EXCEL and Access.