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

Zero To Mastery

VBA Programming Bootcamp: Zero to Mastery

via Zero To Mastery

Go to class Write review

Overview

The only course you need to learn VBA Programming and master data analysis with Excel. Learn VBA Macros, Variables, Userforms, Loops, Arrays, Pivot Tables, and much more. This course will give you the skills you need to start a career in Data Analytics and get hired.
  • Become a top 10% Data Analyst and Excel Power User to enhance your skillset and career opportunities
  • Build an enterprise-level Data Management System that turns a manual, error-prone process into a sleek user experience that maintains the data integrity required in the business world
  • Automate your day-to-day tasks through efficient VBA Macros
  • Analyze large datasets with powerful Excel Pivot Tables
  • Use Excel for rapid development of data-driven applications
  • Learn how to build Excel formulas for data analysis, data science, data entry, and everyday office use
  • Learn how to work with external datasets
  • Data entry tips and tricks
  • Learn why Excel is one of the most popular pieces of software across all industries
  • Start or supplement your programming journey by recording VBA Macros in Excel

Syllabus

  •   Introduction
    • VBA Programming
    • Exercise: Meet Your Classmates and Instructor
    • How-to's: Speed up videos, Downloading videos, Subtitles
  •   Introducing Macros and VBA
    • A Note to Mac Users
    • Hello World - Introducing Macros
    • Opening Macro-Enabled Files
    • Editing Macros
    • Subroutine Structure
    • Buttons and Shapes
    • The Personal Workbook
    • Exercise: Introducing Macros and VBA
    • Unlimited Updates
  •   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
  •   Userforms
    • Introducing Userforms
    • Adding Functionality to Userforms
    • Enhancing Userforms With Option Buttons
    • Enhancing Userforms With Combo Boxes
    • Exercise: Userforms
    • Combining Multiple Userforms
    • Introducing the InfoManager Project
    • InfoManager Part 1 - Intro
    • InfoManager Part 1 - Solution
  •   Working With Ranges in VBA
    • Targeting Ranges With VBA
    • Advanced Methods For Targeting Ranges
    • Properties and Methods of Ranges
    • Exercise: Working with Ranges
    • Exercise: Imposter Syndrome
    • Dynamic Methods For Targeting Ranges
    • Capturing Ranges As User Input
    • Writing Formulas With VBA
    • InfoManager Part 2 - Intro
    • InfoManager Part 2 - Solution
  •   Loops
    • Do Loops
    • Debugging Tools
    • Validating User Input With Do Loops
    • For Next Loops
    • Nested Loops
    • For Each Loops
    • Loops - Example Subroutine
    • Loops - Example UDF
    • Exercise: Loops
    • InfoManager Part 3 - Intro
    • InfoManager Part 3 - Solution
  •   Arrays
    • Introducing Arrays
    • Dynamic Arrays With ReDim Preserve
    • The SPLIT Function
    • Exercise: Arrays
    • InfoManager Part 4 - Intro
    • InfoManager Part 4 - Solution
  •   Worksheets and Workbooks
    • Working With Worksheets
    • Iterating Through Worksheets
    • Consolidating Worksheets
    • Working with Workbooks
    • The Workbooks Collection
    • Opening Multiple Workbooks
    • Consolidating Workbooks
    • Worksheet and Workbook Events
    • Exercise: Worksheets and Workbooks
    • InfoManager Part 5 - Intro
    • InfoManager Part 5 - Solution
  •   Pivot Tables
    • External Data and VBA
    • Controlling Pivot Tables With VBA
    • Exercise: Pivot Tables
    • InfoManager Part 6 - Intro
    • InfoManager Part 6 - Solution
  •   Where To Go From Here?
    • Thank You!
    • Review This Course!
    • Become An Alumni
    • Learning Guideline
    • LinkedIn Endorsements
    • Coding Challenges

Taught by

Travis Cuzick

Reviews

Start your review of VBA Programming Bootcamp: Zero to Mastery

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.