Mis Training - Advance Excel + Macro + Access + Sql
Last updated 5/2024
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English (US) | Size: 5.94 GB | Duration: 16h 22m
Last updated 5/2024
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English (US) | Size: 5.94 GB | Duration: 16h 22m
MIS Reporting and Analysis Training - Complete Data Management with Basic to Expert level Excel and Automation Macro
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
Requirements
Basic Computer Knowledge is must
Description
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