Skip to content
UdemyExcelPaid courseBeginner levelCertificate

Microsoft Excel for Mac 4: VBA macros for Excel - an intro (Udemy.com)

Go from Beginner Level of Excel VBA to Intermediate. Create your own Excel Macros in Visual Basic for Applications.

Created by: Phillip Burton

Last updated December 2024

icon
What you will learn

  • Add the Developer tab and record macros.
  • Adapt macros using the Excel Object Model, so that you can use them in your spreadsheets.
  • Know about variables, and how to use loops and If statements.
  • Interact with Excel - find out how to access the Selection object, and output results using a MessageBox (MsgBox).

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.6 out of 5higher than 63% of them
  • Reviews113#332 of 356 by number of reviews
  • Length3.3 hoursshorter than 73% of them
  • Last updatedDecember 2024more recently than 60% of them

icon
Course Description

Review of the Windows version:

"This is a very good starting point in VBA. But doing this course one realize how extensive and huge VBA is. As always the teacher is great and one feels his in depth knowledge" -- Daniel Sandberg

Welcome to Excel VBA - An Introduction for the Mac. This course delves into the Visual Basic which allows you to automate Microsoft Excel (and other MS Office products).

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.


Microsoft Excel is an extremely powerful tool – and yet most people only scratch the surface of what it can do. In addition to PivotTables, VLookup formulas and the like, you can also automate it. You can add buttons and forms to add interactive features – yet most people don’t even know it’s there. Maybe you have someone in your organization who is an absolute wizard, getting the computer to do things and walking away while it does it. Do you want to be able to do that? Welcome to wizard school – or in other words, Visual Basic for Applications (VBA).

In this course, I’ll assume that you have some fair knowledge of Excel – able to do basic formulas and colour cells and the like – but you don’t need any prior knowledge of VBA or any programming language for that matter. Of course, the more you already have, the better. I’ll take things nice and slowly. Each video will center around one new aspect, or we’ll consolidate what you already know with coding exercises. 

Once you have finished the course, then you will be well on your way to developing your own macros to solve your own problems. And you’ll be able to take your new-found knowledge for use in Word and PowerPoint as well

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Phillip Burton

Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 1,000,000 students and more than 60 video courses, including over a dozen Bestseller courses.

My courses include Microsoft Power BI and Fabric, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. The majority of my courses align with the requirements for official certifications from Microsoft, Oracle, and Tableau - so with a bit of practice, you could enter the exam or assessment and put it on your CV or resume.

I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.

icon
More courses by Phillip Burton

$18.99

$22.99

$22.99

$99.99

$13.99

Free

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.6

113 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Elias Cervantes on 4/6/2026

It's really interesting to me, but I still need to get to understand more about each command and its syntax. But thank you for this course.

By Ian Walker on 6/19/2024

It is a very hard course for a beginner in VBA macros for excel, however the course is well explained in a clear and concise manner by the tutor.

By FAHAD ALSHAREF on 3/23/2024

It is a nice introduction to VBA on Mac. It is not a full intro to VBA but it had enough in it to get me started and I managed to create my first VBA Application to handle one of my repetitive tasks that need a bit more than just recording the steps. This course not a full intro to VBA (it does not cover all the basics) but it's a nice start for a Mc user.

By Cedric Jones on 8/31/2022

So far the material is very easy to grasp. As time goes on I expect things will get a little more complicated but I'm up for the challenge on my new iMac 24 inch.

By Ario Brunet on 4/25/2020

Really enjoyed this course, I feel like I have a great grounding to continue learning more about how to use VBA.

By Myk Deans on 12/31/2019

A good basic starter on VBA for Excel, it allowed me to complete a simple VBA project. However, it doesn't discuss arrays, functions, calling them or handling return values, or any form of error handling, so it's a long way short of a comprehensive guide to VBA. If your aim is a full mastery of VBA then your education dollars may be better spent elsewhere.

By Charlene Tan on 12/16/2019

As a beginner, this was a nice introduction to VBA

By Benjamin R Garber on 8/17/2019

I am trying to learn how to write macro's for my job and we only use Apple products so this course has been very beneficial.

By David Perry on 8/3/2018

Great stuff, starts from zero and gets you ready to make custom macros, both recorded and coded. Only complaint is it ended and I was wanting to continue. I'm going to look now to see if you made a Part II, or "Advanced" course next. Great Instructor.

By Geoff Hawkins on 7/2/2018

Yes - and it matches what is seen on the Mac unlike many other courses and books on VBA ...

Showing all 10 reviews on CourseDuck

Read all 113 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100