Visual Basic for Microsoft Excel Advance Online Course

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.

EduCBA puts an emphasis on Brain-Based Learning into each of its courses by creating energetic, fresh training with audio and visual stimuli, allowing for maximum impact. With EduCBA you're afforded:

Access to 5498 Courses & 203 Learning Paths
Choose exactly what you'd like to learn from our extensive library.

Expert Teachers
Learn from industry experts who are passionate about teaching.

Learn Anywhere
Switch between devices without losing your place.

The digital learning allows you to learn at your own time and pace, providing no disruption to your other commitments. Your new learning will enhance your skills set, allow you to change your behaviour in a positive way and make you more productive in the workplace. Once you have become more skills, you are worth more to yourself and to your organisation.

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.

Professionals from around the world have benefited from eduCBA’s Visual Basic for Excel – Advanced courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many.

Currently there are no Q&As for this course. Be the first to ask a question.