Excel 2010 VBA
4.4 (217 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,700 students enrolled

Excel 2010 VBA

This course introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA).
4.4 (217 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,700 students enrolled
Last updated 2/2018
English
English [Auto]
Current price: $38.99 Original price: $59.99 Discount: 35% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 5.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • This course will introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA)
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 this course is for:
  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks
Course content
Expand all 31 lectures 05:34:30
+ 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
+ Debugging Techniques
5 lectures 40:51
Understand the Difference Between Syntax and Logic Errors
12:17
Using Breakpoints
05:43
Stepping Through Your Macro
02:53
Creating Watches
04:27
Adding Error Traps
15:31