Microsoft Excel VBA Introduction Course – Classroom
Master the programming language VBA to go beyond advanced Excel use by recording and running Macros, creating Modules, and writing Procedures.
- All Courses
- Microsoft Office
- Microsoft Excel
- Microsoft Excel VBA Introduction Course – Classroom
Course Overview
This day long Excel VBA programming course 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 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
1 Day
Training Options
Classroom
Microsoft Excel VBA Introduction 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
Upon successful completion of this course, students will be able to:
- Work with Procedures and Functions
- Understand Objects
Instructor led, group-paced, 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 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, 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