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.
Goals & Objectives of the course are discussed in brief. This should give you a gist of the course
Structure of the course will be discussed for you to know what the flow of the course will be like
Understanding the basics of Macros to get a feel of what Macros are capable of
Steps for enabling the developer tab for post Excel 2007 versions
Information about various macro security settings and which one to chose
Assign shortkeys to Macros and other things you should know regarding assigning shortkeys
Various storage spaces where you can store macros
Importance of macro description
File extensions for storing macros
Quiz on various macro settings
Learn various ways for triggering macros using the developer tab, record macro dialogue box, QAT & shapes
Difference between recording a macro & actually coding a macro using the Visual Basic Editor
Undertanding various types of references
Accessing the visual basic editor & checking the recorded macros for improvements
Macro to simplify the paste special command which is one of the most used Excel features
Macro to apply various formatting options. Everyone has their own taste when it comes to formatting. Recording a macro can speed up the process.
This video will teach you how to automatically generate templates that you might be creating often
Macro to activate various sheets of the workbook to toggle quickly
Macro to filter based on certain criteria. These buttons can be used like slicer buttons to slice data quickly.
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
Controlling pivot tables using macros for quick report generation.
This to keep in mind while recording macros to make the macros less prone to error while recording
Outro & Thank You
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.