Excel — Macros & VBA · Course on Udemy

Automate Excel with macros and VBA, no coding experience needed

Start with the macro recorder, move on to writing your own VBA code, and finish with ready-to-use macros for the tasks you repeat every week.

★ 4.5 from 1,911 ratings on Udemy · 122 lessons · 12 hours

Enroll on Udemy →Watch a free lesson first

30-day refund through Udemy · Lifetime access · Certificate of completion

Watch the course trailer (2:43)

Is this course for you?

If a task takes the same steps every time, a macro can do it for you in one click.

You will get the most from it if you…

repeat the same copy, paste and format steps every week
clean up exports from other systems by hand
have heard of macros but never written one
want a skill for your CV that saves real time

By the end you will be able to…

record, run and assign macros to buttons
read and write VBA code in the editor
use IF statements, loops and variables to handle any amount of data
filter and sort data automatically
debug your code when something goes wrong

New to Excel? Start with Excel Tips & Shortcuts first.

What you will automate

Real tasks from the course, built step by step.

01Data entry into a databaseA form that writes new records for you

02Cleaning a messy tableFormatting fixed in one click

03Filtering and sortingRepeatable views, no manual steps

04Navigation buttonsChange a chart type with a click

05Ready-to-use macrosProjects you can adapt at work

What is inside

Four parts, from your first recorded macro to your own VBA projects.

1. Macros without code

How to record and run a macro, assign it to a button or icon, the Personal Macro Workbook, absolute and relative references, and writing effective macros.

2. Starting VBA programming

A tour of the Developer tab, procedures, the VBA language elements, and the common objects, properties and methods you will use every day.

3. Making your code work for you

Worksheet functions inside VBA, IF and FOR statements, variable iteration loops, filtering and sorting with VBA, and the R1C1 reference style.

4. Debugging and projects

Finding and fixing errors in your code, then complete VBA projects and ready-to-use macros.

What students say

Reviews from students of this course.

“I am learning new skills required for a task I’ve been given at work. This course has already been beneficial in making things easier by allowing me to automate a series of easy but time-consuming tasks through macros.”Chris F.

“Great content, simple to the point, clear instructions. Excellent course for beginners in macros and VBA. Well Done!”Dominica E.

“I appreciate the detailed walk-thru, explanations, and the practice files to follow along.”Liza R.

What is included

122 video lessons, 12 hours
Downloadable practice files and code
Lifetime access on any device, including the Udemy app for offline viewing
Certificate of completion
A Q&A section on every lesson
30-day refund through Udemy

Your instructor

Andreas Exadaktylos, MSc in Computer Science, has taught Excel for over 25 years and runs Mellon Training.

More than 80,000 students have taken his courses on Udemy. He also publishes free Excel tutorials on YouTube and on this site.

Questions before you start

Anything else? Write to info@mellontraining.com.

Do I need programming experience?

No. You need to be comfortable with everyday Excel. The course starts with the macro recorder and builds up to writing VBA. If you are brand new to Excel, start with Excel Tips & Shortcuts.

Which version of Excel do I need?

Excel 2016 or newer, or Microsoft 365. The VBA fundamentals have changed little over the years, so most of the course also works in older versions.

Does it work on a Mac?

The course was filmed in Excel for Windows. The interface and shortcuts are sometimes different on a Mac.

Where is the course hosted?

On Udemy. You buy and watch it there, keep it for life, and can learn offline in the Udemy app.

What if it is not right for me?

Udemy offers a refund within 30 days of purchase, under its refund policy.

Can I see a lesson before I buy?

Yes. Watch the free VBA lesson on this site, or the preview lessons on the Udemy course page.

Ready to automate your first task?

122 lessons, from the macro recorder to your own VBA projects.

Enroll on Udemy →