Excel VBA Programming - The Complete Guide [Video]

4.5 (4 reviews total)
By Boris Paskhaver
    What do you get with a Packt Subscription?

  • Instant access to this title and 7,500+ eBooks & 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 is a NYC-based web developer and software engineer with experience in 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 years 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 struggled with the traditional resources available for education. His goal is to create comprehensive courses that break down complex details into small, digestible pieces.

    Browse publications by this author

Latest Reviews

(4 reviews total)
Very informative & easy to follow
Super Service! Fast delivery.
The tutorial are clear and easy to understand.

Recommended For You

Excel VBA Programming - The Complete Guide [Video]
Unlock this video and the full library FREE for 7 days
Start now