Master Class on Excel  Macros & VBA For Beginners - Basic Concepts

Let's Start Macros & VBA

Whenever we talk about Advanced Excel, the 1st thing comes to our mind is Macros. We have heard a lot, but always wish to learn, write and use of macros in our day to day working. Excel Macros or VBA can do our hours work in seconds, most of us feel its too technical and tough to learn. But if we know basic concepts then its very easy to play with macros.

Salient features of the Webinar:

👉 Macro overview and why we need it

👉 Role of Developer Tab

👉 VBA window - Different parts

👉 Let's record - My 1st Macro

👉 Edit recorded Macro

👉 Concept of Absolute and relative

👉 Get macro from web and use it

👉 How to use macro in all files

👉 What is personal macro workbook

👉 10 Free Macro Templates will be provided :        

          1 File_Manager - Manage Folders and subfolders       

          2 Create sheets and Hyperlink too - For any File       

          3 Color Index - To know color of each cell - Easy to sum by color       

          4 Copy paste in to filtered cells only Macro       

          5 Delete blank row macro - For Printing and transformation       

          6 Figure in word rupees macro - Everyone needs it       

          7 Hide and show rows columns based on condition in cell - Smart Look       

          8 Macro to Split each sheet in to separate workbook - Oh, is it possible       

          9 Combine multiple workbook sheets in to one file - Wow     

         10 RDBMerge - My most favorite Addin - It will save 100s of man days

👉 Q&A

Who Should Attend :

For all Excel enthusiasts who want to be Excel Pro and want to automate their processes

Prerequisite : 

An average knowledge of MS Excel, and keen to learn new things

Excel Macros & VBA For Beginners - Basic Concepts

Excel Macros or VBA can do our hours work in seconds, most of us feel its too technical and tough to learn. But if we know basic concepts then its very easy to play with macros.

Course Fee - Rs. 999/- only