facebook

Visual Basic for Applications

Visual Basic for applications is being used for creating additional functions and functionality in Microsoft office applications. This course will cover Microsoft Excel automation and connectivity with many other databases and applications hence you will be able to create Excel automations and tools after completing this course


Curriculum:

  • VBA Introduction
  • Intro of VBA IDE
  • Types of modules and form in VBA
  • Uses of VBA
Free Demo
  • 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
Free Demo
  • 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:

Online Virtual Class Room

Enroll in any above batch and attend live class at scheduled time

6999      




Upcoming Batches:

2024-10-19
10:00 AM IST
Weekend Batch (2 Hours Sat & Sun)
₹6999 ₹6299.1 (10% OFF)
Offer Ends in 10 d: 13h : : 42s
2024-10-07
8:00 AM IST
Weekdays Batch
6999
2024-10-14
8:00 PM IST
Weekdays Batch
₹6999 ₹6299.1 (10% OFF)
Offer Ends in 5 d: 13h : : 42s


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.


Reviews:



Jun-03-2024

Apr-20-2020

Apr-20-2020

Apr-20-2020

Popular Courses

Microsoft Professional Excel

Microsoft Professional Excel

Learners : 2889
Rating :

Read More
Structured Query Language (T-SQL)

Structured Query Language (T-SQL)

Learners : 1500
Rating :

Read More
Data Visualization with Tableau

Data Visualization with Tableau

Learners : 1500
Rating :

Read More
Microsoft Power BI

Microsoft Power BI

Learners : 1249
Rating :

Read More
Data Science with Python

Data Science with Python

Learners : 120
Rating :

Read More
Big Data Hadoop Certification

Big Data Hadoop Certification

Learners : 1100
Rating :

Read More
Advanced Python

Advanced Python

Learners : 1009
Rating :

Read More
Data Analyst

Data Analyst

Learners : 1502
Rating :

Read More
Azure Data Engineering

Azure Data Engineering

Learners : 1600
Rating :

Read More
Become Full Stack Java Developer

Become Full Stack Java Developer

Learners : 2300
Rating :

Read More
Data Engineering

Data Engineering

Learners : 1548
Rating :

Read More

Contact us

Phone: +91-9999468662 +91-9999468661

Email: info@wifilearning.com

Enquiry