Microsoft Excel - Power Of Macros In 60 Minutes

A short step-by-step video series on how to use one of Excel's most powerful tools to automate work, the Macro Recorder.
4.1 (13 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.
604 students enrolled
25% off
Take This Course
  • Lectures 25
  • Length 1 hour
  • Skill Level Intermediate 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 11/2014 English

Course Description

A step-by-step video series that will help you get familiar with Excel's Macro Recorder. Many Excel users across the globe are unaware of the power, macros can bring to their workbooks, and the amount of time that can be saved. This course aims at getting you equipped with enough tips & tricks to automate any repetitive task that you might be performing, using Excel's Macro Recorder.

From teaching Excel to automatically generate templates for you, to controlling objects like AutoFilter, Pivot Tables etc., to work on their own, you will learn it all in a matter of 60 mins.

In this course you will learn -

1) Basics of Macros & Macro recording

2) Elements of the macro recorder

3) Recording Simple & Complex Macros

4) Optimizing a recorded code with some VBA lines

5) Some helpful examples for hands on training

The course contains easy to understand video lessons & other reading material and should take approximately 1 hour to finish. Easy to follow along with the help of exercise files that are provided with lessons wherever required for practice.

Those who have been using Excel and are looking to get into Macros or VBA, this course will provide a good foundation to build upon.

What are the requirements?

  • Basics Of Microsoft Excel

What am I going to get from this course?

  • Have an understanding of how Macros work
  • Will be able to automate most of your repetitive tasks in Microsoft Excel.

Who is the target audience?

  • This course is meant for students who might not have a programming background but are still looking forward to learn Macros. However, having basic knowledge of Excel is required.
  • Students who have not used Excel previously or are not familiar with the basics of Excel, this course might not be the best fit.

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.


Section 1: Introduction

Introduction to the course


Goals & Objectives of the course are discussed in brief. This should give you a gist of the course


Structure of the course will be discussed for you to know what the flow of the course will be like


Understanding the basics of Macros to get a feel of what Macros are capable of

Section 2: Setting Up The Macro Environment

Steps for enabling the developer tab for post Excel 2007 versions


Information about various macro security settings and which one to chose


Understanding nomenclature for naming macros


Assign shortkeys to Macros and other things you should know regarding assigning shortkeys


Various storage spaces where you can store macros


Importance of macro description


File extensions for storing macros

2 questions

Quiz on various macro settings

Section 3: Triggering Macros

Learn various ways for triggering macros using the developer tab, record macro dialogue box, QAT & shapes

Section 4: Understanding The Basics Of Macros

Difference between recording a macro & actually coding a macro using the Visual Basic Editor


Undertanding various types of references


Accessing the visual basic editor & checking the recorded macros for improvements

Macro Shortkeys
1 question
Section 5: Simple Macros

Macro to simplify the paste special command which is one of the most used Excel features


Macro to apply various formatting options. Everyone has their own taste when it comes to formatting. Recording a macro can speed up the process.


This video will teach you how to automatically generate templates that you might be creating often

Macros to fill different colors

Macro to activate various sheets of the workbook to toggle quickly


Macro to filter based on certain criteria. These buttons can be used like slicer buttons to slice data quickly.

Section 6: Complex Macros

Learn how to use macros to automate tasks like sub-totals. Also learn how to make the code more robust to tackle hard coded sheet names and ranges


Controlling pivot tables using macros for quick report generation.

Section 7: Things To Be Taken Care Of While Dealing With Macros

This to keep in mind while recording macros to make the macros less prone to error while recording


Outro & Thank You

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Deep Dave, Microsoft Excel & VBA Teacher

Earning money by teaching Microsoft Excel was never my primary objective, but helping people get better at it certainly was. I started off teaching Excel because of my love for Excel. Watching people do things for hours which could possibly be done in seconds used to pain me, and I could not help it but to go and help them steer in the right direction. The joy on their faces after seeing what Excel was capable of was something that amazed me.

Today, teaching Excel is a very important part of my life. I have conducted many training sessions is various companies in India along with numerous one on one training sessions to train 500+ individuals and helped them get better at Excel.

This one being my first online course, I am looking forward to interacting with quite a few students here and there from different parts of the world and help them get better at Microsoft Excel.

Ready to start learning?
Take This Course