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