Your cart is empty.
Keep shopping
6 Excel VBA Practice Problems
New
121 students
6 Excel VBA Practice Problems
Hands‑On Practice with Real‑World Excel VBA Challenges
Created byMo Mehta
Last updated 4/2026
English
What you'll learn
- As a student or experienced professional, you will be able to practice creating macro-enabled workbooks that meet a wide range of needs.
- As a student or experienced professional, you will handle a wide variety of tasks with Excel VBA.
- As a student, you will have a set of problems to act as a supplement to learning Excel VBA.
- As an experience professional, you will be able to quickly broaden your current Excel VBA skills to meet various needs.
Explore related topics
Course content
8 sections • 14 lectures • 1h 32m total length
Requirements
- Will need some previous experience in Excel VBA programming or are currently taking another course and using this course for practice problems.
- Will need access to the Excel App or the desktop version of Excel. Excel Online will not work.
- For high data workloads, you may need the 64-bit version of Excel (but not a requirement for this course).
- Excel has some limitations on Mac OS
- Will need PowerQuery (available in Excel 2016 or later, or as an add-on for 2010 or 2013)
- Ability and permissions to save macro-enabled Excel files (.xlsm)
Description
6 Excel VBA Practice Problems
Instructor: Mo Mehta, Data with Mo Mehta LLC
Want to strengthen your Excel VBA skills by actually using them?
This course is a focused set of six hands‑on Excel VBA practice problems designed to help you apply core VBA concepts in realistic, practical scenarios. Instead of long lectures or theory-heavy walkthroughs, this course emphasizes learning by solving.
Each problem mirrors common logic patterns and automation challenges you’ll encounter when building real Excel tools — from decision logic and randomness to structured data organization and reporting.
This course is ideal if you’ve learned Excel VBA basics and now want targeted practice to solidify your skills.
What You’ll Practice
Through six guided problems, you’ll build VBA solutions such as:
A Random Quote Generator
Learn how to work with randomness and user interaction.A Decision Tree Tool
Practice conditional logic and branching workflows using VBA.A Calendar Generator
Apply date logic, looping, and layout control within Excel.A Password Generator
Reinforce string manipulation, randomness, and validation logic.A Task List Manager
Build a simple, structured system for tracking and updating data.A County Health Report
Practice cleaning, manipulating, and presenting data visually.
Each problem focuses on thinking through the solution, not just copying code.
Requirements
• Desktop version of Microsoft Excel
• Ability to save macro-enabled xlsm files
• Power Query (available in Excel 2016 or later, or as an add-on for 2010 or 2013)
About the Instructor
I’m Mo Mehta, founder of Data with Mo Mehta LLC, and I’ve been using Excel VBA for over a decade to build analytics, automation, and data integration tools in healthcare and beyond. My goal with this course is simple — to give you quick, valuable, and broad Excel VBA practice.
Who this course is for:
- Students and Experienced Excel VBA Developers