Advance Excel & MIS Training Institute (online and Offline)

I  Have Received your mail/reply for Advance Excel & MIS Reporting
with VBA Macros

Below are ours course Outline

Level 1 (Advance Excel with Advance Formulas)

Level 1 ( Complete Excel Command Formulas and Charts/Pivot)

Part : - A   

     Excel Option

     Paste Special

     Custom Formatting

     Condition Formatting

     Sort Filter and Select

Part : - B  

     Pivot Table

     Advance Pivot Table

     Chart

      Hyperlink

     Object Editing

Part : - C   

    Logical Formulas

   

    Text Formulas

   

    Data & Time Formulas

  

     Lookup Formulas

    Database Formulas

    Financial Formulas

    Statically Formulas

    Array Formulas

Part : - D   

    Data Tools

    Data Validation

    Subtotal

    Shareworbook

    Macros ( Recording Editing)

    Form Control Action

Level 2 ( MIS and Report Automation with Dashboard)

Art of Conditional Formatting

Dynamic Chart Creation

Auto Report Format Creation

MIS Sample Report

Dashboard Concept

Sample Dashboard

Formulas Nesting

PPT Reporting

Level 3 ( VBA Programming with Macros and User defined Formulas)

Excel Form Control Option Button

Macros Recording

Macros Editing

Introduction of VBA Macros

Concept of VBE

Concept of Range Object

Concept of Workbook,Sheet and Chart Object

All Excel Command with VBA

VBA Data Type

VBA IF else Function

VBA String Functions

VBA Number Formation

VBA Info Function

VBA - User Define Function

VBA - All Important Formulas

UserForm -1,2,3,4,5,6,7,8,10

UserForm - Worksheet

VBA with Other Application

VBA with Pivot

VBA with Chart

VBA with Addis

VBA with Outlook mail Attachment

Live Reporting with VBA

Benefited of Our Training
*Get the 4 Days Damo Training Free
*Our Training is Personal Training
* Only one Person in one Batch
* 100% Live and Practical's Training
* Received Every Classes Training Video For Practice
* Job Helping Nature
* Help for Interview Preparation

Level 1 ( 20 Hours and 4000 only)
Level2 (15 Hours and 3500 only)
Level 3 ( 35 Hours and 6500)
Complete (Level 1,2,3 ) 45-60 Hours and 10000/- Only

Official Excel Training 5 days (10 Hours only 3000/-)

For Fee Deails Call Me and Log on my site

Advance Excel and MIS Training with VBA Macros
Sujeet Kumar
AEMTI
8802579388
www.excelonline.webs.com , www.advanceexceltraining.webs.com