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.

Set Reminder Save for later

Get a Reminder

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

Send to:

Udemy

Rating 4.4 based on 1,194 ratings
Length 5.5 hours
Starts On Demand (Start anytime)
Cost $9
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

According to other learners, here's what you need to know

step by step in 29 reviews

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

Step by step learning!!!!!

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.

Step by step with clear instructions on what is the meaning of each code PERFECT!!

So far so good, very instructive and helpful Clear and easy step step by step, a little too basic at the start.

very good This guy is good Detailed, step by step guide.

Read more

so far so in 21 reviews

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.

Excellent course so far so good Articulate explanation.

Good detailed explanation So far so good!

excellent Till now everything is clear for me and seems practical enough So far so good Very good course to learn the basic function, get some topics to tech interviews and develop self-confidence in coding!

so far so good it can be more straight forward, people don;t have time Great Awesome for the beginner to VBA!!

So far so good!

So far Perfect (y) So far so good and excited for next chapters This is awesome.

Read more

highly recommend in 20 reviews

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.

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

Highly recommend.

I will highly recommend Ely's class.

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 in 13 reviews

Helped relearn VBA and apply in real world projects.

Your exercises are great for understanding the real world applications of Macros and VBA Really, really good Kyle!!

I have a number of relevant real world applications that I will apply this stuff to.. Quite enlightening, concepts clearly explained Great course for Macro users This is a good intro course.

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

Good but need more real world task and automation.

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

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.

Read more

straight forward in 9 reviews

Straight forward and introduces to projects and workbooks so there is no confusion.

Very straight forward.

Up to this point it is too basic 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.

Pretty straight forward and easy to understand!

Read more

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.

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

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.

Udemy

Rating 4.4 based on 1,194 ratings
Length 5.5 hours
Starts On Demand (Start anytime)
Cost $9
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