MS Excel VBA

Excel VBA Training covers all areas that you need to know to work successfully with Excel VBA

Topics Covered

Excel VBA Training will cover the following topics -
Lesson 1: Visual Basic Editor (VBE) in Excel
Lesson 2: The Project Window in the Visual Basic Editor of Excel,
Lesson 3: The Properties Window in the Visual Basic Editor of Excel,
Lesson 4: The Code Window in the Visual Basic Editor of Excel,
Lesson 5: Developing & Testing Macros in the VBE,
Lesson 7: Excel Macro Recorder,
Lesson 8: Macros Help and Assistance,
Lesson 9: VBA Security and Protection,
Lesson 10: VBA Coding Tips,
Lesson 11: Dealing with Errors,
Lesson 12: Working with the Application, Workbooks, Worksheets,
Lesson 13: Moving Around the Worksheet,
Lesson 14: Working with Message and Input Boxes,
Lesson 15: Excel VBA Vocabulary to Filter and Sort Data.
Lesson 16: Working with Variables, Statements,Functions,
Lesson 17: Working with external data and SQL,
Lesson 18: Working with Windows and other Microsoft Programs FROM Excel,
Lesson 19: Forms (Userforms) in VBA for Excel,
Lesson 20: Userforms Properties and VBA Code,
Lesson 21: VBA code for Command Buttons,
Lesson 22: VBA code for Labels, Text Boxes, Combo Boxes, List Boxes,
Lesson 23:VBA code for Check Boxes, Option Buttons and Frames,
Lesson 24: VBA code for Spin Buttons, Image Controls etc.
Lesson 25 Project

Who should attend

IT Developers
Advanced Excel Users
Project Managers

Pre-requisites

Knowledge of basic Excel

What you need to bring

1. Photo-id
2. Passport-size photo

Key Takeaways

Learn Excel VBA concepts