MIS Training - Advance Excel + Macro + Access + SQL

Name: MIS Training - Advance Excel + Macro + Access + SQL
Rating: 4.5 (1798 reviews)

MIS Reporting and Analysis Training - Complete Data Management with Basic to Expert level Excel and Automation Macro

Created byHimanshu Dhar

Last updated 12/2025

English

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

Course content

3 sections • 169 lectures • 16h 49m total length

Excel structure8:12
Understanding Excel Structure, its header section and few important technical jargon. Also in the resource there is zip file. Download that file and you will find all the practice file, which will be required during this training.
Cell properties2:46
Cell properties describes that what all the things are possible in MS Excel cell /Range.
Quiz
Autofill value and text4:49
Autofill date2:26
Autofill Adv tools4:40
Flash Fill in Excel - Updated3:15
Cell reference4:27
Quiz
Operators based equation in Excel9:09
Math Function in Excel13:47
Quiz
Print related options in Excel Part 111:48
Print related options in Excel Part 28:20
Draw Tab in Excel - Updated5:22
Text Function - Upper, Lower, Proper, Trim5:45
Text Function - Right, Left3:52
Text Function - Find and task6:11
Text Function - Solution and Nested Left5:30
Text Function - Find and Left Nesting2:49
Text Function - MID3:13
Text Function - Mid task and solution6:02
Text Function - Concatenate3:21
Text Function - Concatenate task and solution2:05
Concat and Textjoin Function - Updated4:21
Text Function - Replace4:46
Text Function - Replace task and Solution5:03
Text Function - Substitute4:34
Text Function - Len, Rept, Exact, search2:38
Test Your Skill 2
Pduration Function - Updated2:33
Quiz
Text to column8:58
Workbook protect4:01
Protect sheet7:27
Hide Formulas and unlocked Cell4:12
Protect File with password2:29
Quiz
If Function - Logical Test8:42
If Function - with Equation and task3:03
If Function - Nested If3:51
IFS Function - Updated4:56
If Function - advance4:43
If Function - advance - 24:53
AND , OR Function6:40
AND, OR, IF Nested5:07
AND, OR Advance2:17
XOR Function - Updated4:34
Quiz
Define Name Feature9:07
Hyperlink in Excel7:50
Group, Ungroup and Subtotal7:35
Date and Time setting5:31
Date and Time Format8:35
Date and Time Functions6:27
NETWORKDAYS Function4:41
DATEDIF Function3:40
Pivot Table - Intro5:18
Pivot Table - Manage Field Area7:16
Pivot Table - Value Field, Report and more5:18
Pivot Table - Slicer and Dublicate Pivot6:51
Pivot Table - Group to mange date and values5:07
Pivot Table - Insert Calculated Field3:21
GETPIVOTDATA Formula4:27
Power Pivot in Excel - Updated29:45
Practice file is available in Resources
Goal seek7:05
Analysis Add in - Solver4:52
Scenario manager6:27
PMT function - EMI calculator4:38
Data table - Create Loan Table7:50
Share book2:28
Chart Preperation14:30
Chart Preperation - Advance5:21
Chart Preperation - Customize3:54
Power Map in Excel - Updated5:11
Filter Option in Excel16:38
Date and Color Filter4:30
Advanced Filter option6:37
Sorting and Custom Sort4:31
Conditional Formatting - Apply11:30
Conditional Formatting - Types of Rules5:22
Conditional Formatting - Icon Set3:09
Conditional Formatting - Mange Rules4:10
Conditional Formatting - Create New Rules4:35
Quick Analysis and Chart Recommendation - Updated3:58
Data Validation10:46
Data Validation - Input message and Error Alert4:56
Indirect Function4:45
Data Validation - Create Dependent List4:12
Advance Math Function7:13
Advance Math Function 26:36
Using of Wild Card in Math Function2:42
Database Math Function - DSUM, DCOUNT, DAVERAGE, DMAX and DMIN7:56
Subtotal Function in Excel4:47
Vlookup Function8:10
Vlookup with Iferror5:07
Vlookup Nesting with If2:21
Hlookup2:43
Match Function3:42
Index and match nested8:18
Vlookup array4:35
Vlookup Column Function Trick4:34
Vlookup TRUE3:47
Advance VLOOKUP6:21
Offset Function8:23
Macro Recording part 115:17
Macro Recording part 25:19
Macro Recording part 33:10
Types of ways to run macros5:59
Practice Test - Excel

Introduction to Macro8:57
Start Macro Programming7:06
Macro Task Basic4:05
Methods to Refer Range6:55
Selection of multiple cell5:56
Formatting through VBA7:18
End Command in VBA6:17
Offset in VBA4:49
Task on Data Entry Automate2:14
Solution for the task5:11
Methods to refer to sheets8:31
Methods related to sheets and its properties10:05
Sheet related task1:52
Sheet Related Task Solution3:48
Methods to Refer to Workbooks2:50
Methods related to workbook3:20
Workbook related project10:35
Declared Variable10:02
Data Types in Variable6:16
Object variable related project2:16
Solution for the task - Object Variable3:43
Variable Project7:42
Apply IF in VBA5:22
AND OR in VBA8:13
Project related to IF1:28
Solution of IF task3:03
Select Case3:50
Select Case 2nd Scenario4:50
Select Case 3rd Scenario8:38
Understanding Loop5:39
Loop Practical example5:02
Loop Related Task Solution4:14
Do While Loop2:13
For Loopcounter6:29
For Loopcounter Step importance3:50
For Loopcounter Step Example 26:34
For Each Loop4:46
For Each Example4:15
For Each Task Solution2:41
Loop Related Task1:38
Loop Solution and Further Task6:23
Loop Related Project14:52
How to create Events9:25
Events Example and task3:04
Event Task Solution2:37
Sheet Specific Events3:18
Create Function in VBA6:49
Function Related Task1:33
Function Related task Solution1:42
Create Optional Parameter in Function4:15
VBA to control Outlook for mail9:24
Outlook Related Project5:13
Create Userform18:41
Create Pivot Table with VBA9:03
File System Object in VBA5:46
File in FSO3:03
FSO Practical Example7:00
Late Binding Technique in Macro4:49

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

MIS Training - Advance Excel + Macro + Access + SQL

What you'll learn

Explore related topics

Course content

MS Excel102 lectures • 10hr 7min

MS Access and SQL9 lectures • 1hr 13min

Excel VBA - Macro58 lectures • 5hr 30min

Requirements

Description

Who this course is for: