Excel Macros and VBA: Automate Your Excel Workload
4.6 (444 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
20,618 students enrolled

Excel Macros and VBA: Automate Your Excel Workload

Learn how to use the power of Excel Macros and VBA to automate and reduce you Excel workload to almost nothing!
4.6 (444 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
20,618 students enrolled
Last updated 8/2015
English
English
Current price: $34.99 Original price: $49.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 1 article
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Automate your Excel workload
  • Impress your boss with your Excel wizardry!
  • Build your Resume by adding Excel Programming to your Skills
Requirements
  • Microsoft Excel
  • Basic Excel Skills (you know what rows and columns are)
Description

If you already use Excel, you know how repetitive and time consuming some tasks can be. This course is designed to teach you how to take those repetitive and time consuming Excel tasks, and make them happen in a click of a button! If you use Excel a lot in your work, this course is essential; it will reduce your workload significantly.

In this course you will learn:

  • What macros are and why you should use them.
  • How to read and edit Visual Basic for Application code, and quickly edit macros.
  • How to make conditional macros that work in a variety of situations.
  • How to create macros that apply effects dynamically to large sets of Excel data.
  • How to save enormous amounts of time by automating your Excel work.
Who this course is for:
  • This course is meant for people who know how to use the basic features of Excel and want to unlock it's true power.
Course content
Expand all 16 lectures 01:09:23
+ Welcome to Excel 2013: Macros!
1 lecture 01:42

This video gives you an overview of what you will learn in this course.

Preview 01:42
+ What is a Macro and when to Use Them?
3 lectures 12:40

This video explians what macros are and how they can be used to drastically reduce your Excel workload.

Preview 02:58

This video shows you even more examples of how macros can reduce your Excel workload.

Preview 04:47

We create our first macro using the macro recorder! This video will show you how to start recording a macro, and what to do every step of the way while recording.

The Macro Recorder Example
04:55
+ Let's Explore Visual Basic for Applications (VBA)!
4 lectures 23:11

This video shows you how to access the code that is generated by the macro recorder. You will also learn how editing the code to fix a macro can be much easier than rerecording a marco.

Overview of Other Techniques: Using VBA
03:39

This video shows you the many ways that you can run macros once you've created them.

The Many Ways to Run a Macro
06:50

This video gives you a brief tour of the Visual Basic for Applications environment, and shows you how to easily recognize code segments.

The VBA Environment and Componets
06:10

In this video, we create a simple macro and edit the code in the Visual Basic for Applications environment.

Creating a Simple Macro
06:32
+ Unlock the True Power of Macros, Starting Here
4 lectures 25:57

This video shows you how to use conditional IF statements in Visual Basic for Applications (VBA) to make macros that change based on the context in which they're run.

Expanding a Macro with the IF Statement
05:49

This video show you when to use absolute and relative references when recording macros.

Understanding when to Use Absolute and Relative References
04:57

This video explains how to use the For Next code structure in Visual Basic for Applications (VBA) to reduce the amount of actions you have to record to a macro.

Using For Next Statements
08:30

This video explains how to use Do While and Do Until loops in Visual Basic for Applications (VBA) to dynamically apply macros that require repetitive actions.

Using Do While and Do Until Statements
06:41
+ Supplemental Lectures
2 lectures 03:53

If you're not familiar with relative and absolute references this video is for you. You will need to know these concepts to take full advantage of macros.

Relative vs. Absolute References
03:22

This is the code to the macro used at the end of lecture 3. It automatically converts a list of clients to a database-like format.

Preview 00:31
+ Was this Course Worth Your Money?
2 lectures 01:59

This video shows you how to leave a review. I like both positive and negative reviews. They let me know what people like and what people don't like.

How to Leave a Review
00:52

This video shows you how to request a refund if you're not satisfied with the course. Please leave a comment to tell to why you're not satisfied, so I can continue to improve my course.

How to Request a Refund
01:07