Excel 2010 VBA
4.7 (71 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.
957 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2010 VBA to your Wishlist.

Add to Wishlist

Excel 2010 VBA

This course introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA).
4.7 (71 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.
957 students enrolled
Last updated 10/2016
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA)
View Curriculum
Requirements
  • Intermediate to advanced Excel knowledge required
Description

The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.




Who is the target audience?
  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks
Compare to Other Excel VBA Courses
Curriculum For This Course
31 Lectures
05:26:01
+
Introduction
1 Lecture 02:28
+
Macro Development Basics
4 Lectures 58:42
Displaying the Developer Tab
09:02

Setting Macro Trust within Excel 2010
03:50

Recording and Running a Macro
07:41

Examining the VBA Editor
38:09
+
VBA Programming Fundamentals
6 Lectures 01:13:12
Reviewing the Excel 2010 Object Model
08:56

Understanding Functions and Procedures
10:49

Understanding Variables and Scope
35:17

Commenting Your Code
03:18

Creating Constants
05:48

Understanding Arguments
09:04
+
Working with Control Structures
6 Lectures 51:42
Using If/Then/Else
08:00

Understanding Logical Operators
05:33

Creating a Select/Case Statement
12:10

Creating For/Next Loops
11:40

Creating Do Loops
04:50

Creating While/Wend Loops
09:29
+
Using VBA Functions
5 Lectures 01:03:22
Viewing the Object Browser
09:28

Using the InputBox() Function
08:22

Understanding the MsgBox() Function
16:43

Using String Functions
15:46

Using Date Functions
13:03
+
Creating UserForms
3 Lectures 40:25
+
Debugging Techniques
5 Lectures 32:22
Understand the Difference Between Syntax and Logic Errors
03:48

Using Breakpoints
05:43

Stepping Through Your Macro
02:53

Creating Watches
04:27

Adding Error Traps
15:31
+
Conclusion
1 Lecture 03:48
Conclusion
03:48
About the Instructor
Intellezy Trainers
4.4 Average rating
5,110 Reviews
29,050 Students
138 Courses
Computer Training Specialists

At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.