Visual Basic for Microsoft Excel - Advanced

This online course is to understand the advanced VBA Macros training. This course will help you understand how to create a user form and its features such as the combo box, list box, radio button, check box, looping and referencing. Next we would see the recording of macros, modifying code and linking to the user, sorting numbers, creating graphs, printing and emailing reports.

291

 7h 38m | 67 Videos | 86112 Views |   Expert

Online VBA Macros – Advanced Course Training

This is part II of our program. These video tutorials 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 Userform

You must be knowing that a UserForm is a custom-built dialog box which is builtusing 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 Userform Combo Box, Userform List Box, Userform Radio Button and Userform 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.

Back to top ▴