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 (14 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.
603 students enrolled
$20
Take This Course
  • Lectures 25
  • Contents Video: 1 hour
    Other: 3 mins
  • 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

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

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

Curriculum

Section 1: Introduction
00:50

Introduction to the course

00:29

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

00:52

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

Article

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

Section 2: Setting Up The Macro Environment
01:03

Steps for enabling the developer tab for post Excel 2007 versions

01:27

Information about various macro security settings and which one to chose

01:25

Understanding nomenclature for naming macros

00:51

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

00:54

Various storage spaces where you can store macros

Article

Importance of macro description

Article

File extensions for storing macros

2 questions

Quiz on various macro settings

Section 3: Triggering Macros
03:52

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

Section 4: Understanding The Basics Of Macros
02:02

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

Article

Undertanding various types of references

02:22

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

Macro Shortkeys
1 question
Section 5: Simple Macros
07:37

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

04:27

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

04:09

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

04:18
Macros to fill different colors
03:11

Macro to activate various sheets of the workbook to toggle quickly

03:45

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

Section 6: Complex Macros
06:18

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

04:38

Controlling pivot tables using macros for quick report generation.

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

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

00:59

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