YoVDO

Excel 2019 VBA Full Course Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses Pivot Tables Courses Macros Courses Excel VBA Courses

Course Description

Overview

Embark on a comprehensive 7-hour tutorial to master Excel 2019 VBA. Dive into the world of Visual Basic for Applications, learning to automate repetitive processes and create custom tools in Excel. Begin with foundational concepts, progressing from recording simple macros to building complex functions using loops, conditional statements, and advanced VBA techniques. Explore key topics including VBA overview, procedures and functions, expressions and variables, program execution control, forms and controls, pivot tables in VBA, and code debugging. Ideal for business analysts, data scientists, and Excel enthusiasts seeking to expand their capabilities and write their own rulebook for Excel automation.

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

Related Courses

Excel 2010
Miríadax
Excel Avanzado
Miríadax
Problem Solving with Excel
PwC via Coursera
Excel: gestión de datos
Universitat Politècnica de València via edX
Excel によるデータの分析と可視化
Microsoft via edX