VBA with Microsoft Excel Online Training

Visual Basic for Applications (VBA) is an extensible programming language that is made up of a core set of commands and extended on a per application basis to be able to work directly with objects in that application. This means that VBA for Excel knows about things like workbooks,worksheets, cells and charts and more; while VBA for Access knows about tables, queries, reports and data entry forms, among other things.

VBA with Microsoft Excel Online Training Course Content
  • Introduction to VBA
    • What is VBA, Advantages of Automation
    • VBA user interface
    • Project Explorer
    • Properties Window
    • Tool Bars , Debugging
    • Recording Macros, Editing Macros
  • Introduction to Programming
    • Operators and Operands
    • variables and Data types
    • Introduction to Procedures , Functions and Sub Procedures
    • Introduction to Objects
  • VBA-Excel Spread sheet Objects
    • Working with rows, columns and cells (Formatting, Alignment, Styles)
    • Workbooks , worksheets (Creating, Modifying, Deleting)
  • Introduction to Functions
    • Creating new functions (procedures)
    • Creating Add-in's
    • Review of Built-in Functions
  • Introduction to
    • Conditions ( if , OR , AND) – nested if's , multiple if's
    • Loops – (For, while , do-while) , Options (Select)
    • Strings , Dates and time Functions
    • String Functions – Left, Right, Mid, Instr, Len, Char and Concatenate
    • Date Functions
  • Creating User defined Functions
    • Creating Simple User Defined Functions
    • Exporting Functions as Add-ins
    • Creating Multiple procedures (calling from one function to another function)
  • Working with Sub Procedures
    • Creating Sub Procedures , Events
    • Working with Multiple Sub Procedures
    • Working with pivot tables using with Macros
    • Working with Chartsusing with Macros
  • Security
    • Securing the workbooks and worksheets with VBA
    • Securing Source code (VBA Project)
    • Export and Import
  • Introduction to Forms and Controls
    • Creating Forms , Adding Form controls
    • Messages and alerts , inputs using dialog boxes
  • Interactive Forms - Advance
    • Introduction to Forms
    • Introduction to Controls
    • Creating Forms
    • Creating Multiple forms
    • Page controls , Events
    • Uploading / Importing Data from various sources using Forms
    • Data entry with Forms
  • Introduction to VBA with other MS-Applications
    • Creating Macros in MS-Word
    • Creating Macros in MS-Access
    • Projects (practice in class):
    • Creating Macro to format excel worksheets.
    • Extracting data from one workbook to another worksheet, workbook.
    • Writing own sum, count, max, average functions.
    • Interactive calculator with form (Simple interest).
    • Updating data to excel using forms.
    • Refreshing Pivot tables data with buttons.
    • Consolidation of multiple excels workbooks.
    • Creating Excel Templates using macros.
    • Multi-Page Control, Creating a wizard using the Multi-Page Control.
    • Creating workbook with domain authentications.

Please Register with us