Excel VBA Programming - The Complete Guide [Video]

5 (1 reviews total)
By Boris Paskhaver
    Advance your knowledge in tech with a Packt subscription

  • Instant online access to over 7,500+ books and videos
  • Constantly updated with 100+ new titles each month
  • Breadth and depth in over 1,000+ technologies
  1. Getting Started

About this video

Welcome to Excel VBA Programming–The Complete Guide, the most comprehensive VBA course! Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications such as Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA!

Over the course of more than 18 hours of content, we cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:

• The Excel Object Model

• The Visual Basic Editor

• Objects and methods

• Variables and data types

• Writing your own procedures

• Workbooks and workbook objects

• Worksheets and worksheet objects

• Range references

• Range actions

• Conditional logic

• Iteration

• Alerts

• Configuring Excel functionality

• Custom functions

• Arrays

• Debugging, even procedures, and user forms

No programming experience is required; complete beginners are more than welcome! VBA is a great language to start with because it lets you master the fundamentals of programming in a familiar work environment. No extra software is necessary: VBA is bundled with all modern versions of Excel. Excel is the World's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove redundancy in your workflows and accelerates your productivity drastically! Thanks for checking out this course!

All the code and supporting files for this course are available at - https://github.com/PacktPublishing/Excel-VBA-Programming---The-Complete-Guide

Publication date:
August 2019
Publisher
Packt
Duration
17 hours 19 minutes
ISBN
9781839214240

About the Author

  • Boris Paskhaver

    Boris Paskhaver - Software Engineer - NYC-based web developer with experience building apps in React / Redux and Ruby on Rails. Raised in New Jersey, he graduated from the Stern School of Business at New York University in 2013 with a double major in Business Economics and Marketing. Since graduation, his work has taken him in a wide variety of directions -- he spent a year in marketing, then financial services, and now the tech industry. He has worked everywhere from a 50-person digital agency to an international tech powerhouse with thousands of employees. He always had a love of learning but have struggled with the traditional resources available for education. He used that as inspiration for my work here. His goal is to create comprehensive courses that break down the complex details into small, digestible pieces.

    Browse publications by this author

Latest Reviews

(1 reviews total)
I purchased Excel VBA course video. Boris has done a great job in explaining the subject. At $7.9 it is value for money.

Recommended For You

Book Title
Unlock this video and the full library for FREE
Start free trial