Microsoft Excel VBA Introduction (1 day) & CPD Certificate - Nationwide

This intensive 1 day Microsoft Excel VBA programming course is part of our 3 days Advanced course, hands-on fully Accredited by CPD course. It introduces advanced Excel users to the process of writing and editing Macros in Excel.

No prior programming experience is required. You will learn how to Record a Macro, Run a Macro, create a Standard Module, create a Sub Procedure, create a Function Procedure, create an Event Procedure and much more.

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 Visual Basic for Application (VBA) Certification, however, if you wish to pursue a Microsoft Certification there is a Microsoft Office Specialist (MOS) certification.

Upon successful completion of the Visual Basic for Application (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

.

Microsoft Excel VBA Course Objectives

Upon completion of the VBA course, you will gain basic VBA skills to record and edit macros, learn to work with procedure and functions, and understand 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 be introduced to 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 roles and other related career paths.

Certificate of completion

Digital certificate - Included