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 and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.4 based on 1,437 ratings
Length 5.5 total hours
Starts On Demand (Start anytime)
Cost $12
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

Send to:

Similar Courses

What people are saying

step by step

Thank you for the practice worksheets and step by step approach!

Liked the step by step build up of more complicated procedures.

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

Very clear teaching, I really like the step by step method.

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

This course is extremely beneficial and the instructor speaks clearly and goes step by step through the material making things easy to understand every step of the way!

Excellent value for money as included in the course are 7 projects with step by step guidance and full VBA codes provided.

I love the step by step instructions and I like the first project.

Very well explained and the step by step instructions will have you writing VBA code with no previous experience.

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

Thanks Kyle It's a great experience as a beginner to learn this VBA from Kyle Instructions are clear, detailed, and have options for reviewing a step by step process via pdf.

Step by step we are learning a lot.

Great lectures so far overall Great instructor, very clear step by step course.

The way the tutor takes step by step is really helping me understand the concept better!

Read more

so far so good

So far so good.

He makes the learning process exciting Thank you Excellent So far so good!

Cant wait to make a difference in terms of time savings, etc Nice so far so good sounds like he is selling versus teaching.

So far so good I am strongly learning and I am looking forward to see in future how I can intergrate VBA with Jira as such to pull data for reporting.

so far so good.

So far so good!

So far so good, very instructive and helpful This course is really worth to learn There has not been much new stuff that i am learning Great communicator, and well structured course!

Simple step by step instruction which is both easy to learn and replicate Till now everything is clear for me and seems practical enough So far so good.

So far so good Kyle made Excel fun Very detailed and clear Great for someone new to VBA This is amazing....

Perfect Simple and straightforward Since now, it is great So far so good!

easy to understand So far so good.

so far so good Easy to follow along...clear instructions.

So far so good and excited for next chapters I learned how to records order on macro.

Easily explained Awesome Pretty good macro tips So far so good ..!

Read more

highly recommend

I highly recommend it.

I would highly recommend this course to anyone looking to learn VBA coding.

I highly recommend this course to anyone who wants to take the capabilities of Excel to a whole new level.

This is highly recommended for basic macros and visual basic learnings for newbies even with zero programming knowledge.

Highly recommended course to learn Basic macros and visual basics.

Highly recommend.

100% Highly Recommended!!

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

I will highly recommend Ely's class.

I highly recommend.

I would highly recommend this course for anyone trying to learn VBA.

Highly recommend this instructor Kyle!

This course was fantastic and I highly recommend it to anyone interested in developing their Excel VBA skills.

Highly recommend this course for both its brevity and thoroughness.

Read more

real world

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

Your exercises are great for understanding the real world applications of Macros and VBA i like and enjoy it very much.

Helped relearn VBA and apply in real world projects.

I have a number of relevant real world applications that I will apply this stuff to..

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.

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

Nice intro to VBA with real world usage.

Gets you some really neat things, but I'm guessing in the real world I'm going to google up a bunch of the stuff I need.

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.

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

Now I can play with more complexity :) Clear explanations with real world projects so you can start applying what you learned immediately.

Good but need more real world task and automation.

Read more

easy to follow along

Kyle is a great instructor and his descriptions and details are very easy to follow along with.

simple language and easy to understand for beginners Easy to follow along because the instructor is energetic and gives step by step instructions.

Easy to follow along Excellent great course Very clear delivery style & short lectures make the work load manageable.

Easy to understand Excellent course Very easy to follow along Great quality The course seems to be really good so far.

Easy to follow along and pause when needed to catch up - data files for exercises easy to download and comprehend.

Read more

day to day

Yes, it taught me new skills that I can definitely apply to my day to day work.

It will really solve a lot of problem which one faces in day to day corporate life.

Excellent Explanation and Even person not coming from Programming background will peak up this VBA skill super fast.And i can say this is the best VBS Course for Excel Automation.And Instructor has put some real use case that User will face in day to Day Life.Which is very much expected.

Examples are related to day to day task which any office worker will need to do.

It was easy enough to copy the examples given but I felt there was no foundation to apply this knowledge to other examples, such as those found in my day to day work.

Read more

straight forward

Very straight forward.

It is very practical and straight forward to show how to create VBA Macros.

Up to this point it is too basic straight forward basic course.

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.

it's really helpful it can be more straight forward, people don;t have time So far, so good!

Pretty straight forward and easy to understand!

Read more

real life

YOU EXPLAIN THINGS IN BEST POSSIBLE WAY DELIVER AND CONTENT ARE GOOD PLEASE INCLUDE MORE REAL LIFE EXAMPLES I'm a beginner to VBA and I would say that the projects and explanation given are brief and easy to understand.

I just wish he would provide more variables in the projects so I could adapt it to real life.

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

Easy to understand with real life examples.

The course needs far more real life examples.

This is course covered all potential real life scenarios.

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

Thank you :) Great class with real life scenarios Getting hooked each topic.

Read more

lines of code

In the end, couple of lines of code were not working for me somehow.

Where lines of code did not work because he was coding on a windows pc and I needed specific lines of code that only worked on a mac.

It does teach few functions and lines of codes for very specific tasks but doesn't teach VBA language and its structure.

I enjoyed how each module would start out with simple lines of code, making it easier to grasp the concept, which became more complex as the module progressed further.

Read more

only thing

The only thing I can say is that I was having difficulties at times with view certain sections.

The only thing I would recommend is to state the thought process as to how to get to the conclusion of using a specific instructions.

Great so far...the only thing that could be explained a little better in my opinion is the errors that occur if code is not written correctly...aka the automatic capitalization and blue font if written correctly and what to look out for when organizing and writing basic code.

Before taking this course, the only thing I can code was "Hello World".

The only thing the guy teaches is how loop that code or execute the code he already written.

Read more

logic behind

It was just basically "use this function" without any explanation as to the logic behind it.

I personally could use a bit of extra explanation over the VBA coding and the logic behind it, sometimes I feel I goes straight to what the code should be but does not clarify the reason behind.

I purchased this course as I felt the lectures on VBA and Macros in the Excel from Beginner to Advanced course were good but lacked depth and lacked an explanation of the underlying logic behind VBA, explanations I hoped would be included in this course.

Read more

rather than

Also, some videos started toward the end of the session rather than the beginning.

It was nice that he made a point of teaching you the thought process behind how the code works rather than just throwing VBA at you.

Also it would be better if different steps could be merged into one single video rather than keeping multiple short videos.

Always feel I am learnimg Eng rather than the course comtemts.

Read more

Careers

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,437 ratings
Length 5.5 total hours
Starts On Demand (Start anytime)
Cost $12
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