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