Excel VBA Programming - the Complete Guide - Online course

Includes

18 hours on-demand video

3 articles1

downloadable resource

Full lifetime access

Access on mobile free app

TV Assignments

Certificate of Completion

What you'll learn

Automate tasks and procedures in Excel using Visual Basic for Applications

(VBA)Utilize the objects in the Excel Object Model to emulate user actions in Excel

React dynamically to user events like entering a cell value or opening a workbook

Feel comfortable with the fundamentals of computer programming

Description

Welcome to Excel VBA Programming - The Complete Guide, Udemy's most comprehensive VBA course!

Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like 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'll 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

The Workbooks and Workbook Objects

The Worksheets and Worksheet ObjectsRange References

Range ActionsConditional LogicIteration

AlertsConfiguring Excel FunctionalityCustom Functions

Arrays

Debugging

Even Procedures

User Forms

In addition to the video content, the course is packed with dozens of quizzes, challenges, and assignments to test your knowledge of your material as you progress.

No programming experience is required -- complete beginners are more than welcome! VBA is a great language to start with because you can 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 the redundancy in your workflow and accelerate your productivity drastically!

Thanks for checking out the course!

Who this course is for:

Spreadsheet users who want to automate their daily workflow

Business analysts who want to remove redundancy from their common tasks

Excel users who are curious about exploring programming in a familiar work environment