Learn MS Excel VBA Macros Programming Online Live Class with Sujeet Kumar

Excel VBA Macros Power Programming with you can create Custom Automation Macros, New Function/Formulas for Excel or Macros. In This course you will Learn Complete Macros Programming like Object,Event,Conditions,Loops,Userform,Interface, Other Application Connctvity like Outlook,Webpage,Folder,Notepad,MS Word or Database(MS Access, SQL Oracal)...

Enrol This Course Now

PART=2

     1. Basic Macros Programming

        Concept of VBA Programming Language
        Type of VBA Macros
        Recording Macros with Editions
        how can write Macros and Algorithm
        Workbooks,Sheets and Range Object with member
        File and Folder Handling with VBA
        Formating,Style and Report Format Creation
        Report Format Projeact

     2. Apply Conditions in VBA

        Formatting Triks
         Data Type Decleation ( Varaibles)
        Simple IF Condition in VBA
        And,OR and XOR with if Condition
        Nested if or Complicate Condition with IF
        Select Case ans Switch Case
        Create Formulas for IF
        Live Project with VBA Macros for Report Automation

     3.Loops with VBA

        For Loop
        Nested Loop
         For Each Loop
         Do While Loop
        Do Until Loop
        Show File - Folder List with Directory Function
        Loop with If Condition
        Live Project with Loop and Condition

     4. Event Macros Programming

        Fundamental for Event Macros Programming
        WorkSheet and Range Event Macros Programming
        Workbooks Event Macros Programming
         Button and Object Macros Programming
        Add ActiveX Control in Sheets
        Live Project with Event Macros Programming

     5. Excel VBA Macros Function(Formulas ) Creation

        Formulas / Function Creation with VBA Programming
        Advanced Formulas Method with VBA Programming
         String Function
         Number Function
        Date and Time Calculation using Data Time Formulas
        Information Formulass
        Lookup Method(VLookup,HLookup,Match,Index,Offset) with VBA
        Advanced VLookup and VLookup Listing with VBA
        File and Directory Function
        Data Summerization Formulas (AVERAGEIF,AVERAGEIFS,COUNTIF,COUNTIFS,LARGE,SMALL and more) with VBA
        Database and list managment Formulas with VBA
        File, Folder Copy - Rename , Delete and Hide -unhide formulas
        Financial Formulas
        Live Project with VBA Function

     6. Advanced Formulas/Function

        Advanced Array Formulas with VBA
        Complicated Large Formulas Creation with VBA
         Advanced Naming Method with Formulas
         Report Automation with Formulas
         Live Automation Projeact
        New Formulas Creation with VBA Programming

     7. Charting and Dashboard Report Automation with VBA

        Chart Creation
        Chart Triks
         use Button on chart
         Dynamic Chart with Offset Formulas
         Dashboard Example
         Live Project

     8. Pivot Automation with VBA

        Create Pivot with VBA
        Links One more Data in VBA Macros
         Report Automation with VBA Macros
         SQL in Pivot with VBA Macros
         Dashboard Example with Pivot with VBA
         Live Project

     9. UserForm in Excel

        Concept of Userform in VBA
        TextBox , Lable, and Combo Box in VBA
         List Box Automation
         Filter Duplicate and Multi-Connection Listbox
         Multi Page, PDF and FLV , MediaPlayer and Other type of Emmbed Application
         Live Project

     10. Picture / Image Automation with VBA Macros

        Show Picure in Userform
        Chart Triks as image on Userform
         Show Google Image on Userform
         Dynamic Picture Automation
         Live Project with Picture Automation

     11. Database Conectvity and Other Application with VBA

        MS Access Database Conectvity
        Notepad and Webdata Connectvity
         Embed Other Application
         SQL or Oracle Connectvity
         SQL Query in MS Excel 2016
         File & Folder Directory Access
         Live Project For Final Certification

     Course Duration & Fees

         45 Hours ( Mon to Fri 1 Hours (5:00 AM to 11:00 PM)
        One to One Live Online Class
         Fees : - 10000/-
         Class Videos , Notes, PDF Books, Articles and Free Re-Joining

Enrol This Course Now

Sample Videos

Watch More

Advanced Excel & MIS Training Institute

Part of IPT (Institute of Professional of Training)
This is Group of Working Professianal Do Frelance with Us you can join our Class from your Computer using Gotomeeting
Operational Office : - Dakshinpuri, New Delhi - 110062
E-Mail - Kumar@iptindia.com, sujeetkumar.ipt@gmail.com, Skype ID - AdvExcel1
Mobile - +91 8802579388, +91 8826828093, +91 9968811487

Advanced Excel Training in Bhavnagar

I am Sujeet Kumar from Advanced Excel Training Center (India)  we provide Excellent Online Training of Advanced Excel, Data Analyst, VBA Macros Programming and MS Access Data Base

This is Live One - to One Online Training we connect with Gotomeeting webinar software

  3 part of Our Training


Part - 1

Advanced Excel with Formulas for Working Professionals 

In this part you can learn Complete Ms Excel 2016 inbuilt All Command , more then 200 function (Formulas) and All.

(i) Advanced Dashboard Formatting

(ii) Data Analysis and Data Handing

(III) Function and Advanced Calculation

(IV) Advanced and Complicate Function and Array Formulas

(v) Chart, Graph and Dynamic Chart

(vi) Dashboard and Report Automation

Duration & Fees

30 to 45 Days , Mon to Fro - 1 Hours Class

5.00 Am to 11.00 PM  class is open

Fees - 10000 INR

you can Join Free 3 days Demo Class

 Log on www.iptindia.com fill demo Calss Form

Class conduct in  Hindi/English

Part - 2

Excel VBA Macros Power Programming 

in this part learn complete VBA (Visual Basic for Application) for Macros Automation like - Macros,UserForm, Connectvity, Auto Report Creation etc.

(i) Basic to Advanced VBA Macrso Programming ( Macros,Event, Loops, Condition etc.)

(ii) Function Creation ( Create VBA Function / Formulas as per requirement )

(iii) Event Macros Programming 

(iv) Userform ( Create Best and more Attractive user interface in Excel using Userform)

(v) Automation  (how create tools for Create Automatic Report)

(vi) Other Application Connectivity (Connect Excel to Web, Outlook, MS Access, PDF, SQL Server, Orcal, Forxpro etc.)

 

Duration & Fees

35 to 45 Days , Mon to Fro - 1 Hours Class

5.00 Am to 11.00 PM  class is open

Fees - 15000 INR

you can Join Free 3 days Demo Class

 Log on www.iptindia.com fill demo Calss Form

Class conduct in  Hindi/English

Pert 3

MS Access 2016  Database 

In this part you can learn how can manage/create Database in MS Access

(i) Table and Database Creation and Modification

(ii) Form and VBA Form hanlder

(iii) Query and SQL Query

(iv) Extract Report

(v)  Application Connectivity ( Connect wit Excel, Outlook, Web, SQL and Oracle )

Duration & Fees

35 to 45 Days , Mon to Fro - 1 Hours Class

5.00 Am to 11.00 PM  class is open

Fees - 10000 INR

you can Join Free 3 days Demo Class

 Log on www.iptindia.com fill demo Calss Form

Class conduct in  Hindi/English

Regards

Sujeet Kumar

Trainer

IPT INDIA

www.iptindia.com

+91 8802579388 +91 8826828093

Skype : AdvExcel1