Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Course Information arrow

Price Discounts

  • Qty

    Price

  • 1

    $30.00

  • 5

    $27.00

  • 11

    $27.00

  • 26

    $15.00

  • 51

    $7.50

  • 51

    $7.50

Syndication Option

Resell Course
Resold modules appear on your website. You earn syndication share from each purchase.
Contact Coggno to learn more on how to embed your own Portable Webshop in your website.


Excel 2010 VBA Course
Preview-button-95px

Excel 2010 VBA Course

Author: Intellezy

Category: Online Software Training > Microsoft Office

This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; rec...

Keywords: Excel, VBA Excel 2010 Advanced, Excel 2010 VBA Macro Development, Excel 2010, Microsoft Office 2010, office, Text Prep, MOS, MOS 2010 Certification, Office 2010, Tim Miles, Intellezy

Read More
Buy this course
$30.00

Per License

Enter no. of units to buy
Total Payment Required$30.00 Add to Cart
# Licenses 1 5 11 26 51 51
Discounted Price $30.00 $27.00 $27.00 $15.00 $7.50 $7.50
Table of Contents:

1) Introduction - Introduction (00:00)

2) Macro Development Basics
- Displaying the Developer Tab (00:00)
- Setting Macro Trust within Excel 2010 (00:10)
- Recording and Running a Macro (00:20)
- Examining the VBA Editor (00:30)

3) VBA Programming Fundamentals
- Reviewing the Excel 2010 Object Model (00:00)
- Understanding Functions and Procedures (00:10)
- Understanding Variables and Scope (00:20)
- Commenting Your Code (00:30)
- Creating Constants (00:40)
- Understanding Arguments (00:50)

4) Working with Control Structures
- Using If/Then/Else (00:00)
- Understanding Logical Operators (00:10)
- Creating a Select/Case Statement (00:20)
- Creating For/Next Loops (00:30)
- Creating Do Loops (00:40)
- Creating While/Wend Loops (00:50)

5) Using VBA Functions
- Viewing the Object Browser (00:00)
- Using the InputBox() Function (00:10)
- Understanding the MsgBox() Function (00:20)
- Using String Functions (00:30)
- Using Date Functions (00:40)

6) Creating UserForms
- Designing a Form (00:00)
- Understanding Different Controls (00:10)
- Working with Form Properties (00:20)

7) Debugging Techniques
- Understand the Difference Between Syntax and Logic Errors (00:00)
- Using Breakpoints (00:10)
- Stepping Through Your Macro (00:20)
- Creating Watches (00:30)
- Adding Error Traps (00:40)

8) Conclusion - Conclusion (00:00)

Hardware and Software Requirements:

The courses work well with Internet Explorer (v 8 - higher), Firefox, and Google Chrome. Please make sure you have Adobe Flash Player installed and that you are running the latest version of Flash Player, go to http://www.adobe.com/software/flash/about to check your version or get Flash http://www.adobe.com/go/getflash. We highly recommend at least 2-3 Mbps connection speed.

Included Modules:
  • Excel 2010 VBA - Introduction

    Excel 2010 VBA - Introduction

  • Excel 2010 VBA - Chapter 1 : Macro Development Basics output

    Excel 2010 VBA - Chapter 1 : Macro Development Basics output

  • Excel 2010 VBA - Chapter 2 : VBA Programming Fundamentals output

    Excel 2010 VBA - Chapter 2 : VBA Programming Fundamentals output

  • Excel 2010 VBA - Chapter 3 : Working with Control Structures output

    Excel 2010 VBA - Chapter 3 : Working with Control Structures output

  • Excel 2010 VBA - Chapter 4 : Using VBA Functions output

    Excel 2010 VBA - Chapter 4 : Using VBA Functions output

  • Excel 2010 VBA - Chapter 5 : Creating UserForms output

    Excel 2010 VBA - Chapter 5 : Creating UserForms output

  • Excel 2010 VBA - Chapter 6 : Debugging Techniques output

    Excel 2010 VBA - Chapter 6 : Debugging Techniques output

  • Excel 2010 VBA - Conclusion

    Excel 2010 VBA - Conclusion