Call us at:   1.805.498.7162     1.805.558.9277

Microsoft Excel training options for business, engineering and science Innovative Microsoft Excel software design View our customer list from our over 14 years in business Phone numbers, email address and contact form Learn about EMAGENIT Home page containing upcoming Microsoft Excel classes and other EMAGENIT services Self-study Microsoft Excel manuals for business, engineering and science Microsoft Excel consulting services Microsoft Excel training schedule and prices

Home > Microsoft Excel Workshops > Advanced Excel VBA For Business Self Study > Advanced Excel VBA Manual Outline for Business
Advanced Microsoft Excel VBA Manual Outline

Advanced Microsoft Excel VBA Manual Outline

for Business Professionals

Over 1000 pages of useful Excel VBA programming strategies including an extensive Excel VBA overview, data processing, automated charts, custom worksheet functions, advanced dashboards, userform design, events, database communication and commanding Word and PowerPoint for report generation

 *All business manuals are derived from Microsoft Excel-Aided Business. Therefore depending upon the manual, some modules will not be included.

Microsoft Excel Beginning VBA for Business (Modules 12-15)

Module: Introduction

Key Module Topics:

  • Copyright and support information
  • Mouse terminology
  • Digital manual and example organization
  • Where to find the Excel examples

Module 12: VBA Editor and Module Basics

Key Module Topics:

  • Overview of how VBA can help in business tasks
  • VBA editor overview including VBA project, module and procedure overview
  • Controlling and typing in VBA modules
  • Referencing and integrating VBA projects
  • Using the VBA debugger to debug your code

Module 13: VBA Language Review

Key Module Topics:

  • VBA variables, constants and arrays (declaring, scope and data typing)
  • VBA operators (logical, arithmetic and comparison)
  • Control structures (loops and logic decisions)
  • Overview of Excel objects, properties and methods
  • How to identify and command Excel objects using VBA
  • How to use Excel/VBA on-line help
  • How to use the VBA macro recorder to record Excel business tasks in VBA
  • How to use the Object Browser
  • How to error proof your VBA code
  • How to command Workbook, Worksheet and Range objects using VBA
  • Automated chart construction
  • Data processing techniques
  • Dashboards for Excel

Module 14: VBA Function Procedure Design

Key Module Topics:

  • Benefits of using Function procedures and User Defined Worksheet Functions (UDF's) for business tasks
  • Function procedure and UDF differences
  • How to declare Function procedures and UDF’s in VBA
  • How to create arguments for Function procedures and UDF’s
  • How to call UDF’s from a worksheet formula
  • Calling Function procedures from other VBA procedures
  • Function procedure and UDF procedure interface design
  • How to pass worksheet ranges as arguments to UDF's
  • Returning scalar and array values from UDF’s to worksheet formulas
  • Using VBA and Excel Worksheet functions in your VBA procedures

Module 15: VBA Sub Procedure Design

Key Module Topics:

  • Benefits of using Sub procedures for business tasks
  • Declaring Sub procedures in VBA
  • Creating arguments for Sub procedures
  • Calling Sub procedures from other VBA procedures
  • Executing Sub procedures via the Macro dialog box
  • Executing Sub procedures via shortcut keys
  • Executing Sub procedures via graphics
  • Executing Sub procedures via events
  • Sub procedure interface design
  • Sub procedure design tips
  • Property procedure overview

 

Microsoft Excel Advanced VBA for Business (Modules 16-18)

Module 16: Graphical User Interface and Tool Packaging Design

Key Module Topics:

  • Developing business GUI's and applications in Excel
  • Creating graphics that display business data on the worksheet
  • Assigning VBA Sub procedures to worksheet based graphics
  • Using ActiveX and Form controls to create GUI’s on the worksheet
  • Creating event procedures for controls placed on a worksheet
  • Business wizard overview
  • Using userforms to create business wizards
  • Creating userforms in Excel
  • Creating controls and graphics on userforms
  • Commanding userforms and controls with VBA
  • Business wizard design tips
  • Creating toolbars and menus to control your Excel tools
  • Controlling Excel’s toolbar and menu system with VBA
  • How to create and package Excel tools

Module 17: Commanding Databases and Applications Using VBA

Key Module Topics:

  • OLE automation overview
  • How to command other applications from Excel using VBA
  • How to use CreateObject to control other applications
  • Using DDE with VBA
  • How to use DAO to communicate with Microsoft Access
  • How to use ADO to communicate with Databases
  • How to use ADO to communicate with Microsoft Excel
  • How to use ADO to communicate with Text Files
  • How to use the FileSystemObject to communicate with Windows file system
  • How to open multiple workbook files using the FileSystemObject
  • How to control Window's Shell
  • How to control Microsoft Word
  • How to control Microsoft PowerPoint

Module 18: VBA /ActiveX DLL Programming

Key Module Topics:

  • Object and class review
  • Practical uses of objects
  • Object method and properties overview
  • VB project overview for ActiveX DLL's
  • How to create an ActiveX DLL
  • Creating and naming your class modules
  • Designing object properties
  • Designing object methods
  • Designing object enums
  • Designing object hierarchies
  • How to reference your ActiveX DLL's from a VBA or VB project and distribute them
  • How to create and run your objects from Visual Basic
  • How to create and run your objects from VBA via Microsoft Excel
  • How to package and distribute your Active X DLLs

 

 

 

 

Site Map 

Copyright © 2002-2012 EMAGENIT All Rights Reserved