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
- 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
VBA Macros – Advanced Course Training Highlights:
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.
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.
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.
Here you will understand the simple ways and tricks of creating graphs.
Get ready to learn the PRINT function in VBA Macros through this module.
Here you will understand in detail the functions of creating PDF and email report.
|Where do our learners come from?|
|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.|