Scribd Logo
Upload

Welcome to Scribd!

  • 73 views

    VBA MACRO Course Training Syllabus

    Uploaded by

    2442230910
    The syllabus covers topics related to Visual Basic for Applications (VBA) programming in Microsoft Excel, starting with introductions to macros and the Visual Basic Editor. It then progresses to object-oriented programming concepts like variables, data types, objects, and collections. Further topics include loops, arrays, automating procedures using worksheet and workbook events, embedding controls, programming charts and pivot tables, and creating userforms. The syllabus also covers advanced techniques like class modules, add-ins, managing external data, and interacting with other Office applications like Word, Outlook, Access, and PowerPoint.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    VBA MACRO Course Training Syllabus

    Uploaded by

    2442230910
    73 views3 pages
    The syllabus covers topics related to Visual Basic for Applications (VBA) programming in Microsoft Excel, starting with introductions to macros and the Visual Basic Editor. It then progresses to object-oriented programming concepts like variables, data types, objects, and collections. Further topics include loops, arrays, automating procedures using worksheet and workbook events, embedding controls, programming charts and pivot tables, and creating userforms. The syllabus also covers advanced techniques like class modules, add-ins, managing external data, and interacting with other Office applications like Word, Outlook, Access, and PowerPoint.

    Original Title

    VBA-MACRO-course-training-syllabus.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The syllabus covers topics related to Visual Basic for Applications (VBA) programming in Microsoft Excel, starting with introductions to macros and the Visual Basic Editor. It then progresses to object-oriented programming concepts like variables, data types, objects, and collections. Further topics include loops, arrays, automating procedures using worksheet and workbook events, embedding controls, programming charts and pivot tables, and creating userforms. The syllabus also covers advanced techniques like class modules, add-ins, managing external data, and interacting with other Office applications like Word, Outlook, Access, and PowerPoint.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    73 views3 pages

    VBA MACRO Course Training Syllabus

    Uploaded by

    2442230910
    The syllabus covers topics related to Visual Basic for Applications (VBA) programming in Microsoft Excel, starting with introductions to macros and the Visual Basic Editor. It then progresses to object-oriented programming concepts like variables, data types, objects, and collections. Further topics include loops, arrays, automating procedures using worksheet and workbook events, embedding controls, programming charts and pivot tables, and creating userforms. The syllabus also covers advanced techniques like class modules, add-ins, managing external data, and interacting with other Office applications like Word, Outlook, Access, and PowerPoint.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

                                   MICRO-VBA SYLLABUS                               

    UNDERSTANDING THE BASIC


     Introducing VBA
     Getting Started with Macros
     Introducing the Visual Basic Editor
     Working in the VBE
    DIVING DEEPET INTO VBA
     Object-oriented Programming — An Overview
     Variables, Data Types, and Constants
     Understanding Objects and Collections
     Making Decisions with VBA
    BEYOND THE MACRA RECORDER: WRITING YOUR OWN CODE
     Repeating Actions with Loops
     Working with Arrays
     Automating Procedures with Worksheet Events
     Automating Procedures with Workbook Events
     Using Embedded Controls
     Programming Charts
     Programming PivotTables and PivotCharts
     User Defined Functions
    Debugging Your Code
     ADVANCE PROGGRAMMING TECHNIQUES
     Creating UserForms
     UserForm Controls and Their Functions
     Advanced UserForms
     Class Modules
     Add-Ins
     Managing External Data
     Data Access with ActiveX Data
     Not Gone, Not Forgotten
    INTERACTING WITH OTHER OFFICE APPLICATIONS
     Overview of Office Automation from Excel
     Working with Word from Excel
     Working with Outlook from Excel
     Working with Access from Excel
     Working with PowerPoint from Excel
    Office No. 107, 1st Floor, Pawan Complex, Opp. Paras Wine, Ulhasnagar Station Road,Ulhasnagar - 421003,
    9820410824 / 9819685808 www.neotech institute.com

    You might also like