Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 Macros: Automate Your Excel Workload to your Wishlist.

Add to Wishlist

Excel 2013 Macros: Automate Your Excel Workload

Learn how to use the power of Excel Macros to automate and reduce you Excel workload to almost nothing!
4.4 (169 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
10,845 students enrolled
Last updated 6/2015
English
$10 $200 95% off
5 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.
  • Much more - I will be updating this course regularly for the next year with free content!

In addition to the video courses and exercise files, you will have access to me! Come visit me during my office hours on Tuesdays & Thursdays from 10am - 12pm EST. This will give you a chance to ask any questions that you may have, or just stop by to say hello! All you have to do is go to the discussion section of the course and post whatever you'd like me to see.

Who is the target audience?
  • This course is meant for people who know how to use the basic features of Excel and want to unlock it's true power.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Automate your Excel workload
Impress your boss with your Excel wizardry!
View Curriculum
Requirements
  • Must have Excel 2013
  • Willingness to learn
Curriculum For This Course
Expand All 16 Lectures Collapse 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:33

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:11
+
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
About the Instructor
4.2 Average rating
301 Reviews
15,846 Students
4 Courses

We are dedicated to producing high quality educational content for Udemy students. When you enroll in any of our courses, you can be confident that that it will be continually updated with the latest, most accurate information.

Think Forward Training is partnered with experts in many topics including Excel, Matlab, and Musical performance. We have many courses in the works, covering a broad range of topics. We look forward to developing a trusted student-instructor relationship with you!

Report Abuse