- About Course
- About Instructor
- Course Content
- User Reviews
|EXCEL – VBA LEVEL 1|
|ü The Fundamentals of Excel VBA, The Visual Basic Editor, Objects and Properties|
|ü Excel Objects – Workbook Included, Object Hierarchy, Application, Workbook, Worksheet, Range, Command Bars|
|ü Variables and Constants, Data types, Variable Levels, Declaring Variables, Constants|
|ü Loops, Types of Loops, Loop Pitfalls|
|ü Effective Decision Making, If/And /Or, Select Case, Dates and Times|
|ü Workbook and Worksheet Events|
|ü Debugging and Error Handling, Prevention, Good Habits, Runtime Errors|
|ü Excel Worksheet Functions in VBA, Specific Examples, Excels Built-In Features|
|ü User Defined Functions, Good vs Bad, Arguments, Calculation|
|ü Controls, ActiveX, Control Toolbox, Control Properties, Control Parents|
|EXCEL – VBA LEVEL 2|
|ü User Forms Introduction|
|ü Filling User Form Controls, Putting Data into our Controls, When to put Data into our Control, Filling a List Box and/or Combo Box using Loops|
|ü Multi-Page Control, Creating a wizard using the Multi-Page Control|
|ü Validating the User Inputs, Some Useful Methods and Functions|
|ü When to apply Validation, Control Events|
|ü Which Controls to use and When|
|ü Parsing Control Values back to a Spreadsheet, Parsing range values to the User Form Controls|
|ü Option Buttons and Checkboxes in Detail, True or False|
|ü Creating Template Controls, Using the Ref Edit Control|
|ü Finding the Active Control, Creating Controls at Runtime|
Course Batch Timings
09:00 AM-10:00 AM
INR FREEEnroll Now
02:00 PM-04:00 PM
INR FREEEnroll Now
Live Instructor Led Course
30-40 hrs of Class room or Online Live Instructor-led Classes conducting by industry domain specific professionals with lab support. Weekday class: 20 sessions of 2 hours each. and Weekend class:14 sessions (7 weekends) of 3 hours each.
Live project or Real-life Case Studies
Live project based on any of the selected use cases, involving EXCEL MACROS & VBA.
Each class will be followed by practical assignments and interview questions which can be completed before the next class.
24 x 7 Expert Support
We have 24x7 offline and online support team available to help you with any technical queries you may have during the course or After the course.
Yes, you have batch flexibility here. Once you join in Stansys you can attend classes in any batch or N number of batches within 1 year with same faculty.
Yes, we will provide you the certificate of the attended software training course or to download (Certificate.pdf) soft copy version to their personal e-mail id (Who is attended training with us).
1 Year validity
You get 1-year validity for live classes (classroom/online) and lifetime access to the Learning Management System (LMS). Class recordings and presentations can be viewed online from the LMS.
Money back guarantee
You can cancel your enrolment within 7 working days. We provide you complete refund after deducting the administration fee(Rs.500/-).
We have a community forum with students and industry professionals for all our customers wherein you can enrich their learning through peer interaction and knowledge sharing.