Skip to content
Write a review
UdemyExcelPaid courseAll LevelsCertificate

Excel VBA: How to Write Macros Like a Professional (Udemy.com)

Learn how to write real-world Excel VBA Macros from scratch. No experience required!

4.5
2,174 reviews

Created by: Paul Kelly

Last updated July 2022

icon
What you will learn

  • Learn little-known techniques used by the top professionals
  • Over 70 example Macros for you to use in your own projects
  • Discover the best method to access a worksheet and the ones you should avoid
  • Learn how to use Intellisense to help you write your code
  • Learn how to supercharge your Excel experience using Loops
  • How to resolve errors quickly and painlessly
  • Learn programming techniques you can use in any programming language
  • Learn When to use "If" and when to use "Select"
  • Learn the 4 Loops of Excel and when to use each one
  • How to test your output before writing to a worksheet
  • Discover how to protect your code against users changing the worksheet name
  • Learn how to use the Compiler to check for errors before you run
  • Learn the best way to use Range, Cells and Offset to access the cells
  • Learn how to easily format any cell or range

How it compares

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

  • Rating4.5 out of 5higher than 39% of them
  • Reviews2,174#111 of 356 by number of reviews
  • Length4.9 hoursshorter than 55% of them
  • Last updatedJuly 2022earlier than 60% of them

icon
Course Description

September 2018 Added New Content!

How to Copy and Filter Data using Excel VBA

This new section comes with 13 Exercises plus full solutions to help you practice and reinforce what you have learned.

-----------------------------------------------------------------------------------------------------------------

April 2018 Added New Content!

Learn how to build an entire Excel VBA application from start to finish. In this brand new section you will see techniques not taught in any other Excel VBA course. 

This new section(number 15) contains proven principles and little-known techniques that will help you build an application in a fraction of the time it would normally take you. 

You will also learn tips and tricks that will reduce your errors, make your code more organised,  and make your applications easier to maintain and update.

This is the only Excel VBA course that shows you first hand, a professional developer creating a VBA application from scratch. 

-----------------------------------------------------------------------------------------------------------------

January 2018 Added New Content!

Using Arrays in Excel VBA: 6 brand new lectures.



FINALLY! A Way To Write Excel VBA Like a Professional

If you think the top Excel VBA programmers are smarter or more gifted than you, then you're mistaken. Truth is, they use dozens of proven programming principles.... little-known techniques that are completely unknown to most VBA users. What are these principles? How can you learn them? And how can you use them to create your own Macros? In this course, Paul Kelly teaches you dozens of must-have secrets that he learned during his 20+ years as a professional software developer, including 

*How To Easily Open Any Workbook - I provide the code, You can use it everywhere!

* Why using Loops can increase your productivity exponentially - Start using them immediately

* How To Create a Real-World VBA Project - A step-by-step guide through a Fruit Sales example project

* The Error Translator Table - An easy way to resolve errors that should have been written years ago

* Which worksheet method to use - Your code will still work even if the user changes the sheet name!

* How to easily test the output of your macros - It's childs play to write values to this Window

* How To Quickly Create Solid Excel Macros - Tons of examples you can "steal" for yourself.

* The In Built VBA Tools That Help You Easily Find Bugs - If you think you would make a good detective then you may really enjoy this

* How to Easily Format any Cell - Changing a cells font, color, format is so simple you could do it now.

* These "Evil" Workbook types should never be used - Do You Use them?

* And Much More. 

Remember if you are not happy with the course for any reason you can get a FULL REFUND within 30 days - no questions asked!!!
Read More All Levels All Levels product length iconTime: 4.9h

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.

Get the Udemy discount

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

Paul Kelly

Paul Kelly has written over a million lines of code in his 20 year software development career. He has worked for the largest insurance company in the UK, was a senior software consultant for one of the biggest Car Rental Companies in the world and has built card processing systems for a number of leading financial institutions.

In recent years a great deal of his work has been building advanced Excel applications and training Excel users to get the most from Excel Macros in very competitive environments.
Paul has built a number of VBA tools including an automated code generator, a formula version tracker, broken link identifier, module version control and many more.

When not writing code he likes to travel around South America, try his luck at Poker and follow he favourite team in the ancient Gaelic sport of hurling.

Read More

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

2,174 ratings on Udemy

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

Write a review

By Kaustubh Pujari on 7/21/2022

This is a very good course covering all the basic building blocks of VBA. I have done this course after completing two other VBA courses on Udemy by other well selling trainers. I would strongly recommend this course to any one wanting to start the VBA journey. Do this course by 'Paul Kelly' first and then proceed with any other courses on Udemy. Paul is also quick in responding to the queries posted. However I am deducting half star from the course. It is because the course has only one dummy project. Paul should add more real life application projects. For example preparing a Dashboard with VBA automation in which the source or base data changes at a set frequency (daily, weekly, monthly etc) and with one click report is ready. Add to it how to automate it with making a PowerPoint + pdf report, how to automate mass mailing etc. Also one singular pdf downloadable file covering entire course notes will help. However these are not downsides but suggestions to further enhance the course. Alternately Paul can think of adding another course which solely focuses on Practical application developments.

By Charis Ching Yongyi on 12/3/2021

This course was relatively well-structured and there are some useful resources given as well. However, I found it a bit difficult to follow the last section on building an application even as I followed the trainer's code line by line. Being a beginner, it was hard for me to grasp the nuances in syntax my code had some errors which I could not debug on my own. Nonetheless, it has exposed me to several useful VBA concepts.

By Apoorv Verma on 11/21/2020

Please put in more mini exercises. I learn by doing more than merely hearing. After loops section you should have added exercises.

By Shivapriya Subramaniam on 10/21/2020

the explanation given is excellent .and step by step guidelines is easy to understand the course in a very good way.

By Ali BinHussain on 10/11/2020

As for now going with basics in very smooth way to prepare you for the next lessons; will vest at the end of the course to add evaluation

By Tina L Graham on 9/25/2020

Thank You for allowing me to take on your course Paul you are a wonderful Instructor leading the way of learning so much about VBA Macros.
Learning how to build a VBA application from start to finish, tips on reducing my errors to make my code more organized on maintaining and updating. I discovered using 4 loops and how to use the compiler to check for errors before you run followed by the value of the letter I entering the loop. There are over 70 Macro examples to play around with and use for in projects and to be sure is the Developer tab is visible.
Thanks for taking the extra time on sharing when and why to use Arrays which is important and helpful on saving time, while bringing up the shortcut needing to create Macros in a new workbook.
This course I highly recommend to everyone.
Thank You,
Tina Graham

By Haris Karamovic on 9/24/2020

I didn't expect this. I try and give a chance, but the course is not as the title says, "How to write macros like professional.".
This course is for beginners, and there is nothing professional in this course. Some codes are not working, and we have corrupted documents.

By Madhukar Bharadwaj on 9/19/2020

Not sure need to move on for further videos.

By Vaishali Yadav on 9/8/2020

its good

By Omar E Ruiz on 9/2/2020

It is a good match for my needs

By Anonymized User on 8/22/2020

The videos are very short and concise. Excellent content.

By Pijush Chandra Biswas on 8/22/2020

I have found the VBA application very good. If There are two more applications, it would be better. Thank you.

Showing 12 of 244 reviews

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 : 90 / 100

Excel VBA: How to Write Macros Like a Professional
Visit course on Udemy Write a review
  • Video Duration: icon 4.9h
  • Price: See price on Udemy
  • Provider: icon Udemy
  • Updated: icon July 2022
  • Level: All Levels All Levels
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com