Excel 2007 VBA

Learn Excel VBA automation techniques to enhance your workbooks. Master macro programming, variable declaration, control structures, and debugging tools in this comprehensive course.

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course is all about using VBA to supercharge your Excel workbooks. You'll learn to make macros, handle programming basics, and fix code hiccups easily. It's like giving your spreadsheets a cool turbo boost!

Key Points

  • Learn how to use Visual Basic for Applications (VBA) in Excel.
  • Get to know the object model of Excel.
  • Record and run your own macros.
  • Understand programming basics and how to declare variables.
  • Play with loops, functions, and create Userforms.
  • Dive into debugging tools in the VBA editor.

Learning Outcomes

  • You'll be able to create and edit macros.
  • You'll gain a solid grasp of Excel's object structure.
  • You’ll learn proper variable declaration like a pro.
  • You’ll master loops and functions to automate tasks.
  • You’ll know how to debug your code smoothly.

About This Course

Power up your workbooks with Visual Basic for Applications automation

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.

  • Understand the object model

  • Create, edit and run recorded macros

  • Understand the Visual Basic editor

Course Curriculum

1 Lectures

2 Lectures

1 Lectures

Instructor

Profile photo of Intellezy Trainers
Intellezy Trainers

Intellezy collaborates with organizations to help implement and adopt technology to its full potential. Our online videos include 250+ courses designed to educate and empower individualsOur library, recognized by top influencers such as The Craig Weiss Group, Training Industry and eLearning Journal, provides dynamic and task-focused videos, quick reference guides, and assessments right at your fingertips, right when you need...

More Courses By Intellezy Trainers
Review
4.9 course rating
4K ratings
ui-avatar of Heli Balassiano
Heli B.
5.0
5 years ago

i think that its very clear and help me very much to learn what i planed to learn. thanks a lot i like it:)

  • Helpful
  • Not helpful
ui-avatar of Jan E
Jan E.
5.0
7 years ago

Very clear instructions. Instructor never use any filler words or say anything that is not on topic ... Hope it continues like this

  • Helpful
  • Not helpful
ui-avatar of Gergely Kocsis
Gergely K.
5.0
8 years ago

Everything was clear, I got all the explanations in every lesson.
Maybe the only thing I miss is the downloadable content per lessons, e.g. a text file which contains the macro which is being presented. But it may not do things faster. Thank you.

  • Helpful
  • Not helpful
ui-avatar of Womberbat
Womberbat
3.5
8 years ago

Good video, very easy to follow along

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses