Excel VBA Programming - The Complete Guide

Preview this course

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
162 on-demand videos & exercises
Level: Intermediate
English
17hrs 19mins
Access on mobile, web and TV

What to know about this course

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

Who's this course for?

This course is for spreadsheet users who want to automate their daily workflow and business analysts who want to remove redundancy from their common tasks. Excel users who are curious about exploring programming in a familiar work environment will also benefit from the course.

What you'll learn

  • Automate tasks and procedures in Excel using Visual Basic for Applications (VBA).
  • Utilize objects in the Excel Object Model to emulate user actions in Excel.
  • React dynamically to user events such as entering a cell value or opening a workbook.
  • Get comfortable with the fundamentals of computer programming.

Key Features

  • Intermediate knowledge of popular Excel features and basic knowledge of data types is required to take this course.

Course Curriculum

About the Author

Boris Paskhaver

Boris Paskhaver is a New York City-based software engineer, author, and Udemy instructor with a unique journey into tech. Graduating from NYU in 2013 with a degree in Business Economics and Marketing, he initially worked in various roles, including business analyst and data analyst, at several companies. His coding journey began accidentally while building projects with Python and JavaScript, leading him to passionately pursue programming. Without formal computer science education, Boris completed App Academy's full-stack web development bootcamp, diving headfirst into web development. As an instructor, Boris focuses on creating comprehensive, easy-to-understand courses, addressing the challenges he faced learning to code. He's driven by the intersection of technology and education, aiming to make programming accessible to all. Boris brings this passion to his teaching, helping others unlock the potential of coding.

40% OFF! Unlimited Access to 750+ Courses. Redeem Now.