Set Reminder Save for later

Master Microsoft Excel Macros and Excel VBA

Course Material Works in Microsoft Excel

During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.

Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.

Below are a few samples of the projects you will complete by enrolling and participating in this course.

  • Automate placing and formatting a title on a worksheet
  • Interact with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should work
  • Cleaning up multiple Excel Worksheets and prepare the data to be reported on
  • Create a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report Worksheet
  • Automate the creation of Excel Formulas to SUM data up in your Report
  • Working with Excel VBA User Forms
  • Importing Data from External Text Files

Each of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.

So, don’t lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:


Rating 4.4 based on 1,054 ratings
Length 5.5 hours
Starts On Demand (Start anytime)
Cost $11
From Udemy
Instructor Kyle Pew
Download Videos Only via the Udemy mobile app
Language English
Subjects IT & Networking
Tags Office Productivity Microsoft

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

step by step in 27 reviews

The course is very easy to follow because he explains the coding step by step.

Easy to follow step by step explanations which build upon each other.

Fantastic course with useful examples and explained well, step by step.

should have covered more advanced concepts Liked the step by step build up of more complicated procedures.

I like his knowledge and how he easily explain it to understand the procedures Very clear teaching, I really like the step by step method.

Instructions are clear, detailed, and have options for reviewing a step by step process via pdf.

Step by step with clear instructions on what is the meaning of each code The course has been really easy to understand and practical.

Detailed, step by step guide.

so far so in 18 reviews

so far so good.

So far so good, very instructive and helpful Easy to understand and I like how he illustrated using pointers Very easy to learn, very interactive.

Thank you So far so good clear and understandable lecture.

all lectures are clear and direct So far so good.

Straight to the point, plain, and simple So far so good.

So far so good!

So far so good.

So far so good and excited for next chapters Very well explained all the basics Great course!

highly recommend in 16 reviews

Highly recommend.

Highly recommend this course for both its brevity and thoroughness.

Highly recommend it!

Highly recommended instructor.

and for excel in MAC , VB is not a good tool :) from my view Can understand easily the concept of VBA, highly recommended for beginners.

I highly recommend this course for any one starting to learn Excel VBA from scratch.

I highly recommend.

Highly recommend this instructor Kyle!

real world in 12 reviews

The exercises can be directly applied to solve the real world problems.

Just enough to get me feeling like I have some basic understanding of how to approach solving my own real world problems.

All of the information provided is directly applicable to real world scenarios.

If you have a question, he will answer it and work with you to find a solution to your own real world issue with Excel.

Good but need more real world task and automation.

While the examples given are slightly dynamic, they are not dynamic enough for applications in the real world, where the data you are importing can have a different amount of columns, rows, or headers conveying different information.

Nice intro to VBA with real world usage.

There were many additional steps that are necessary to actually make them useful in real world applications.

straight forward in 9 reviews

Easy to understand, especially for users who wish to learn macro and VBA without prior knowledge of programming, and only intermediate excel knowledge Straight forward and introduces to projects and workbooks so there is no confusion.

The course is too slow It is very practical and straight forward to show how to create VBA Macros.

Instructor skills Pretty straight forward and easy to understand!

Very straight forward.

straight forward basic course.

So far the presenter has been brief and to the point and the subject matter is very relevant to want I am trying to learn The exercise was made simple and straight forward.

So far the course is straight forward, to the point, and easy to follow.

Very simple and straight forward explanation with real hands on examples, good entry level course for beginners.

real life in 7 reviews

I was able to, very quickly, put these new skills to work and start improving and building practical workbooks in a real life environment.

It would be nice if there were more real life based problems.

Till now everything is clear for me and seems practical enough The course needs far more real life examples.

He makes the course easy to understand and provides real life examples to actually USE the information.

Easy to understand with real life examples.

Helped me to understand and review a basic VBA language This is course covered all potential real life scenarios.

Great class with real life scenarios Clear and informative!


An overview of related careers and their average salaries in the US. Bars indicate income percentile.

English Language Development, AVID & AVID Excel Teacher $53k

VBA Development Practitioner $54k

MS Access/VBA Developer (SQL and C# a plus!) $59k

MS Access VBA Developer $68k

MS Access / VBA Developer $72k

VBA Developer w/ C# $75k

VBA Programmer $77k

Excel/Access DTS Developers $78k

Developer VBA $80k

Excel VBA Developer $82k

Senior VBA/Access Analyst $93k

VBA Software Developer $110k

Write a review

Your opinion matters. Tell us what you think.


Rating 4.4 based on 1,054 ratings
Length 5.5 hours
Starts On Demand (Start anytime)
Cost $11
From Udemy
Instructor Kyle Pew
Download Videos Only via the Udemy mobile app
Language English
Subjects IT & Networking
Tags Office Productivity Microsoft

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now