Microsoft Excel VBA Macros

6.0 CPEComputer Software & Applications

Tired of repetitive Excel tasks? It’s time to automate! This hands-on VBA course will teach you how to write macros, automate workflows, and customize Excel like a pro. Learn to code with ease and make Excel work for you.

VIDEO COURSE

This course is free

Create a free account to enroll and earn CPE. No credit card required.

Create free account Already enrolled? Sign in to continue

About this course

This VBA for Excel Course is a practical introduction to automating tasks and customizing workflows in Excel. Designed for beginners, the course starts with foundational concepts, guiding participants through essential VBA syntax, best practices, and coding techniques. Learners will progress to creating macros, handling variables, referencing worksheets and ranges, and building custom functions.

By the end of the course, participants will have the confidence to automate repetitive tasks, streamline processes, and create dynamic Excel solutions. Through real-world examples and guided practice, this course transforms Excel users into VBA-savvy professionals ready to take their skills to the next level.

What you’ll learn

Upon completion of this course, you will be able to:

VBA Basics: Understand the structure of VBA code, including subs, variables, and best practices for formatting and debugging.
Creating Macros: Learn how to write, save, and execute macros to automate repetitive tasks and streamline workflows.
Referencing Worksheets and Ranges: Master dynamic referencing techniques to make your code robust and adaptable to changes.
Data Manipulation: Automate common Excel tasks like copying, pasting, and clearing data efficiently with VBA.
Error Handling: Develop strategies for handling errors and ensuring your code runs smoothly under different scenarios.
Custom Functions: Build and use custom VBA functions to extend Excel’s capabilities.
Real-World Case Studies: Apply your skills to practical problems, including automating data reports and building interactive tools.

Course content

8 lessons · 49 steps · 3h 30m of video

01LESSON 1Welcome2 items

02LESSON 2Intro to VBA Coding7 items

03LESSON 3VBA Code Basics10 items

04LESSON 4Named Ranges & If Statements8 items

05LESSON 5For/Next Loops & Making our Code Dynamic6 items

06LESSON 6Recording and Manipulating a Macro5 items

07LESSON 7Real-world Case Study9 items

08LESSON 8Conclusion1 item

Locked

Final assessment

Course access is required to take this assessment.

30 questions70% to passUnlimited attempts

On course completion: 6.0 CPE and a certificate

Course details

CPE: 6.0
Field of study: Computer Software & Applications
Course level: Not specified
Delivery method: QAS™ Self Study
Prerequisites: You should have a intermediate knowledge of Excel (e.g. IF statements, VLOOKUP, COUNTIFS, etc.). <strong>If you are not comfortable with Excel, we recommend taking our <a href="https://wisdify.com/bootcamps/online-microsoft-excel-course/">Microsoft Excel Bootcamp</a>.</strong>
Advance preparation: Not specified
Course content: 8 lessons · 49 steps
Assessment: Final assessment · 30 questions · pass 70%
Completion deadline: 365 days from enrollment
Last updated: August 2017
Registration: A free Wisdify account and course enrollment are required.