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.

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.