MIS Training - Advance Excel + Macro + Access + SQL 

Excel Structure

Cell properties

Autofill value and text

Autofill date

Autofill Adv tools

Flash Fill in Excel - Updated

Cell reference

Operators based equation in Excel

Math Function in Excel

Print related options in Excel Part 1

Print related options in Excel Part 2

Draw Tab in Excel - Updated

Text Function - Upper, Lower, Proper, Trim

Text Function - Right, Left

Text Function - Find and task

Text Function - Solution and Nested Left

Text Function - Find and Left Nesting

Text Function - MID

Text Function - Mid task and solution

Text Function - Concatenate

Text Function - Concatenate task and solution

Concat and Textjoin Function - Updated

Text Function - Replace

Text Function - Replace task and Solution

Text Function - Substitute

Text Function - Len, Rept, Exact, search

Pduration Function - Updated

Text to column

Workbook protect

Protect sheet

Hide Formulas and unlocked Cell

Protect File with password

If Function - Logical Test

If Function - with Equation and task

If Function - Nested If

IFS Function - Updated

If Function - advance

If Function - advance - 2

AND , OR Function

AND, OR, IF Nested

AND, OR Advance

XOR Function - Updated

Define Name Feature

Hyperlink in Excel

Group, Ungroup and Subtotal

Date and Time setting

Date and Time Format

Date and Time Functions

NETWORKDAYS Function

DATEDIF Function

Pivot Table - Intro

Pivot Table - Manage Field Area

Pivot Table - Value Field, Report and more

Pivot Table - Slicer and Dublicate Pivot

Pivot Table - Group to mange date and values

Pivot Table - Insert Calculated Field

Power Pivot in Excel - Updated

Goal seek

Analysis Add in - Solver

Scenario manager

PMT function - EMI calculator

Data table - Create Loan Table

Share book

Chart Preperation

Chart Preperation - Advance

Chart Preperation - Customize

Power Map in Excel - Updated

Filter Option in Excel

Date and Color Filter

Advanced Filter option

Sorting and Custom Sort

Conditional Formatting - Apply

Conditional Formatting - Types of Rules

Conditional Formatting - Icon Set

Conditional Formatting - Mange Rules

Conditional Formatting - Create New Rules

Quick Analysis and Chart Recommendation - Updated

Data Validation

Data Validation - Input message and Error Alert

Advance Math Function

Advance Math Function 2

Using of Wild Card in Math Function

Database Math Function - DSUM, DCOUNT, DAVERAGE, DMAX and DMIN

Vlookup Function

Vlookup with Iferror

Vlookup Nesting with If

Hlookup

Match Function

Index and match nested

Vlookup array

Vlookup column func trick

Vlookup TRUE

Advance VLOOKUP

Macro Recording part 1

Macro Recording part 2

Macro Recording part 3

Types of ways to run macros

Access Intro

Create table in MS Access

How to Import and Export in Access

Create form from table

Create Blank Form in Access

Creating Report in Access

Query in access

SQL Queries Part 1

SQL Queries part 2

Introduction to Macro

Start Macro Programming

Macro Task Basic

Methods to Refer Range

Selection of multiple cell

Formatting through VBA

End Command in VBA

Offset in VBA

Task on Data Entry Automate

Solution for the task

Methods to refer to sheets

Methods related to sheets and its properties

Sheet related task

Sheet Related Task Solution

Methods to Refer to Workbooks

Methods related to workbook

Workbook related project

Declared Variable

Data Types in Variable

Object variable related project

Solution for the task - Object Variable

Variable Project

Apply IF in VBA

AND OR in VBA

Project related to IF

Solution of IF task

Select Case

Select Case 2nd Scenario

Select Case 3rd Scenario

Understanding Loop

Loop Practical example

Loop Related Task Solution

Do While Loop

For Loopcounter

For Loopcounter Step importance

For Loopcounter Step Example 2

For Each Loop

For Each Example

For Each Task Solution

Loop Related Task

Loop Solution and Futher Task

Loop Related Project

How to create Events

Events Example and task

Event Task Solution

Sheet Specific Events

Create Function in VBA

Function Related Task

Function Related task Solution

Create Optional Parameter in Function

VBA to control Outlook for mail

Outlook Related Project

Create Userform

Create Pivot Table with VBA

File System Object in VBA

File in FSO

FSO Practical Example

Late Binding Technique in Macro