Automating Excel Functions and Routinces with VBA in Microsoft Excel

• Describe the Essential VBA Language  Elements
• Distinguish between VBA Sub and Function Procedures
• Name and Describe Looping techniques/commands
• Use the Excel Macro Recorder
• Create Macros with Range Objects
• Control flow of Sub and Functions Procedures with Decisions and Looping
• Create Automatic Procedures and Events
• Apply Error-Handling Techniques
• Use Bug Extermination Techniques
• Create Simple Dialogue boxes for data input

Unit 1: What  Is VBA?
Unit 2: Jumping Right In 
Unit 3: Working in the Visual Basic Editor 
Unit 4: Introducing the Excel Object Model
Unit 6: Using the Excel Macro Recorder
Unit 7: Essential VBA Language  Elements
Unit 8: Working with Range Objects
Unit 9: Using VBA and Functions
Unit 10: Controlling Program Flow and Making Decisions
Unit 11: Automatic Procedures and Events
Unit 12: Error-Handling Techniques
Unit 13: Bug Extermination Techniques
Unit 14: VBA Programming Examples
Unit 15: Simple Dialog Boxes

This course is intended for Programmers/Developers, Managers in small / medium enterprises and people who work with Excel intensively in positions where automation of Excel tasks is imperative such as Accountants, Actuaries, Financial Controllers, Project Managers, Scientific personnel that wishes to build macros to automate routines

Lecture, discussion, demonstration and practice.

Participants should have a very good knowledge of Excel.