Excel VBA

VBA is Microsoft’s powerful development tool for creating macros in Excel and other Microsoft Office applications. This course is intended to help all intermediate to advanced Excel users get up to speed quickly with Visual Basic for Applications.

We will cover different features of the Visual Basic Editor interface; show users how to record, edit, debug, and manage macros; and learn about the syntax that VBA uses to create macros.

By the end of this course, users should be comfortable with creating, recording, editing, and debugging a macro; formatting worksheets using macros; creating an interactive worksheet; and performing custom calculations using VBA.

Course Content:

• This course will cover the following concepts:
• Lesson 1: Developing Macros
• Create a Macro using the Macro Recorder
• Edit a Macro
• Debug a Macro
• Customise the Quick Access Toolbar and Hotkeys
• Set Macro Security
• Lesson 2: Formatting Worksheets with Macros
• Insert Text
• Format Text
• Sort Data
• Duplicate Data
• Generate a Report
• Lesson 3: Creating an Interactive Worksheet
• Determine the Dialog Box Type
• Capture User Input
• Lesson 4: Working with Multiple Worksheets
• Insert, Copy and Delete Worksheets
• Rename Worksheets
• Modify the Order of Worksheets
• Print Worksheets
• Lesson 5: Performing Calculations
• Create User-Defined Functions
• Automate SUM Functions
• Lesson 6: Working with the PivotTable Object
• Understand PivotTables
• Create a PivotTable Using Worksheet Data
• Work with the PivotTable Object

Course Prerequisites:

• This course assumes that the user understands the basics of using a Windows-based computer. Students should also be comfortable using the Microsoft Excel 2016 interface, and have a firm understanding of how Excel works and what it is used for.
• Understanding and experience with formulas, functions, and PivotTables within Excel 2016 is strongly recommended. No previous experience with Visual Basic for Applications is required.