Visual Basic for Excel - Beginners Guide
Visual Basic for Excel - Beginners Guide
Office Productivity,Visual Basic
Lectures -28
Duration -3 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
VBA stands for visual basics for applications. Â It is an event-driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as Ms excel, ms word and ms access.
In simple terms, VBA is the tool used by people mainly working professionals to develop programs used to control excel. Often, we tend to confuse VBA and VB  because it looks quite Similar but that’s not true. VB is the language rather than programming language that creates standalone executable programs.
Excel is used for a lot of things like Keeping lists of things, such as customer names, students’ grades, or holiday gift ideas, Budgeting and forecasting,Analysing scientific data, Creating invoices and other forms, Developing charts from data tab marks etc. The need to automate these daily things in excel to make it faster and VBA does that through different codes.
Target audience
The course starts from starch so there is as such no age limit. Although the minimum qualification is intermediate but it best suited for those students pursuing a degree, diploma, engineering, commerce and all general studies. The course also gives specialization to MBA and BBA students as well as Charted Accountants. The course very well suites all the working professionals and adds to their skills.
Prerequisites
What are the prerequisites for this course?
- The course is simple and easy to understand with minimum prerequisites or requirements. All one needs is keen interest in learning excel VBA and macro and good internet connection. The course requires no pre-requisite as all starts from scratch.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction to VBA
2 Lectures
- Introduction to VBA Part 1 05:43 05:43
- Introduction to VBA Part 2 07:05 07:05
My First Macro
2 Lectures
VBA Environment
6 Lectures
Macros with IF Condition
2 Lectures
Data Filter
6 Lectures
Charting using VBA
7 Lectures
User form
3 Lectures
Instructor Details
Corporate Bridge Consultancy Private Limited
eCourse Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe nowOnline Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now