Curriculum:
- VBA Introduction
- Intro of VBA IDE
- Types of modules and form in VBA
- Uses of VBA
- If condition and Case statement in VBA
- Nested if and else statements
- Nested if using AND, OR and Not Operator
- Cells and range in VBA
- Copy and paste in VBA
- Paste special in VBA
- Introduction of loop
- For loop in VBA
- Do While and Until loop in VBA
- Importance of loops in VBA
- Use cases on Loops
- Dynamic range and cells
- Uses of XLUP, XLRIGHT, XLDOWN, XLLEFT in VBA
- Select method in VBA (Union, except, offset, resize etc)
- Excel sheet property in VBA (add, delete, move, copy etc)
- Workbook property in VBA (Open, Kill, Save, Save as etc)
- Special cells feature using VBA
- Uses of Excel functions in VBA (Count, Vlookup, Sum, Text Function etc)
- Uses of VBA Formula
- Writing Dynamic Formula
- Introduction of Array
- Declaration of Array
- Different Types of Array
- Dynamic Array
- Array Functions
- Example of Array
- File scripting Object (FSO) in VBA
- How to create User defined formula
- Use of ByVal and ByRef in Function
- For Each loop concepts in VBA
- Creating UDF using array
- How to call a Function in Program
- Difference between procedure and function
- How to Call a UDF from excel
- User form controls and events
- Uses of combo box, text box, labels.
- Difference between combo box and list box
- Use of tab page
- Project work: Design a user form for controlling the tabs.
- Types of Database Connection
- Connection with MS-Access
- Connection with MS-Excel
- Connection with MS-SQL Server
- Query (Select/Update/Delete/Add/Insert)
- Call a stored procedure from VBA
- Pivot table
- Charts
- Shape Object
- Send a new Email
- Send Email with attachments
- Send Email with Snapshots
- Send Email with HTML mail body
- Navigate a URL
- Read data from Internet Explorer
- Introduction of Web Crawling
- MS word connection
- PPT connection
- Notepad connection
- External Object connection
- What is Addins
- Uses of Addins
- Project work
Fee:
Self Paced Learning
Get the recorded session and study Material. Learn in your speed
1499Online Virtual Class Room
Enroll in any above batch and attend live class at scheduled time
6000Offline Class Room
Visit our centre and enrol for the course, The course Fee will vary as per the Metro/ Non Metro or locality.
6000Upcoming Batches:
FAQ:
1. What is the use of VBA?
In order to extend the capability of Microsoft Excel we use VBA. By using VBA, we can create additional functionality in Excel, we can create user defined functions in Excel, we can also create automated tools, most importantly we can interact with many other Microsoft and non-Microsoft applications by using VBA.
2. Any Prerequisite to learn VBA?
If you are good in Microsoft excel then you can learn VBA easily.
3. Since this is programming language, can I learn VBA without any technical background?
Yes, you can learn VBA without any technical background. VBA is very easy to learn.
4. System requirements to Install MS Excel?
500 MHz processor, along with 256 MB Ram and a 3 GB hard disk.
5. Who are the recommended Audience for the course?
VBA is embedded in MS Excel, there is no installation required if you have MS office installed. Business, where people are using Excel, they can use VBA to extend the capability of Excel. People who are already working on Excel they can learn VBA to get better opportunity.
6. In case of my absence, how can I manage my class?
You will get access of LMS (Learning management System), if you missed your class you can refer the recorded session in your LMS. If you have any doubt you can ask in your next class whenever you will join.
7. Who is the Instructor?
Our instructors are industry experts having more than 8 years of corporate experience. Since they have rich experience in their domain they will train as per the industry standards.
8. Will you help us in Job placement?
We have tied up with more than 100+ companies in corporate industry. We will schedule your interview after successful completion of our course.
9. Will you help us in resume creation?
Yes, we will help you in creating your resume so that it can shortlist easily for interview.
10. Will you help us to get the software?
Yes, we will help you with Trial version of software.
11. How long can I access my (LMS) learning management System?
Once you will enroll for the course, you can access the LMS for life long.
12. How can I get the certification?
Once you will complete your course, you will appear for an online test. Basis on your score we will issue the certificate.
13. What is Self-paced course?
If you will enroll for self-paced course you can access the pre recorded sessions and you can do self-learning. You can complete your course as per your availability.
14. What is Instructor driven course?
This is online virtual class room training, since this is live class, you can clear your doubts in the class.
15. What if I have more queries or concerns?
You can write an email at info@wifilearning.com or you can contact us at our Office numbers at 91-9999468661.
16. What is Knowledgebase?
It is our technical query support system. You can raise your technical questions and it will be resolved here. Our experts are actively answering your questions.
Recommended Courses:
Recommended courses
Microsoft Professional Excel
Structured Query Language (T-SQL)
Data Visualization with Tableau
Microsoft Power BI
Reviews:
Jun-20-2020
The course is really good. It is just lacking a little more practice exercises.
Apr-20-2020
This course is great. You simply learn a lot in an easy way. The teacher is really good and knows how to teach and engage you in the lessons. I am looking forward to next courses in the specialization.
Apr-20-2020
Great course. Small steps really helped me become more confident.
Apr-20-2020
I really liked this course - it was short, useful and to the point. Would love to see a follow up on how to take notes of lectures, books and journal articles so that they can be used to build an essay.
