Sunday, 19 August 2012


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