Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel 2007 VBA
Rating: 4.5 out of 5(22 ratings)
192 students

Excel 2007 VBA

Power up your workbooks with Visual Basic for Applications automation
Created byIntellezy Trainers
Last updated 10/2016
English

What you'll learn

  • Understand the object model
  • Create, edit and run recorded macros
  • Understand the Visual Basic editor
  • Understand programming basics
  • Use Visual Basic functions
  • Create and use cotnrol structures
  • Create, use and edit UserForms
  • Debug macros and trap for errors

Course content

10 sections • 47 lectures • 4h 14m total length

  • Introduction2:43

Requirements

  • Intermediate Microsoft Excel training or equivalent experience

Description

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; recording macros, programming basics, proper variable declaration, Visual Basic functions, 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

Report abuse