Follow us:

Courses

Microsoft Excel: VBA Programming and Data Wrangling

women coding on a computer
  • https://blackatlastraining.com/wp-content/uploads/2025/10/course-logo-excel-2025-150x150.jpg

  • Microsoft Excel: VBA Programming and Data Wrangling

    Microsoft Office

  • $1245.00

Course Overview

VBA (Visual Basic for Applications) enables you to enhance and extend the capabilities of Microsoft® Excel® and other applications in the Microsoft® 365 application suite. You can use VBA to perform tasks that would be difficult or impossible to do using only worksheet functions, and you can automate a wide range of tasks involving the collection, processing, analysis, and visualization of data. This course will give you a good foundation for understanding, creating, and using VBA in your own Excel workbooks, show you how to work with data across different applications, and how to package the macros and functions you create so you can back them up, move them to other computers, and share them with other users.

Prerequisites

You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Excel Novice, Excel Intermediate, and Excel Advanced.

What You Will Learn

  • 01
    Using VBA to Solve Business Problems
  • Use Macros to Automate Tasks in Excel
  • Identify Components of Macro-Enabled Workbooks
  • Configure the Excel VBA Environment
  • 02
    Automating Repetitive Tasks
  • Use the Macro Recorder to Create a VBA Macro
  • Record a Macro with Relative Addressing
  • Delete Macros and Modules
  • Identify Strategies for Using the Macro Recorder
  • 03
    Getting Help on VBA
  • Use VBA Help
  • Use the Object Browser to Discover Objects You Can Use in VBA
  • Use the Immediate Window to Explore Object Properties and Methods
  • 04
    Creating Custom Worksheet Functions
  • Create a Custom Function
  • Make Decisions in Code
  • Work with Variables
  • Perform Repetitive Tasks
  • 05
    Improving Your VBA Code
  • Debug VBA Errors
  • Deal with Errors
  • Improve Macro Performance
  • 06
    Controlling How and When Macros Run
  • Prompt the User for Information
  • Configure Macros to Run Automatically
  • 07
    Developing Custom Forms
  • Display a Custom Dialog Box
  • Program Form Events
  • 08
    Using VBA to Work with Files
  • Use VBA to Get File and Directory Structure
  • Use VBA to Read Text Files
  • Use VBA to Write Text Files
  • 09
    Using VBA to Clean and Transform Data
  • Automate Power Query
  • Transform Data Using VBA and Workbook Functions
  • Use Regular Expressions
  • Manage Errors in Data
  • 10
    Extending the Programming Environment Beyond the Workbook
  • Run Other Programs and Commands
  • Share Your VBA Projects

Included With The Course

  • Professional textbook (physical and digital)
  • Unused copy of any files referenced throughout the textbook.
  • Certificate of completion signed by the instructor.

Associated Certifications

Not applicable.

Frequently Asked Questions

We understand that you may have questions, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority, and we’re committed to making sure you have all the information necessary for a seamless experience.

No. This course is for users of all levels and focuses on what they call social engineering. Social engineering is the use of deception to manipulate individuals into divulging confidential or personal information that may be used for fraudulent purposes. It aims to inform users of technology-related risks and what they can do to protect themselves and their organization from these risks.