Microsoft Excel VBA & Macro Basics

Overview:

You are struggling and killing huge times every day to do your daily excel works to fulfill your management’s requirements. You can automate your Excel activity using VBA & Macro and reduce your workload those you are doing repeatedly.

The content of this training has been designed thinking that you have no prior programming knowledge but you want to automate your excel action/activity that will work for you. So, we will start the session from the very beginning of VBA and Macro in Excel.

In this one hour, we will do project-based MACRO and VBA workings taking the most used essential coding so that your MACRO and VBA fear is disappeared. After completing this training, you will be able to record the macro, write VBA script, change script in VBE window and assign the action with button or objects and you can work MACRO and VBA related work independently. Then you will show the magic of Excel automation. You will also learn the techniques to write a VBA script without having any programming knowledge. Your daily excel work will be easier and you will be interested to learn the next step.

Learning Methodologies

• Presentation through Zoom Screen Sharing
• LIVE questions & Answers
• Project-based workings

Who Should Attend?

Regular Excel users having basic Excel Knowledge and want to learn VBA & Macro step by step from the very beginning.

Content of the Webinar

• Concept of VBA & Macro
• Preparing the Excel environment to start VBA & Macro
• Recording your first Macro step by step
• Assigning the macro with a button or an object
• Assigning the macro with a shortcut key
• Running the macro using button or shortcut key
• Changing the recorded script in VBE
• Saving process of the Macro-Enabled excel file
• Project-1
• Project-2
• Writing few most common scripts for Excel
• Magic tips for learning VBA coding without having any programming knowledge

Note:

• All participants will get a digital certificate from Thriving Skills Limited.
• Must set up your first name, last name, and display name from settings of your profile for your certificate.
• Don’t click on the “FINISH COURSE” button.
• If you click on the “FINISH COURSE” button then the webinar will be finished and a Certificate will be generated.

Course Instructor:

Nazmul Muneer

Courses of this Instructor:

1. Most Common Features of Excel for Professionals
2. Microsoft Excel – VBA & Macro
3. Microsoft Excel VBA & Macro Basics
4. Lookup Functions with Practical Business Case Study
5. Excel VBA & Macro
6. Microsoft Excel-Professional Tips & Tricks
7. Most Out of Excel
8. Advanced Automated Dashboard Reporting System Using Excel