MIS Training – Advance Excel + Macro + Access + SQL

inteligeneit@gmail.com Tiwary
Last Update June 15, 2022
0 already enrolled

About This Course

Management Information System (MIS) provides organizations 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 are not a part of any academic curriculum. 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 all the important aspects required in the real world to get the job done in MIS.

The student will get enhanced 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.

Learning Objectives

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 a must

Target Audience

  • absolute SAS beginners
  • Is anyone interested in taking SAS BASE certification exams

Your Instructors

inteligeneit@gmail.com Tiwary

6 Courses
0 Reviews
0 Students
See more


27% off

Related Courses

Data Analysis Course
Data Analytics Course


Python +Django Framework Training
Python +Django Framework Training


data science
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar

Don't have an account yet? Sign up for free