MIS Training - Advance Excel + Macro + Access + SQL

Name: MIS Training - Advance Excel + Macro + Access + SQL
Rating: 4.6 (1828 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

English [Auto],Indonesian [Auto],

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
Explore Flash Fill in Excel and learn how to automatically extract names, phone numbers, and concatenate data using suggestions and keyboard shortcuts to speed up data cleaning.
Cell reference4:27
Quiz
Operators based equation in Excel9:09
Master Excel operators and build equation-based calculations, including addition, subtraction, multiplication, division, power, percentage, and concatenation, with focus on order of operations and logical tests.
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 the workbook to lock its structure and sheet changes with a password, preventing adding, deleting, renaming, or hiding sheets; unprotect with the password to make edits.
Protect sheet7:27
Protect a worksheet by setting a password, choose allowed actions, and use review > protect sheet to enforce restrictions and manage editable ranges.
Hide Formulas and unlocked Cell4:12
Protect File with password2:29
Quiz
If Function - Logical Test8:42
If Function - with Equation and task3:03
Use the Excel if function to determine scholarship eligibility and compute the amount: if score is below 70, no scholarship; otherwise (score minus 70) times 1000.
If Function - Nested If3:51
IFS Function - Updated4:56
If Function - advance4:43
Learn to apply the max function in Excel with absolute references to prevent range shifts when dragging, and compare it with the min function to identify the lowest value.
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
Explore how to create defined names for ranges, set scope to sheet or workbook, manage names via the name manager, and use them in formulas and navigation.
Hyperlink in Excel7:50
Explore how to create and use hyperlinks in Excel to navigate between sheets, link to named ranges, websites, other files, emails, and even create new documents within the workbook.
Group, Ungroup and Subtotal7:35
Date and Time setting5:31
Date and Time Format8:35
Date and Time Functions6:27
NETWORKDAYS Function4:41
Explore how to use the networkdays function to count work days between dates, with optional holidays and customizable weekends via networkdays.intl.
DATEDIF Function3:40
Master the datedif function to compute age from birth date to today, returning years, months, and days with start date, end date, and y, m, d parameters.
Pivot Table - Intro5:18
Pivot Table - Manage Field Area7:16
Pivot Table - Value Field, Report and more5:18
Explore pivot table techniques in Excel, focusing on value fields, region-based totals, and transaction analysis, with how to refresh data and adjust settings to build reports.
Pivot Table - Slicer and Dublicate Pivot6:51
Explore pivot tables with slicers to filter data, apply ascending or descending sorting, and arrange fields to build focused dashboards.
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
Master goal seek in Excel to hit a target profit by adjusting sales or costs, selecting the changing cell and goal value, and exploring simple to complex scenarios.
Analysis Add in - Solver4:52
Scenario manager6:27
PMT function - EMI calculator4:38
Data table - Create Loan Table7:50
Create a loan table in Excel using data table and what-if analysis to calculate emi and total interest, adjust loan terms, and customize headings and formats.
Share book2:28
Chart Preperation14:30
Learn to create and customize charts in Excel, from selecting data and choosing a column chart to configuring horizontal and vertical axis titles, the legend, data labels, and formatting options.
Chart Preperation - Advance5:21
Chart Preperation - Customize3:54
Power Map in Excel - Updated5:11
Explore how to create 2D and 3D maps in Excel Power Map, visualize sales data with field maps, customize styles, and export animated maps as videos with specified resolutions.
Filter Option in Excel16:38
Date and Color Filter4:30
Advanced Filter option6:37
Sorting and Custom Sort4:31
Sort data efficiently by name alphabetically with A to Z, then apply ascending or descending order, and use custom sort with a custom list to prioritize values.
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
Create dynamic dependent drop-down lists in Excel using data validation, named ranges, and the indirect function to populate department and corresponding employee names.
Advance Math Function7:13
Advance Math Function 26:36
Using of Wild Card in Math Function2:42
Explore how to use wildcards in Excel formulas to filter data, focusing on names starting with a letter and matching specific character lengths using * and ? in criteria.
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
Master the offset function in Excel to build dynamic reports. Learn to set a reference cell, adjust rows and columns, and use height and width with sum, count, and average.
Macro Recording part 115:17
Macro Recording part 25:19
Macro Recording part 33:10
Record a macro to automate opening the expense report template, assign a shortcut, and learn several ways to run macros to simplify end-user tasks.
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
Learn to format Excel selections with VBA by applying colors via RGB and alignment (left, right, center) using active cell techniques and macros.
End Command in VBA6:17
Discover how to use the end command in VBA to reach the end of data, navigate with control down, and manipulate ranges with offset and select in Excel.
Offset in VBA4:49
Task on Data Entry Automate2:14
Learn to automate data entry in Excel by creating a macro that prompts for age and salary, fills the corresponding cells, and auto-increments serial numbers.
Solution for the task5:11
Methods to refer to sheets8:31
Methods related to sheets and its properties10:05
Sheet related task1:52
Demonstrates a macro that prompts for a new sheet name, creates the sheet as the last in the workbook, and clears the last sheet.
Sheet Related Task Solution3:48
Methods to Refer to Workbooks2:50
Methods related to workbook3:20
Explore methods related to workbook management, including creating new workbooks, naming them, saving changes, working with sheet properties, and closing files in Excel.
Workbook related project10:35
Declared Variable10:02
Learn how to declare variables in programming with option explicit, define name and age inputs, prevent undefined variables, and debug type mismatches to ensure reliable code.
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
Use a macro linked to a button to create new sheets in the workbook, demonstrating how to manage multiple sheets beyond the initial set.
Solution of IF task3:03
Select Case3:50
Select Case 2nd Scenario4:50
Select Case 3rd Scenario8:38
Understanding Loop5:39
Understand how loops drive macros by repeating actions until a stopping condition is met. Learn to prevent infinite loops and control execution line by line during macro tasks.
Loop Practical example5:02
Loop Related Task Solution4:14
Do While Loop2:13
Discover the do while loop, its execution based on a condition, and how operators like not equal are used to control iterations, with pros and cons.
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
Use the file system object in VBA to create folders, copy files, and manage overwrites with the Microsoft scripting runtime, while handling paths and extensions.
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: