Microsoft Excel VBA Pro (3 Days) & CPD Certificate - Nottingham

Infero Training Ltd

Microsoft Excel VBA Course Content

• Lesson 1: Getting Started
  • Topic 1A: Introducing Visual Basic for Applications
  • Topic 1B: Displaying the Developer Tab in the Ribbon
  • Topic 1C: Recording a Macro
  • Topic 1D: Saving a Macro-Enabled Workbook
  • Topic 1E: Running a Macro
  • Topic 1F: Editing a Macro in the Visual Basic Editor
  • Topic 1G: Understanding the Development Environment
  • Topic 1H: Using Visual Basic Help
  • Topic 1I: Closing the Visual Basic Editor
  • Topic 1J: Understanding Macro Security

• Lesson 2: Working with Procedures and Functions
  • Topic 2A: Understanding Modules
  • Topic 2B: Creating a Standard Module
  • Topic 2C: Understanding Procedures
  • Topic 2D: Creating a Sub Procedure
  • Topic 2E: Calling Procedures
  • Topic 2F: Using the Immediate Window to Call Procedures
  • Topic 2G: Creating a Function Procedure
  • Topic 2H: Naming Procedures
  • Topic 2I: Working with the Code Editor

• Lesson 3: Understanding Objects
  • Topic 3A: Understanding Objects
  • Topic 3B: Navigating the Excel Object Hierarchy
  • Topic 3C: Understanding Collections
  • Topic 3D: Using the Object Browser
  • Topic 3E: Working with Properties
  • Topic 3F: Using the With Statement
  • Topic 3G: Working with Methods
  • Topic 3H: Creating an Event Procedure

• Lesson 4: Using Expressions, Variables, and Intrinsic Functions
  • Topic 4A: Understanding Expressions and Statements
  • Topic 4B: Declaring Variables
  • Topic 4C: Understanding Data Types
  • Topic 4D: Working with Variable Scope
  • Topic 4E: Using Intrinsic Functions
  • Topic 4F: Understanding Constants
  • Topic 4G: Using Intrinsic Constants
  • Topic 4H: Using Message Boxes
  • Topic 4I: Using Input Boxes
  • Topic 4J: Declaring and Using Object Variables

• Lesson 5: Controlling Program Execution
  • Topic 5A: Understanding Control-of-Flow Structures
  • Topic 5B: Working with Boolean Expressions
  • Topic 5C: Using the If...End If Decision Structures
  • Topic 5D: Using the Select Case...End Select Structure
  • Topic 5E: Using the Do...Loop Structure
  • Topic 5F: Using the For...To...Next Structure
  • Topic 5G: Using the For Each...Next Structure
  • Topic 5H: Guidelines for use of Control-of-Flow Structures

• Lesson 6: Working with Forms and Controls
  • Topic 6A: Understanding UserForms
  • Topic 6B: Using the Toolbox
  • Topic 6C: Working with UserForm Properties, Events, and Methods
  • Topic 6D: Understanding Controls
  • Topic 6E: Setting Control Properties in the Properties Window
  • Topic 6F: Working with the Label Control
  • Topic 6G: Working with the Text Box Control
  • Topic 6H: Working with the Command Button Control
  • Topic 6I: Working with the Combo Box Control
  • Topic 6J: Working with the Frame Control
  • Topic 6K: Working with Option Button Controls
  • Topic 6L: Working with Control Appearance
  • Topic 6M: Setting the Tab Order
  • Topic 6N: Populating a Control
  • Topic 6O: Adding Code to Controls
  • Topic 6P: Launching a Form in Code

• Lesson 7: Working with the PivotTable Object
  • Topic 7A: Understanding PivotTables
  • Topic 7B: Creating a PivotTable Using Worksheet Data
  • Topic 7C: Working with the PivotTable Objects
  • Topic 7D: Working with the PivotFields Collection
  • Topic 7E: Assigning a Macro to the Quick Access Toolbar

• Lesson 8: Debugging Code
  • Topic 8A: Understanding Errors
  • Topic 8B: Using Debugging Tools
  • Topic 8C: Setting Breakpoints
  • Topic 8D: Stepping through Code
  • Topic 8E: Using Break Mode during Run mode
  • Topic 8F: Determining the Value of Expressions

• Lesson 9: Handling Errors
  • Topic 9A: Understanding Error Handling
  • Topic 9B: Understanding VBA's Error Trapping Options
  • Topic 9C: Trapping Errors with the On Error Statement
  • Topic 9D: Understanding the Err Object
  • Topic 9E: Writing an Error-Handling Routine
  • Topic 9F: Working with Inline Error Handling

.

Microsoft Excel VBA Course Objectives

Upon completion of this Microsoft Excel VBA course, you will have gained the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations.

This Microsoft Excel VBA course will appeal to students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. It may also appeal to students who already have knowledge of the basics of Excel or VBA, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Before taking this Microsoft Excel VBA course, students are recommended to have equivalent proficient knowledge of Microsoft Excel. Knowledge of Pivot Tables helpful but not required.

Being proficient in Microsoft Excel VBA can open the door to many career opportunities such as: Visual Basic Developer and other related career paths.