Online course detail
Curriculum
- What Is VBA?
- History of VBA
- Automating a Recurring Task
- Liabilities of VBA
- Difference between VBA & Macros
- What Is a Variable? And how to define a variable
- What are different Data Types?
- What are Objects in VBA?
- How to Forcefully Declare a Variable?
- Workbooks
- Worksheets
- Cells and Ranges
- SpecialCells
- Using the Cells Property
- Using Current Region
- Using Range with Several Cells
- Using OFFSET
- Using RESIZE
- Working on the Data Range
- Working on the UsedRange
- Finding Last Rows and Columns Dynamically
- Finding Where the Range Starts and Ends
- AND
- OR
- NOT
- If…Then
- If…Then…Else
- If…Then…ElseIf
- IIF
- Select Case
Understanding Logical Operators
Working with Conditional Statements
Different type of Loops
For…Next
For Each…Next
Do While
Do Until
Do…Loop While
Do…Loop Until
While…Wend
- What Is an Array? How to Declare it
- Option Base Statement
- Boundaries in Arrays
- Declaring Arrays with Fixed Elements
- Dynamic Arrays with ReDim and Preserve
- What Is an Event?
- Where Does the Worksheet Event Code Go?
- Enabling and Disabling Events
- Examples of Common Worksheet Events
- Worksheet_Change Event
- Worksheet_SelectionChange Event
- Worksheet_BeforeDoubleClick Event
- Worksheet_Before RightClick Event
- Worksheet_FollowHyperlink Event
- Worksheet_Activate Event
- Worksheet_Deactivate Event
- Worksheet_Calculate Event
- Worksheet_PivotTableUpdate Event
- What are Workbook Events?
- Where does Workbook Event Code Go?
- Examples of Common Workbook Events
- Workbook_Open Event
- Workbook_BeforeClose Event
- Workbook_Activate Event
- Workbook_Deactivate Event
- Workbook_SheetChange Event
- Workbook_SheetSelectionChange Event
- Workbook_SheetBeforeDoubleClick Event
- Workbook_SheetBeforeRightClick Event
- Workbook_SheetPivotTableUpdate Event
- Workbook_NewSheet Event
- Workbook_BeforePrint Event
- Workbook_SheetActivate Event
- Workbook_SheetDeactivate Event
- Workbook_BeforeSave Event
- Deleting Rows Containing Duplicate Entries
- Deleting Rows with Duplicates in a Single Column
- Deleting Rows with Duplicates in More Than One Column
- Working with Duplicate Data
- Adding a Chart to a new Chart Sheet
- Adding Charts to same Worksheet
- Deleting Charts
- Renaming a Chart
- What Is a User-Defined Function?
- Features of User-Defined Functions
- UDF Examples
- What Is Debugging?
- Error Handler
- Integrating Excel with Outlook for mailing
- Integrating Excel with Word
- Integrating Excel with PowerPoint
Course Description
There is no department in industry where VBA Programming is not used. It is omnipresent. We understand that VBA content coverage is huge and can become difficult to handle. Hence we at Gyansetu, have strategically devised this course as per the exact demand of the industry and ensure that at the end of the course, you Excel in excel.
- Automate the day-to-day excel work
- Integrate your excel with outlook for emailing
- Integrate your excel with external databases like mysql, sql server, etc.
- Create dynamic Userforms
- Aumomate workbooks and worksheets using event programming.
After the completion of VBA Programming course at Gyansetu, you will be able to:
We at Gyansetu understand that teaching any course is not difficult but to make someone job-ready is the essential task. That's why we have prepared capstone projects which will drive your learning through real-time industry scenarios and help you clearing interviews.
All the advanced level topics will be covered at Gyansetu in a classroom/online Instructor-led mode with recordings.
No prerequisites. This course is for beginners.
- Our placement team will add VBA Macros skills & projects to your CV and update your profile on Job search engines like Naukri, Indeed, Monster, etc. This will increase your profile visibility in top recruiter search and ultimately increase interview calls by 5x.
- Our faculty offers extended support to students by clearing doubts faced during the interview and preparing them for the upcoming interviews.
- Gyansetu’s Students are currently working in Companies like Sapient, Capgemini, TCS, Sopra, HCL, Birlasoft, Wipro, Accenture, Zomato, Ola Cabs, Oyo Rooms, etc.
Gyansetu is providing complimentary placement service to all students. Gyansetu Placement Team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training.
- Gyansetu trainers are well known in Industry; who are highly qualified and currently working in top MNCs.
- We provide interaction with faculty before the course starts.
- Our experts help students in learning Technology from basics, even if you are not good at basic programming skills, don’t worry! We will help you.
- Faculties will help you in preparing project reports & presentations.
- Students will be provided Mentoring sessions by Experts.
Certification
VBA CertificationReviews
Placement
Aarti
Placed In:
Fretron
Placed On – March 08 , 2018Review:
Professional teaching environment and great learning experience for students as well as working people.
Neha
Placed In:
Tata Consultancy Services
Placed On – June 18 , 2019Review:
My experience with Gyansetu was satisfactory. I came here to learn Advanced Excel training and now I am able to coding in this language very well.
Mandy
Placed In:
Tech Mahindra
Placed On – April 17 , 2020Review:
Our tutors are highly qualified and explain the all concepts very well. I am very obliged to our tutors who trained me perfect.
Enroll Now
Structure your learning and get a certificate to prove it.
VBA Programming Training in Gurgaon Features
FAQs
- What type of technical questions are asked in interviews?
- What are their expectations?
- How should you prepare?
We have seen getting a relevant interview call is not a big challenge in your case. Our placement team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training. We help you prepare your CV by adding relevant projects and skills once 80% of the course is completed. Our placement team will update your profile on Job Portals, this increases relevant interview calls by 5x.
Interview selection depends on your knowledge and learning. As per the past trend, initial 5 interviews is a learning experience of
Our faculty team will constantly support you during interviews. Usually, students get job after appearing in 6-7 interviews.
- What type of technical questions are asked in interviews?
- What are their expectations?
- How should you prepare?
We have seen getting a technical interview call is a challenge at times. Most of the time you receive sales job calls/ backend job calls/ BPO job calls. No Worries!! Our Placement team will prepare your CV in such a way that you will have a good number of technical interview calls. We will provide you interview preparation sessions and make you job ready. Our placement team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training. Our placement team will update your profile on Job Portals, this increases relevant interview call by 3x
Interview selection depends on your knowledge and learning. As per the past trend, initial 8 interviews is a learning experience of
Our faculty team will constantly support you during interviews. Usually, students get job after appearing in 6-7 interviews.
- What type of technical questions are asked in interviews?
- What are their expectations?
- How should you prepare?
We have seen getting a technical interview call is hardly possible. Gyansetu provides internship opportunities to the non-working students so they have some industry exposure before they appear in interviews. Internship experience adds a lot of value to your CV and our placement team will prepare your CV in such a way that you will have a good number of interview calls. We will provide you interview preparation sessions and make you job ready. Our placement team consistently works on industry collaboration and associations which help our students to find their dream job right after the completion of training and we will update your profile on Job Portals, this increases relevant interview call by 3x
Interview selection depends on your knowledge and learning. As per the past trend, initial 8 interviews is a learning experience of
Our faculty team will constantly support you during interviews. Usually, students get job after appearing in 6-7 interviews.
Yes, a one-to-one faculty discussion and demo session will be provided before admission. We understand the importance of trust between you and the trainer. We will be happy if you clear all your queries before you start classes with us.
We understand the importance of every session. Sessions recording will be shared with you and in case of any query, faculty will give you extra time to answer your queries
Yes, we understand that self-learning is most crucial and for the same we provide students with PPTs, PDFs, class recordings, lab sessions, etc, so that a student can get a good handle of these topics.
We provide an option to retake the course within 3 months from the completion of your course, so that you get more time to learn the concepts and do the best in your interviews.
We believe in the concept that having less students is the best way to pay attention to each student individually and for the same our batch size varies between 5-10 people.
Yes, we have batches available on weekends. We understand many students are in jobs and it's difficult to take time for training on weekdays. Batch timings need to be checked with our counsellors.
Yes, we have batches available on weekdays but in limited time slots. Since most of our trainers are working, so either the batches are available in morning hours or in the evening hours. You need to contact our counsellors to know more on this.
Total duration of the course is 100 hours (50 hours of live instructor-led-training and 50 hours of self-paced learning).
You don’t need to pay anyone for software installation, our faculties will provide you all the required softwares and will assist you in the complete installation process.
Our faculties will help you in resolving your queries during and after the course.