MIS Training - Advance Excel + Macro + Access + SQL
What you'll learn
- 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 Power Pivot and Power Map
- 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
- Basic Computer Knowledge is must
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.
Who this course is for:
- MIS Aspirants
- Management Graduates
- Want Data Management Expertise
- Want a career in MIS, Data Analytics & Data Management
My Name is Himanshu Dhar. I am a MIS trainer associated with I Turn Institute. I am having more then 14 years of experience in different projects in Excel and Macros. I do take care of freelancing projects as well and brings that practical touch into teaching. I have successfully trained more then 25000 students from various backgrounds and have conducted many corporate training and seminars.