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.5 (145 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,243 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 16
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course 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.

What are the requirements?

  • Must have Excel 2013
  • Willingness to learn

What am I going to get from this course?

  • Automate your Excel workload
  • Impress your boss with your Excel wizardry!

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome to Excel 2013: Macros!
01:42

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

Section 2: What is a Macro and when to Use Them?
02:58

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

04:47

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

04:55

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.

Section 3: Let's Explore Visual Basic for Applications (VBA)!
03:39

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.

06:50

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

06:10

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

06:32

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

Section 4: Unlock the True Power of Macros, Starting Here
05:49

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.

04:57

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

08:30

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.

06:41

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.

Section 5: Supplemental Lectures
03:22

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.

Article

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.

Section 6: Was this Course Worth Your Money?
00:52

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.

01:07

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.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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!

Ready to start learning?
Take This Course