Microsoft Excel VBA Pro Course – Virtual
Master the programming language VBA to go beyond advanced Excel use by writing Macros, using control structures, developing user forms, and debugging code errors.
- All Courses
- Microsoft Office
- Microsoft Excel
- Microsoft Excel VBA Pro Course – Virtual
Course Overview
This 3 day Excel VBA programming course introduces advanced Excel users to the process of writing and editing Macros in Excel, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
This course is suitable for anybody wanting to learn any version between 2007 and latest 2021. Our courses cover all differences between the versions.
Price
Duration
3 Days
Training Options
Virtual
Microsoft Excel Programming with VBA Course Content:
Lesson 1: Getting Started
- Topic A: Introducing Visual Basic for Applications
- Topic B: Displaying the Developer Tab in the Ribbon
- Topic C: Recording a Macro
- Topic D: Saving a Macro-Enabled Workbook
- Topic E: Running a Macro
- Topic F: Editing a Macro in the Visual Basic Editor
- Topic G: Understanding the Development Environment
- Topic H: Using Visual Basic Help
- Topic I: Closing the Visual Basic Editor
- Topic J: Understanding Macro Security
Lesson 2: Working with Procedures and Functions
- Topic A: Understanding Modules
- Topic B: Creating a Standard Module
- Topic C: Understanding Procedures
- Topic D: Creating a Sub Procedure
- Topic E: Calling Procedures
- Topic F: Using the Immediate Window to Call Procedures
- Topic G: Creating a Function Procedure
- Topic H: Naming Procedures
- Topic I: Working with the Code Editor
Lesson 3: Understanding Objects
- Topic A: Understanding Objects
- Topic B: Navigating the Excel Object Hierarchy
- Topic C: Understanding Collections
- Topic D: Using the Object Browser
- Topic E: Working with Properties
- Topic F: Using the With Statement
- Topic G: Working with Methods
- Topic H: Creating an Event Procedure
Lesson 4: Using Expressions, Variables, and Intrinsic Functions
- Topic A: Understanding Expressions and Statements
- Topic B: Declaring Variables
- Topic C: Understanding Data Types
- Topic D: Working with Variable Scope
- Topic E: Using Intrinsic Functions
- Topic F: Understanding Constants
- Topic G: Using Intrinsic Constants
- Topic H: Using Message Boxes
- Topic I: Using Input Boxes
- Topic J: Declaring and Using Object Variables
Lesson 5: Controlling Program Execution
- Topic A: Understanding Control-of-Flow Structures
- Topic B: Working with Boolean Expressions
- Topic C: Using the If…End If Decision Structures
- Topic D: Using the Select Case…End Select Structure
- Topic E: Using the Do…Loop Structure
- Topic F: Using the For…To…Next Structure
- Topic G: Using the For Each…Next Structure
- Topic H: Guidelines for use of Control-of-Flow Structures
Lesson 6: Working with Forms and Controls
- Topic A: Understanding UserForms
- Topic B: Using the Toolbox
- Topic C: Working with UserForm Properties, Events, and Methods
- Topic D: Understanding Controls
- Topic E: Setting Control Properties in the Properties Window
- Topic F: Working with the Label Control
- Topic G: Working with the Text Box Control
- Topic H: Working with the Command Button Control
- Topic I: Working with the Combo Box Control
- Topic J: Working with the Frame Control
- Topic K: Working with Option Button Controls
- Topic L: Working with Control Appearance
- Topic M: Setting the Tab Order
- Topic N: Populating a Control
- Topic O: Adding Code to Controls
- Topic P: Launching a Form in Code
Lesson 7: Working with the PivotTable Object
- Topic A: Understanding PivotTables
- Topic B: Creating a PivotTable Using Worksheet Data
- Topic C: Working with the PivotTable Objects
- Topic D: Working with the PivotFields Collection
- Topic E: Assigning a Macro to the Quick Access Toolbar
Lesson 8: Debugging Code
- Topic A: Understanding Errors
- Topic B: Using Debugging Tools
- Topic C: Setting Breakpoints
- Topic D: Stepping through Code
- Topic E: Using Break Mode during Run mode
- Topic F: Determining the Value of Expressions
Lesson 9: Handling Errors
- Topic A: Understanding Error Handling
- Topic B: Understanding VBA’s Error Trapping Options
- Topic C: Trapping Errors with the On Error Statement
- Topic D: Understanding the Err Object
- Topic E: Writing an Error-Handling Routine
- Topic F: Working with Inline Error Handling
Upon successful completion of this course, students will be able to:
- Apply VBA to develop macros
- Format worksheets
- Create user-interactive macros
- Work with multiple worksheets
- Perform calculations
Instructor led, group-paced, virtual classroom-delivery learning model with structured hands-on activities.
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £99 per person
This 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, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.
To meet this prerequisite, you can take any one or more of the following courses:
- Microsoft Excel Introduction
- Microsoft Excel Intermediate
- Microsoft Excel Advanced
This course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Choose Your Date & Location
Testimonials
Take Yourself Further With Infero
Top Microsoft Excel FAQs
- Start: 9:00am
- Break: 11:00am
- Lunch: 1:00pm
- Break: 3:00pm
- Finish: 5:00pm