MIS Training – Advance Excel + Macro + Access + SQL

admin
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

Requirements

  • Basic Computer Knowledge is a must

Target Audience

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

Your Instructors

admin

0/5
61 Courses
0 Reviews
0 Students
See more

Write a review

29,000.0039,999.00

27% off
Level
Intermediate
Subject

Related Courses

-20%
Python +Django Framework Training
Python +Django Framework Training

19,999.0024,999.00

-25%
data science
-9%
Data Analytics with SAS+R+Python

49,999.0054,999.00

InteliGenes is one of India’s leading educational institutes

Best Foreign Languages And Computer Training Institute in Delhi 

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
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the compare bar
Compare
Compare ×
Let's Compare! Continue shopping