Course Description:-

INTRODUCTION:

This course provides a basic overview of using VBA to automate excel tasks. With limited knowledge of Excel and zero knowledge of programming anybody can Excel in this awesome course. The course is divided into 2 parts.

Basic part comprises of VB language, VBE, Macros

Advanced part comprises of writing email, creating pdf, sorting, designing user forms dynamically.

Here we learn about the VBA Environment, Macros with IF conditions, Data Filters, Charting using VBAs and designing of Userform.

This course on VBA & Macros is well structured and strategically designed online training program for learning Microsoft Excel VBA & Macros. The goal of this program is to make a beginner start learning VBA & Macros from scratch.

Target Audience for VBA Macros Course:

• All stream students
• Keen learners
• Professionals
• Financial Analyst
• Investment Banker

VBA Macros Course Highlights:

This course on VBA & Macros – Beginners provide a basic overview of using VBA to automate excel tasks. This Program on VBA & Macros is well structured and strategically designed online training program for learning Microsoft Excel VBA & Macros. The aim of this program is to make a beginner start teaches VBA & Macros from scratch this course covers following:

• Introduction to VBA-This tutorial provide you basic understanding of VBA.
• My First Macro-Learn how to record macros in excel sheet.
• VBA Environment-Learn all about basics of VBA environment.
• Macros with IF Condition-Learn How to records macro with If condition.
• Also learn about Data Filter, Charting using VBA and Userforms.

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 - +918587999769

CURRICULUM

Section 1: Introduction to VBA

1. Introduction to VBA Part 1
2. Introduction to VBA Part 2

Section 2: My First Macro

1. My First Macro part 1
2. My First Macro part 2

Section 3: 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 4: Macros with IF Condition

1. Macros with IF Condition Part 1
2. Macros with IF Condition Part 2

Section 5: 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 finishing touches

Section 6: Charting using VBA

1. Charting using VBA Introduction
2. Charting using VBA Recording Macro part 1
3. Charting using VBA Recording Macro part 2
4. Charting using VBA Chart in another sheet
5. Charting using VBA Dynamic Inputs Part 1
6. Charting using VBA Dynamic Inputs Part 2
7. Charting using VBA Step into F8

Section 7: Userform

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

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