MIS Training - Advance Excel + Macro + Access + SQL

MIS Reporting and Analysis Training - Complete Data Management with Basic to Expert level Excel and Automation Macro
4.50 (1329 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
MIS Training - Advance Excel + Macro  + Access + SQL
6,352
students
16.5 hours
content
May 2024
last update
$59.99
regular price

What you will 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

Screenshots

MIS Training - Advance Excel + Macro  + Access + SQL - Screenshot_01MIS Training - Advance Excel + Macro  + Access + SQL - Screenshot_02MIS Training - Advance Excel + Macro  + Access + SQL - Screenshot_03MIS Training - Advance Excel + Macro  + Access + SQL - Screenshot_04
1793298
udemy ID
7/11/2018
course created date
11/22/2019
course indexed date
Bot
course submited by
MIS Training - Advance Excel + Macro + Access + SQL - | Comidoc