This was a great learning experience. Very clear explanations and a logical flow that made complex ideas easy to grasp.
Excel VBA & Macros for Beginners
Learn to automate repetitive spreadsheet tasks and write your own custom scripts, even if you have no prior programming experience.
-
💬
AI instructor
Ask about any lesson and get a clear answer instantly, anytime. -
🕐
Start anytime
No schedules or deadlines — learn at your own pace, whenever suits you. -
🌐
In English
Lessons, tasks and certificate — all fully in your language.
About this course
Course contents
6 modules · 30 lessons · 3h
1
First Steps and the VBA Environment
Set up the workspace and create your first recorded macro.
- What is VBA and Why Use It
Introduction to terminology and the benefits of automation.6 min - Exploring the Visual Basic Editor (VBE)
A tour of the interface where we will write the code.6 min - Security and File Formats
Saving files as .xlsm and safely enabling macros.5 min - Recording Your First Macro
Using the macro recorder to automate a simple action.7 min - Running and Assigning Macros
Launching macros via buttons or the quick menu.6 min
2
Working with Excel Objects
Understand how VBA views and manipulates cells, sheets, and files.
- The Workbook Object
Managing opening, closing, and saving workbooks.6 min - The Worksheet Object
Selecting, renaming, and adding worksheets via code.6 min - The Range and Cells Objects
Writing data and formatting specific cells.7 min - Syntax and Properties
Understanding the 'Object.Property' or 'Object.Method' structure.6 min - Cleaning Recorded Code
Removing redundant code generated by the recorder to make it readable.7 min
3
Logic and Variables
Introduce basic programming concepts to make the code intelligent.
- Fundamental Data Types
The difference between String, Integer, Double, and Boolean.5 min - Declaring Variables (Dim)
How and why to assign names to data within the code.6 min - Mathematical and Logical Operators
Performing calculations and comparing values.5 min - If...Then...Else Statements
Making the code take decisions based on a condition.7 min - Select Case
Handling multiple conditions more neatly than with If.6 min
4
Loops and Dynamic Automation
Effortlessly repeat actions on large amounts of data.
- The For...Next Loop
Repeating an action for a fixed number of times.6 min - The For Each Loop
Iterating through all sheets or all cells in a range.7 min - Do While and Do Until Loops
Repeating actions until a condition is met.6 min - Finding the Last Used Row
Making loops dynamic by automatically finding the end of the data.7 min - Exercise: Looping Through Data
Applying a loop to format alternating rows.6 min
5
Errors and User Interfaces
Making the code robust and easy for others to use.
- Common Error Types
Distinguishing between syntax, runtime, and logical errors.5 min - On Error GoTo
Handling code crashes professionally.7 min - Introduction to UserForms
Creating a custom pop-up window.6 min - Controls: TextBox and CommandButton
Adding text fields and buttons to the form.7 min - Writing Data from the Form to the Sheet
Connecting the interface to the Excel sheet.6 min
6
Best Practices and Final Project
Organizing work and creating a complete solution.
- Standard Modules vs Sheet Modules
Where to write code to keep it organized.5 min - Comments and Indentation
Writing clean code that is easy to read in the future.5 min - Debugging: The F8 Key and Watches
Testing code line by line to find bugs.6 min - Protecting VBA Code
Setting a password to hide your logic.5 min - Optimization: ScreenUpdating
Speeding up macros by disabling screen updating.5 min
Smart Monthly Report Automation
Create a script that opens a raw data file, cleans empty rows, calculates totals using a loop, highlights negative values with a condition, and generates a final report in a new sheet, all triggered by a custom button.
What you'll get
-
📜
Certificate of completion
Add it to your LinkedIn profile -
💬
Personal AI tutor
Stuck on a lesson? Ask your built-in tutor anything, any time. -
🎧
Audio version included
Learn on the go — no screen needed -
♾️
Lifetime access
Come back anytime, no expiry -
📱
Phone or computer
Works anywhere, any device -
💸
14-day refund
No questions asked -
⚡
Short & focused
3h of practical content
Certificate of completion
Every course you complete on PickAClass issues a credential like this — original, with its own code, verifiable by URL, and detailed about what was actually demonstrated.
Reviews (9)
This was a brilliant way to learn! The structure was logical, the pace was spot on, and the examples were super helpful. Highly recommend!
This exceeded my expectations. The lessons flowed logically and the real-world applications were spot on. Great job!
Helpful material. The structure was logical for the most part. Might not be for absolute beginners though.
It's a solid course. The structure is logical and most of the examples were helpful. Could use a few more real-world scenarios though.
Hmm, I'm not sure this is ideal for beginners. Some concepts were glossed over, and the examples weren't always clear.
Thoroughly enjoyed this course. The way the information was presented was excellent, and the practical applications were highlighted effectively. Great job!
Hmm, I'm not sure this is for absolute beginners. It assumes a bit of prior knowledge that wasn't explicitly taught. Some examples were confusing.
It's a good course if you have some prior knowledge. For absolute beginners, some concepts might be a bit challenging. The structure is logical, though.
Learners also took
JavaScript Projects: Build a QR Code Generator Website
JavaScript from Scratch: A Project-Based Approach
Learn Modern JavaScript: Build Real-World Web Applications
Dynamic Web Development with jQuery: From Basics to Advanced Techniques
Frequently asked
What do I need to take this course? +
Just a phone or computer with internet. No installs, no special hardware.
How do I pay? +
By card via Stripe. We don’t store card details — Stripe handles them securely.
Can I get a refund? +
Yes — full refund within 14 days, no questions asked.
How long will I have access? +
Forever. Once you purchase, the course is yours to revisit anytime.
Will I get a certificate? +
Yes. On completion you'll receive a certificate you can add to your LinkedIn profile.
Get 10 courses a month
Members get 10 courses of their choice every month for ₪0. No per-course charges — you pay only the subscription.
- ✓ 10 courses every month
- ✓ Cancel anytime
Renews monthly. Unused courses expire at the end of each billing month.