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

This intensive 3 days, hands-on Microsoft Excel VBA programming course is fully Accredited by CPD and helps you to gain comprehensive, practical understanding of Visual Basic for Applications, guiding you from complete novice to advanced levels.

It introduces Excel VBA 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 Microsoft Excel VBA course is suitable for anybody wanting to learn 2019, 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.

You can choose either our Classroom training at one of our venues or Live, Instructor-led Virtual training from the comfort of your home.

.

Benefits of Studying Microsoft Excel VBA with Infero Training:

• 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
• Premier Locations, Latest Tech, Refreshments, OR We Come to You
• 100% Money Back Guarantee & Price Match Guarantee
• Bespoke Courses & Group Discounts from £132 per person

.

Certification

Microsoft does not have a Excel VBA (Visual Basic for Application) Certification, however, if you wish to pursue a Microsoft Certification there is a Microsoft Office Specialist (MOS) certification.

Upon successful completion of the Microsoft Excel VBA 1 day course you will receive an Infero Training certificate. If you continue and complete the remaining 2 days training you will receive a CPD certificate and earn 20 CPD Points.

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 the Excel VBA course, you will have gained the skills necessary to apply VBA to develop macros, work with procedures and functions, forms and control and PivotTable objects.

.

Microsoft Excel VBA Testimonials

I completed the Advanced Excel course and found it so good that I returned to complete the VBA course, By chance both courses happened to be on a 1-1 basis and my tutor Huseyn tailored the course to my needs.

The course was very hands on as most of the course involved using the info learned in class and applying it to data supplied by Infero.

The workbooks provided were clearly illustrated and had a step by step guide to complete each process.

Gerard Cahill (Commercial Accountant) from Specsavers

.

The course was extremely informative and allowed me to gain an understanding of the functions, purpose and impact VBA can have to streamlining programs and processes.

The enthusiasm and genuine interest shown by the instructor contributed greatly to the engagement and overall success of the course - I would highly recommend this and any other Microsoft based courses via Infero to anyone at whichever stage of development you may be!

Rob Carmichael (Senior Market Research Manager) from Vision Express

.

The VBA course I attended with Infero Training was very informative. It provided me with a very useful skillset that I am now using in my current role for many different things. I also now have a much better understanding of current systems that are using VBA. The enthusiasm of the instructor was great and definitely contributed to the overall experience of learning VBA. I would recommend this to anyone of any level of expertise as it highlights how VBA can help in many different ways throughout many different tasks.

Jason (Programme Assistant) from Nottingham CityCare Partnership

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.

Certificate of completion

Digital certificate - Included