Description
Duration: 3 days
VBA (Visual Basic for Applications) allows you to extend the functionality of Microsoft Excel and other Office applications beyond what standard worksheet functions can accomplish. With VBA, you can automate tasks related to collecting, processing, analyzing, and visualizing data. This course provides a practical foundation for writing and working with VBA code in Excel workbooks, including reading and writing data across multiple applications. You will also learn how to package and distribute the macros and functions you build so they can be backed up, transferred, or shared with others.
Target Audience
- Users who want to apply VBA to automate Excel tasks such as pulling data from external sources, cleaning data sets, and performing data manipulation.
- Users who want to build custom worksheet functions that simplify complex formulas and make workbooks easier to maintain and understand.
Prerequisites
- Solid working knowledge of Excel, including writing worksheet formulas, using absolute and relative cell references, formatting cells, and building pivot tables and charts. This level of experience can be developed by completing the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.
What’s included?
- Authorized Courseware
- Intensive Hands on Skills Development with an Experienced Subject Matter Expert
- Hands on practice on real Servers and extended lab support 1.800.482.3172
- Examination Vouchers & Onsite Certification Testing – (excluding Adobe and PMP Boot Camps)
- Academy Code of Honor: Test Pass Guarantee
- Optional: Package for Hotel Accommodations, Lunch and Transportation
With several convenient training delivery methods offered, The Code Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Code Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 5/25/2026 | 5/27/2026 | ||||
| 6/15/2026 | 6/17/2026 | ||||
| 7/6/2026 | 7/8/2026 | ||||
| 7/27/2026 | 7/29/2026 | ||||
| 8/17/2026 | 8/19/2026 | ||||
| 9/7/2026 | 9/9/2026 | ||||
| 9/28/2026 | 9/30/2026 | ||||
| 10/19/2026 | 10/21/2026 | ||||
| 11/9/2026 | 11/11/2026 | ||||
| 11/30/2026 | 12/2/2026 | ||||
| 12/21/2026 | 12/23/2026 | ||||
| 1/11/2027 | 1/13/2027 | ||||
| 2/1/2027 | 2/3/2027 | ||||
| 2/22/2027 | 2/24/2027 | ||||
| 3/15/2027 | 3/17/2027 | ||||
| 4/5/2027 | 4/7/2027 | ||||
| 4/26/2027 | 4/28/2027 |
Learning Objectives
- Identify the core components of VBA and how they apply to solving practical business problems.
- Record VBA macros to handle repetitive Excel tasks.
- Use Excel’s built-in reference tools to look up VBA language syntax and objects within the Excel VBA environment.
- Write VBA code to build a custom worksheet function.
- Find, prevent, and handle errors in VBA code, and improve its overall performance.
- Determine how and when macros are triggered.
- Build UserForm objects to create custom dialog boxes and windows.
- Use VBA to read from and write data to local files and cloud-based services.
- Apply VBA techniques to clean and reshape data.
- Execute external programs and commands from within Excel, and share VBA projects with other users.
Course Outline
Module 1: Applying VBA to Business Problems
Automate Tasks in Excel Using Macros; Understand the Components of Macro-Enabled Workbooks; Set Up the Excel VBA Environment.
Module 2: Automating Repeated Tasks
Create a VBA Macro with the Macro Recorder; Record a Macro Using Relative Addressing; Remove Macros and Modules; Understand When and How to Use the Macro Recorder.
Module 3: Finding Help with VBA
Access VBA Help Resources; Use the Object Browser to Identify Available VBA Objects; Use the Immediate Window to Test Object Properties and Methods.
Module 4: Building Custom Worksheet Functions
Write a Custom Function; Add Decision Logic to Code; Declare and Use Variables; Handle Repetitive Operations in Code.
Module 5: Refining Your VBA Code
Identify and Fix VBA Errors; Handle Runtime Errors Gracefully; Optimize Macro Execution Speed.
Module 6: Managing Macro Execution
Collect Input from the User; Set Up Macros to Run Automatically.
Module 7: Creating Custom User Forms
Build and Display a Custom Dialog Box; Write Code to Respond to Form Events.
Module 8: Working with Files Using VBA
Retrieve File and Directory Information with VBA; Read Data from Text Files Using VBA; Write Data to Text Files Using VBA.
Module 9: Cleaning and Transforming Data with VBA
Automate Power Query Tasks; Reshape Data with VBA and Workbook Functions; Apply Regular Expressions; Handle Errors Found in Data.
Module 10: Working Beyond the Workbook
Launch External Programs and Run Commands; Distribute and Share VBA Projects.
