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
Who Should Attend :
For all Excel enthusiasts who want to be Excel Pro and want to automate their processes
An average knowledge of MS Excel, and keen to learn new things
Obtain a digital certificate for completing this course
Get access to the working and business solution files
90 DAYS ACCESS
Get access to the webinar recording for 3 months
Get answers to all your queries
Click on 'Enroll Now' button and do Signup first.
After Signing up go for payment method.
After payment, your course has been added in your Dashboard.
It's Done Now.
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. 500/- only