MIS Training - Advance Excel + Macro + Access + SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
MIS Reporting and Analysis Training - Complete Data Management with Basic to Expert level Excel and Automation MacroDescription
A Management Information ystem (MIS) provides organisation with the information they require in an organised 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.
Requirements
- Requirements
- Basic Computer Knowledge is must
Knowledge
- Advance Level Excel
- Expertise in Using Text Function
- Expertise in Using Logical Function
- Expertise in Using Math Function
- Expertise in Using Lookup & Reference Function
- Expertise in Using Date and Time Function
- Expertise in Using Pivot Table and Chart
- Expertise in Using What If Analysis Tools
- Many Others Excel Tools
- MS Access Knowledge on Table, Form, Queries and Reports
- SQL Queries
- Macro Recording
- Excel VBA Object Handling with practical Project
- Excel VBA Variable with practical Project
- Excel VBA IF & Case with practical Project
- 3 Types of Loop with practical Project
- Create your own Function
- Events in VBA
- FSO in Excel VBA
- Userform in Excel VBA
- Automate Pivot and Outlook in Macro
- Many More Macro Topics and Projects
MIS Training - Advance Excel + Macro + Access + SQL
- 0.0
-
![]()
![]()
![]()
![]()
![]()
MIS Reporting and Analysis Training - Complete Data Management with Basic to Expert level Excel and Automation Macro MIS tools and knowledge is very important nowadays....
