-17%

MIS Training – Advance Excel + Macro + Access + SQL

Tiwary
Last Update
0 already enrolled

About This Course

Rate this courses

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 of all the important aspects requires 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

  • MIS Aspirants
  • Management Graduates
  • Want Data Management Expertise
  • Want a career in MIS, Data Analytics & Data ManagementMIS Aspirants
  • Management Graduates
  • Want Data Management Expertise
  • Want a career in MIS, Data Analytics & Data Management

Your Instructors

Tiwary

0/5
69 Courses
0 Reviews
0 Students
See more

24,999.0029,999.00

17% off
Level
Intermediate
Subject

Related Courses

-23%
Direct and Indirect taxes
Direct and Indirect taxes

9,999.0012,999.00

-17%
E-Accounting Institute in Delhi
E-Accounting Institute in Delhi

24,999.0029,999.00

-20%
digital marketing course (24)
Goods and Services Tax (GST) Course

7,999.009,999.00

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
Compare

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