Course Description:-

INTRODUCTION:

Excel VBAs and Macros – Basic

• We bring this course of Excel VBAs and Macros – Basic. Visual Basic for Applications (VBA) is user friendly programming language developed by Microsoft. With VBA we can design a very good interactive screen with all label, text boxes and buttons; and by doing proper coding with Macros, we can make this work very simpler and systematic.
• A macro consists of instructions that the user can record as per his/her need & associate with a shortcut key combination or a macro name. Then whenever that shortcut key is pressed or macro name is clicked, computer automatically carries out those set of instructions.

Course Objectives:

• Through this VBA Macros Training course you grasp over the subject. These tutorials on VBAs and Macros training uses non coding approach to automate daily tasks like publishing report, email, forms, calculations, graphs etc. You will learn all these and many more tools using a case study approach.
• The aim of this program is to make a beginner start learning VBA & Macros from scratch till advanced. When we have to make repetitive reports‚ dashboards or slides‚ when the work on excel sheet gets complex and repetitive‚ the most important solution would be to automate the worksheets and save a lot of time.

Target Audience

• Students pursuing Degree, Diploma, Engineering, commerce and all general studies.
• MBA, BBA students from all specializations
• Charted Accountant (CA)
• Also suitable for working professionals.

Pre-requisites

• Computer with Internet Connection to view the training materiel
• There is no prerequisite as everything in the course will begin from scratch.

Benefits of online course:

• High Quality Content
• Learn Anywhere Anytime & at Your Pace
• 24X7 Customer Support
• Complete Student Support Throughout The Program
• Course Completion Certificate 
• Lifetime course access

For any query feel free to call

Mob - 8587999769/9818826705

CURRICULUM

Section 1: Course Overview

1. VBA & Macros: Course Introduction

Section 2: Introduction to VBA

1. What are VBA & Macros?
2. Advantages of using VBA and Macros

Section 3: My First Macro

1. Protocols in creating Macros
2. Creating My First Macro

Section 4: VBA Environment

1. VBA Environment – Project Explorer
2. VBA Environment – Properties
3. VBA Environment – Run Break Reset and Design
4. VBA Environment – Debug – Toggle
5. VBA Environment – Debug – Local Window
6. VBA Environment – Debug – Watch and Immediate Window

Section 5: Macros with IF Condition

1. Macros with IF Condition
2. Macros with IF Condition (Continued)

Section 6: Data Filter

1. Data Filter using VBA – Introduction
2. Data Filter using VBA – Macro Recording
3. Data Filter using VBA – Dynamic Update
4. Data Filter using VBA – Command Buttons
5. Data Filter using VBA – Command Buttons – Modifying
6. Data Filter using VBA – Command Buttons – Final touches

Section 7: Charting using VBA

1. Charting using VBA – Introduction
2. Charting using VBA – Creating codes for charts
3. Charting using VBA – Recording Macro
4. Charting using VBA – Chart in another sheet
5. Charting using VBA – Dynamic Inputs
6. Charting using VBA – Creating Dynamic charts
7. Charting using VBA – Checking the codes

Section 8: Userform

1. Userforms – Introduction
2. Userforms – Textbox
3. Userforms – Textbox Printing

Section 9: Conclusion

1. Conclusion

Here is a sample for the course completion certificate which you will receive after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address