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 2:
Excel and the Business Professional
Key Module Topics:
- Discusses how Excel can be used in the business process in the areas of
analysis, information integration, VBA program development, dashboard
development, rapid analysis, team integration and data processing.
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
|
