Course Description:-

INTRODUCTION:

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 for VBA Macros Training Course

• Suitable for students pursuing Degree, Diploma, Engineering, commerce and all general studies.
• MBA, BBA students from all specializations
• Charted Accountant (CA)
• Also suitable for working professionals.
• People who want to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker for them Excel is the language that they should speak.

Pre-requisites for VBA Macros Training Course

• There is no prerequisite as everything in the course will begin from scratch.

VBA Macros Training course highlights

• Introduction to VBA

Macros are meant for saving users time in order to avoid writing repeated tasks. Through this we will understand what is VBA and macros and where and how they can be used.

• My First Macro

Through this module we will learn about how to use macros to create your own shortcut in excel

• VBA Environment

This module will teach us about VBA environment project explorer in detail, we will learn about its properties, how do you run, break , reset and design, what is debug and how do you solve it

• Macros with IF Condition

Through this module we will learn about how to use macros using if condition

• Data Filter

Through this video we will understand how to do data filter in excel using macro recording, dynamic update, command buttons etc.

• Charting using VBA

This module will teach us how do you create charts in excel using VBA and macros as this function will help us to save our lot of time.

• Userform

Through this module we will learn about what isuserform and how to create userformtextbox ,userform textbox printing using VBA and Macros in excel.

• Case Study for Advanced VBA Introduction

This module will guide you what are the different things that we are going to learn through the advanced VBA.

• Case Study Milestone 1 Userform

Through this module we will learn about what is userform, how to create userform, and how do you insert combo box, radio button, list box, check box in a userform

• Case Study Milestone 2 Update Now

Through this we will understand about looping in detail where we eill understand different concepts like Looping For Next Exit For and Step, Looping For Next Nested Loops, Looping Do Until Loops etc.

• Case Study Milestone 3

This module will teach us how do you write a formula in row and column method in excel using VBA and macros, we will also learn to do EMI calculations in excel using VBA and Macros.

• Case Study Milestone 4 Sort EMI

This module will teach us how do you sort EMI in excel using VBA and macros. We will learn about basics of array, how do one sort the numbers using arrays, how do one sort the strings using array etc.

• Case Study Milestone 5 Create Graph

Once done with EMIcalculation charts and graphs are the best way to analyze the data easily. So through this module we will learn about how to create dynamic charts in excel using VBA and Macros.

• Case Study Milestone 6 Print Report

Through this module we will learn about how do you print dynamic range and print the entire report using VBA and macros

• Case Study Milestone 7 Email Report

This module which brief you how to email the report with PDF using VBA and macros.

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: 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

Section 8: Case Study for Advanced VBA Introduction

1. VBA Introduction

Section 9: Case Study Milestone 1 Userform

1. EMI Userform Introduction Part 1
2. EMI Userform Introduction Part 2
3. EMI Userform Combo Box Part 1
4. EMI Userform Combo Box Part 2
5. EMI Userform Combo Box Part 3
6. EMI Userform List Box Part 1
7. EMI Userform List Box Part 2
8. EMI Userform List Box Part 3
9. EMI Userform Radio Button Part 1
10. EMI Userform Radio Button Part 2
11. EMI Userform Radio Button Part 3
12. EMI Userform Checkbox

Section 10: Case Study Milestone 2 Update Now

1. Looping For Next Part 1
2. Looping For Next Part 2
3. Looping For Next Exit For and Step
4. Looping For Next Nested Loops
5. Looping Do Until Loops
6. Looping Do While Loops
7. Last Row and Column Dynamic Part 1
8. Last Row and Column Dynamic Part 2
9. Referencing from the Same Workbook
10. Referencing from the Another Open Workbook
11. Referencing from the Another Closed Workbook
12. Referencing from the Another Closed Workbook with Dynamic Ranges
13. User Defined Function
14. Calculator Update Now

Section 11: Case Study Milestone 3

1. Writing Formula RowColumn Method
2. Writing Formula Range Formula and Worksheet fn
3. PMT formula
4. Recording Macros
5. Modifying Code and Linking to user inputs 1
6. Modifying Code and Linking to user inputs 2
7. New Sheet with selected user inputs 1
8. New Sheet with selected user inputs 2
9. Debugging the code 1
10. Debugging the code 2

Section 12: Case Study Milestone 4 Sort EMI

1. Introduction to Sort EMI Button
2. Arrays basics
3. Populating arrays in Worksheet
4. Sorting Numbers using Arrays 1
5. Sorting Numbers using Arrays 2
6. Sorting Numbers using Arrays 3
7. Sorting Strings using Arrays
8. Assign Bank Details to Arrays 1
9. Assign Bank Details to Arrays 2
10. Sort Bank Details Arrays 1
11. Sort Bank Details Arrays 2
12. Sorted Array in New Worksheet

Section 13: Case Study Milestone 5 Create Graph

1. Introduction
2. Copying Bank Details to Graph Sheet 1
3. Copying Bank Details to Graph Sheet 2
4. Creating Static Graph
5. Creating Dynamic Graph
6. Positing Graph at customized location
7. Conclusion

Section 14: Case Study Milestone 6 Print Report

1. Print user defined sheet number or name
2. Print Dynamic Range Part 1
3. Print Dynamic Range Part 2
4. Print Report Part 1
5. Print Report Part 2
6. Print Report Part 3

Section 15: Case Study Milestone 7 Email Report

1. Creating PDF Part 1
2. Creating PDF Part 2
3. Email Report with PDF Part 1
4. Email Report with PDF Part 2
5. Email Report with PDF Part 3

Here is a sample for the course completion certificate which you will recieve 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