Course Description:-

INTRODUCTION:

In these video tutorials we provide an advanced overview of using Excel VBA Here we will work on case study approach, and coding aspects of the form.

Here is a look over the course content:

• How to Create User forms (with Labels, Text boxes, combo boxes.)?
• How to reference data with different sheets (i.e. linking)?
• Special Commands like Vlookup
• Looping functions like for, while loop
• Arrays
• Graphs
• Printing, Emailing of Reports

In this course you get access to some of our awesome VBA Macros videos which will help you to gain advanced knowledge over this most used spreadsheet software.

Target Audience for VBA Macros – Advanced Course Training

• All stream students
• Keen learners
• Professionals
• VBA Macros – Advanced Course Training Highlights:

VBA Introduction

In this module you will watch an introductory video to VBA Macros. It will help you understand what a Macro is and how it is useful.

Understanding User form

You must know that a User Form is a custom-built dialog box which is built using the Visual Basic Editor. It acts as a simple interface for entering data. You must have seen it hundreds of times, but we are here to teach you how to create one! So in this module you will learn about User form Combo Box, User form List Box, User form Radio Button and User form Checkbox.

Use of Update Now

In this module you are going to learn some important VBA macros functions like Looping for Next, Nested Loops, Do until Loops, Do While Loops, Referencing Sheets and much more.

Writing formulas and EMI Calculations

Then comes an important milestone in you program where you will understand ‘Writing Formulas’ in detail.  It forms an important part of your learning and we also provide you with the practice test for the same. In EMI calculation part of the case study, the video tutorials on PMT formulas, recording macros, debugging the code etc take you to a further level of learning VBA.

Sort EMI

• In this module you are here to learn about sort EMI button, array basic, Sorting Numbers using Arrays, Sorting Strings using Arrays and Sort Bank Details with respect to the case study provided.

Creating Graph

• Here you will understand the simple ways and tricks of creating graphs.

Print Report

• Get ready to learn the PRINT function in VBA Macros through this module.

Email Report

• Here you will understand in detail the functions of creating PDF and email report.

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: Case Study for Advanced VBA Introduction

1. VBA Introduction

Section 2: 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 3: 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 4: 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 5: 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 6: 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 7: 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 8: 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 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