Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2019 VBA Full Course Tutorial

Learnit Training via YouTube

Overview

This course on Excel 2019 VBA aims to teach users how to automate repetitive processes and build tools in Excel using Visual Basic for Applications (VBA). By the end of the course, learners will be able to create macros using essential VBA concepts such as Loop, If Then, and other complex functions. The course covers topics like Procedures and Functions, Expressions, Variables, Intrinsic Functions, Controlling Program Execution, Forms and Controls, Pivot Tables in VBA, and Code Debugging. The intended audience includes Business Analysts, Data Scientists, and anyone interested in expanding their Excel skills to include automation and customization through VBA. The teaching method involves a step-by-step approach, starting from recording macros to building custom macros with VBA.

Syllabus

VBA Overview/Getting Started
Procedures and Functions
Expressions, Variables, and Intrinsic Functions
Controlling Program Execution
Forms and Controls
Pivot Tables in VBA
Code Debugging

Taught by

Learnit Training

Reviews

Start your review of Excel 2019 VBA Full Course Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.