Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - Power Of Macros In 60 Minutes
Rating: 4.2 out of 5(28 ratings)
668 students

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.
Created byDeep Dave
Last updated 12/2014
English

What you'll learn

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

Course content

7 sections • 25 lectures • 1h 0m total length

  • Course Introduction0:50

    Introduction to the course

  • Goals, Objectives & Prerequisites0:29

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

  • Course Outline0:52

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

  • What Are Macros?0:23

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

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

Report abuse