Learn Advanced Excel, VBA Macros or MS Access

Learn Complete Advanced Excel with VBA and Dashboad

Excel VBA Macros Power Programming for Report Automation

In Present Time have a demand for Automation, with VBA Macros you can Create a Report Creation Auto-Pilot , Just Click on Button your Report create a few Second , with VBA Macros have Macros Programming, Event Macros, Create a Own Formulas, Userform and Connectivity and more

Enrol This Course Now


     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

        E-Mail Automation with Outlook ( Send Mail Excel to Outlook )

        E-Mail Automation with Gmail/ Yahoo / AOL Mail/ Other POP 3 Mail

         PDF Mail Automation

         MS Word Handling - Create Letter accessing from Excel Data Sheet

        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


Book Demo Class