Tutorialspoint

#May Motivation Use code MAY10 for extra 10% off

Visual Basic for Excel - Beginners Guide

Visual Basic for Excel - Beginners Guide

Visual Basic for Excel - Beginners Guide

updated on icon Updated on May, 2024

language icon Language - English

person icon Corporate Bridge Consultancy Private Limited

English [CC]

category icon Office Productivity,Visual Basic

Lectures -28

Duration -3 hours

4.2

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

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.
Visual Basic for Excel - Beginners Guide

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction to VBA
2 Lectures
  • play icon Introduction to VBA Part 1 05:43 05:43
  • play icon Introduction to VBA Part 2 07:05 07:05
My First Macro
2 Lectures
Tutorialspoint
VBA Environment
6 Lectures
Tutorialspoint
Macros with IF Condition
2 Lectures
Tutorialspoint
Data Filter
6 Lectures
Tutorialspoint
Charting using VBA
7 Lectures
Tutorialspoint
User form
3 Lectures
Tutorialspoint

Instructor Details

Corporate Bridge Consultancy Private Limited

Corporate Bridge Consultancy Private Limited

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515