Microsoft Excel - Power Of Macros In 60 Minutes
4.0 (25 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.
657 students enrolled

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.0 (25 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.
657 students enrolled
Created by Deep Dave
Last updated 11/2014
English [Auto]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 4 articles
  • 9 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
  • Have an understanding of how Macros work
  • Will be able to automate most of your repetitive tasks in Microsoft Excel.
  • Basics Of Microsoft Excel

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.

Who this course is for:
  • 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.
Course content
Expand all 25 lectures 01:00:22
+ Introduction
4 lectures 02:34

Introduction to the course

Preview 00:50

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

Preview 00:29

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

Preview 00:52

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

What Are Macros?
+ Setting Up The Macro Environment
7 lectures 06:57

Steps for enabling the developer tab for post Excel 2007 versions

Preview 01:03

Information about various macro security settings and which one to chose

Preview 01:27

Understanding nomenclature for naming macros

Preview 01:25

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

Assigning Shortkeys To Macros

Various storage spaces where you can store macros

Macro Storage

Importance of macro description

Macro Description

File extensions for storing macros

File Extensions

Quiz on various macro settings

Macro Settings
2 questions
+ Triggering Macros
1 lecture 03:52

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

Various Ways For Triggering Macros
+ Understanding The Basics Of Macros
3 lectures 05:42

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

Macro Recorder Vs VBA

Undertanding various types of references

Absolute Reference Vs Relative Reference

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

Accessing Visual Basic Editor & Checking Code
Macro Shortkeys
1 question
+ Simple Macros
6 lectures 27:27

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

Paste Special Macro

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

Formatting Macros

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

Preview 04:09
Macros to fill different colors
Color Macro

Macro to activate various sheets of the workbook to toggle quickly

Sheet Activating Macro

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

Auto Filter Macro
+ Complex Macros
2 lectures 10:56

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

Sub Total Macro

Controlling pivot tables using macros for quick report generation.

Macros for Pivot Tables
+ Things To Be Taken Care Of While Dealing With Macros
2 lectures 02:53

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

Things To Remember

Outro & Thank You