Excel VBA: Complete Understanding of VBA Components
4.7 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
707 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel VBA: Complete Understanding of VBA Components to your Wishlist.

Add to Wishlist

Excel VBA: Complete Understanding of VBA Components

VBA is important in the industry, because its integration into Microsoft Office, especially Excel. You will probably nee
4.7 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
707 students enrolled
Created by Lokesh Paliwal
Last updated 2/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 22 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand the framework of the VBA language and environment
  • Navigate the VBA editor and functions within Excel
  • Record, edit and write a macro
  • Apply fundamental programming building blocks such as loops
  • Design and code user forms
  • Example Based Project Models
  • How to Consolidate Multiple Workbook data into one, User form Projects
View Curriculum
Requirements
  • Before starting this course, no prior knowledge of programing is required. This course will start from very basics but student should have working knowledge of Excel.
Description

Visual Basic for Applications (VBA) extends the functionality of ordinary Excel sheets by automating common tasks, customize the interface to your specific needs, and perform complex calculations which don't exist natively in Microsoft Excel. Using this straightforward programming language, you can quickly sort columns and rows, add user controls such as buttons and forms, create reports that update as data changes, and calculate values across multiple worksheets. This course have been crafted to help you develop skill in Excel, so after completing this course, you will be able to leverage your VBA skills in other Office applications, like MS Access and Word.

Upon completing this course you will be prepared to:

  • Develop macros quickly within the Visual Basic Editor
  • Organize functions and procedures into modules
  • Create objects, methods, properties and events
  • Launch a UserForm directly from VBA
  • Add combo boxes, text boxes, command buttons and option controls
  • Identify potential security problems and learn how to protect you code
  • Trap potential errors and invoke a routine to handle them
  • Real world project examples
  • And much more!
Who is the target audience?
  • Anyone who uses excel will benefit immensely from this course. Any repetitive tasks can be automated. Any user experience can be improved. Any complex task can be simplified.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
27 Lectures
01:49:53
+
Introduction
4 Lectures 04:19

Steps to download Exercise Workbook
1 page

Important Tip: Save Macro Workbook As Macro Enabled Workbook(.XLSM)
1 page

+
Recording Macro
2 Lectures 06:26
+
Getting Started with VBA
4 Lectures 12:47
Sub - End Sub
02:12

Dot Notation
03:20

Copy Paste in Excel VBA
02:24

The Cells Property
04:51
+
Working with Variables
2 Lectures 05:25
Variables
02:33

Last Non blank Cell in a row or column – Range.End() Method
02:52
+
Conditional Statements
4 Lectures 20:17
IF Else IF
07:04

Conditional and Logical Operators
02:50

Select Case
08:07

With - End With Statement
02:16
+
Looping
5 Lectures 31:42
For Loop
04:37

For Each Loop
04:01

Exercise: For Loop
04:37

Do While
03:19

Combine Multiple Workbook into One
15:08
+
Array
2 Lectures 06:31
Array
03:09

Multi Dimensional Array
03:22
+
Userforms
4 Lectures 20:26
Userform
05:28

User Defined Function
05:00

Error Handling
04:01

Worksheet Function
05:57
About the Instructor
Lokesh Paliwal
4.5 Average rating
71 Reviews
1,442 Students
2 Courses
Consultant, Blogger and Trainer

I am the founder of ExcelCrazy and has worked with prestigious companies like Cisco, Sapient in the past 8 years as Data Consultant. Now working as full time trainer(Excel, VBA, SAS and Tableau) and Data consultant.

  •  
  • – A dynamic professional with experience in Data Analytics for Network Solutions, Banking and Business Outsourcing industries. 8 plus Years of experience in Data Management/ MIS / Quality Control/ Dashboards/ Analytics.
  •  
  • – Hands on expertise in development of automation tools and dashboard based on Excel, VBA, MS Access, SQL for different domains include Supply Chain, Leasing, Business outsourcing.
  •  
  • – Hands on experience in different Analytics Techniques includes Cluster Analysis, Factor Analysis and Regression Analysis. Worked on Data Analytics, Supply Chain, Operational Analytics and Digital Analytics with focus on Finance, Supply Chain and Outsourcing clients in Asia, Australia and United States.
  •  
  • – Have used different statistical flat forms like SAS, SQL, Excel, VBA, Tableau, OBI(Oracle Business Intelligence).
  •  
  • – Trained and coached several client teams and various individuals on Data Analytics tools and techniques as part of part of capability building programs.