MIS Training in Hindi - MS Excel + Macro + MS Access + SQL

Name: MIS Training in Hindi - MS Excel + Macro + MS Access + SQL
Rating: 4.4 (105 reviews)

MIS Reporting and Analysis Training - Expert level Data Management on MS Excel, Excel VBA (Automation), Access and SQL

Created byHimanshu Dhar

Last updated 10/2025

Hindi

What you'll learn

Basic to Advance Level MS Excel
Expertise in Using Math Function, Text Function and Logical Function
Expertise in Using Lookup and Reference Function
Expertise in Using Date and Time Function
Expertise in Using Pivot Table and Chart
Expertise in Using What If Analysis Tools
Many others Excel Tools
MS Access Knowledge on Table, Form, Queries and Reports
Learning SQL Queries - Works in any database
Expertise in using 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
Learn to Create your own Function
Learn Events and File System Object (FSO) in VBA
Create interactive Userform in Excel VBA
Automate Pivot and Outlook in Macro
Many More Macro Topics and Projects

Course content

25 sections • 133 lectures • 18h 27m total length

Introduction to Excel Structure17:41
Title Bar, Tabs, Ribbons, Workbooks, Worksheets, Range etc
Customizing Ribbons and options
Equation in Excel - Operators based5:42
How to use operators in Excel to do equation
BODMAS in EXCEL
Math Functions in Excel13:59
How to apply functions
SUM()
AVERAGE()
COUNT, COUNTA, COUNTBLANK
MAX, MIN
LARGE, SMALL
Nested Function
Data Validation16:05
Data Validation Types
Input Message
Error Alert Customization

Text Function 1 - Introduction7:41
Introduction to Text Function
UPPER()
LOWER()
PROPER()
TRIM()
Nesting TRIM with other Function
Text Function 2 - LEFT, RIGHT & MID Function11:26
LEFT()
RIGHT()
FIND()
Text Function 3 - Nested FIND, LEFT & RIGHT8:22
Advance FIND()
Nesting FIND with RIGHT() & LEFT()
Text Function 4 - MID Function10:29
MID Function
Nested MID
Text Function 5 - Concatenate7:51
CONCATENATE()
Nesting CONCATENATE with other Text Function.
Text Function 6 - REPLACE9:03
REPLACE()
Nested REPLACE()
Text Function 7 - Substitute, Rept & Len5:57
SUBSTITUTE()
REPT()
LEN()
Nested Function
Text to Column12:15
How to use Text to Column
Delimited & Fixed Width
Date Format through Text to Column
Test Your Skill 2

IF Function - Logical Test & Introduction10:07
Logical Test
Introduction to If Function
If Function - Nested8:02
Nested If Examples
IF Function - Advance8:47
Nesting IF() with other Functions to get desired output
AND() & OR() Function16:54
AND() Function
OR() Function
Nested IF() with AND() & OR()
Advance Examples
Advance Math Function 1 - SUMIF, COUNTIF, AVERAGEIF7:45
SUMIF()
COUNTIF()
AVERAGEIF()
Advance Math Function 2 - SUMIFS, COUNTIFS, AVERAGEIFS8:19
SUMIFS()
COUNTIFS()
AVERAGEIFS()
Wild Card

VLOOKUP & HLOOKUP Function9:13
VLOOKUP()
HLOOKUP()
MATCH, INDEX and OFFSET Function11:41
MATCH()
INDEX()
Nesting both to get desired result
OFFSET Function4:17
OFFSET()
Nesting Offset and more example
VLOOKUP TRUE4:40
How to use VLOOKUP() TRUE option
LOOKUP Function5:45
LOOKUP()
Drawbacks and how to apply it correctly
Lookup & Reference 6 - Tricks 110:28
How to apply VLOOKUP() in all columns in a single go
Array VLOOKUP()
VLOOKUP() with IFERROR
VLOOKUP with IF
Lookup & Reference 7 - Tricks 25:01
Nested Lookup Function
Advance Level Examples and problem solving

Conditional Formatting 111:39
How to apply conditional formatting
Types of Conditional Formatting
Conditional Formatting 2 - Customize7:13
How to Manage Rules - Edit & Delete
How to apply new Rules - Based on Formulas
Conditional Formatting 35:16
Advance Customize options
Chart Preparation 1 - Introduction15:16
Start with Excel Chart
Understanding Layout options
Chart Preparation 2 - Format, Design, Axis & Series8:00
Chart Format
Chart Design
Handling Axis and Series
Chart Preparation 3 - Customize6:04
Handling Data Series and Legends
Customize options
Power Map in Excel - Updated5:11
Pivot Table 1 - Starts with14:25
How to create Pivot Table
Managing Fields Properly in Field area
Managing Value setting
How to get detailed report
Pivot Table 2 - Exploring Features & Functionality16:28
Managing Field List, Buttons & Field Headers
Refresh Options
Designing Pivot Table
Pivot Table layout
Changing Source Data
Managing Slicer
Pivot Chart
Multiple Pivot Table
Pivot Table 3 - Advance8:57
Handling Dates and Values through Group option
Doing Calculation through Calculated field.

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
Any Graduate
Want Data Management Expertise
Want a career in MIS, Data Analytics and Data Management

MIS Training in Hindi - MS Excel + Macro + MS Access + SQL

What you'll learn

Explore related topics

Course content

MS Excel - Introduction4 lectures • 53min

MS Excel - Cell Handling2 lectures • 18min

MS Excel - Text Handling8 lectures • 1hr 13min

MS Excel - Data Management6 lectures • 53min

Logical & Advance Math Functions6 lectures • 1hr

MS Excel - What if Analysis & Financial Tools4 lectures • 33min

MS Excel - LOOKUP & Reference Functions7 lectures • 51min

MS Excel - Data Organizing Tools10 lectures • 1hr 38min

MS Excel - Print Options in Excel2 lectures • 22min

MS Excel - Security Options4 lectures • 23min

Requirements

Description

Who this course is for: