Microsoft Excel - Power Of Macros In 60 Minutes
4.4 (15 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.
609 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Power Of Macros In 60 Minutes to your Wishlist.

Add to Wishlist

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.4 (15 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.
609 students enrolled
Created by Deep Dave
Last updated 11/2014
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 4 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Have an understanding of how Macros work
  • Will be able to automate most of your repetitive tasks in Microsoft Excel.
View Curriculum
Requirements
  • Basics Of Microsoft Excel
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.

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
01:00:22
+
Introduction
4 Lectures 02:32

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?
00:21
+
Setting Up The Macro Environment
7 Lectures 06:50

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
00:51

Various storage spaces where you can store macros

Macro Storage
00:54

Importance of macro description

Macro Description
00:19

File extensions for storing macros

File Extensions
00:50

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
03:52
+
Understanding The Basics Of Macros
3 Lectures 05:34

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

Macro Recorder Vs VBA
02:02

Undertanding various types of references

Absolute Reference Vs Relative Reference
01:10

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

Accessing Visual Basic Editor & Checking Code
02:22

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
07:37

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
04:27

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
04:18

Macro to activate various sheets of the workbook to toggle quickly

Sheet Activating Macro
03:11

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

Auto Filter Macro
03:45
+
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
06:18

Controlling pivot tables using macros for quick report generation.

Macros for Pivot Tables
04:38
+
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
01:54

Outro & Thank You

Outro
00:59
About the Instructor
Deep Dave
4.3 Average rating
20 Reviews
1,467 Students
2 Courses
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.