Excel 2010 VBA

This course introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA).
3.4 (34 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.
595 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 31
  • Length 5.5 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2013 English

Course 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.




What are the requirements?

  • Intermediate to advanced Excel knowledge required

What am I going to get from this course?

  • This course will introduces the user to Excel 2010 macro programming using Microsoft’s Visual Basic for Application (VBA)

What is the target audience?

  • Intermediate and Advanced level users of Excel who need to automate worksheets and workbooks

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction
Preview
02:28
Section 2: Macro Development Basics
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
Section 3: VBA Programming Fundamentals
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
Section 4: Working with Control Structures
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
Section 5: Using VBA Functions
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
Section 6: Creating UserForms
Designing a Form
Preview
01:45
Understanding Different Controls
Preview
07:58
Working with Form Properties
30:42
Section 7: Debugging Techniques
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
Section 8: Conclusion
Conclusion
03:48

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Intellezy Trainers, 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.

Ready to start learning?
Take This Course