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

Zero To Mastery

Introduction to Excel Automation: Excel Macros and VBA

via Zero To Mastery

Go to class Write review

Overview

Learn to wield the power of Excel Macros and VBA to automate, streamline, and master data in Excel. All from scratch!
  • Understand the fundamentals of Excel Macros and how to automate repetitive task.
  • Learn the basics of Visual Basic for Applications (VBA) programming to create custom solutions in Excel
  • Develop practical skills to write, edit, and debug Excel Macros and VBA code effectively
  • Master the ability to build dynamic and interactive Excel applications to enhance productivity

Syllabus

  •   Introduction
    • Introduction - Hello World
    • A Note to Mac Users
    • Exercise: Meet Your Classmates and Instructor
    • Course Resources
    • Cheatsheet
  •   Introducing Excel Macros and VBA
    • Opening Macro-Enabled Files
    • Editing Macros
    • Subroutine Structure
    • Buttons and Shapes
    • The Personal Workbook
    • Exercise: Introducing Macros and VBA
  •   Variables and User Input
    • Introducing Variables
    • Using Variables in Expressions
    • Option Explicit
    • Gathering User Input
    • Gathering User Input - A More Complex Example
    • Exercise: Variables and User Input
  •   Programming in VBA
    • Comments
    • Error Handling With IF Statements
    • Branching Logic With Else and ElseIf
    • Formatting Code
    • Naming Conventions
    • Using Worksheet Functions in VBA
    • User Defined Functions - A Simple Example
    • User Defined Functions - A More Complex Example
    • Converting UDFs to Add-Ins
    • Objects, Properties and Methods
    • Exercise: Programming in VBA
  •   Where To Go From Here?
    • Review This Byte!

Taught by

Travis Cuzick

Reviews

Start your review of Introduction to Excel Automation: Excel Macros and VBA

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.