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

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 of Excel.

It introduces 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 2016, 2013, 2010 or 2007, as it cover all the aspects and differences between the versions.

.

Benefits of Studying Microsoft Excel VBA with Infero Training:

• Instructor Led course in a small group for maximum knowledge retention
• Comfortable Premises with latest technology
• Microsoft Official Curriculum (optional)
• Free 12 Months Post Course Support
• Certificate of Completion
• CPD Points
• Refreshments

.

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 courses you will receive an Infero Training certificate and earn 20 CPD Points.

.

Microsoft Excel VBA Testimonials from our Website and Google Reviews

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

.

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 enthusiasmand genuine interest shown by the instructor contributed greatly to the engagement and overall successof 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

.

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 Capital One

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.

Certificate of completion

Digital certificate - Included