No items found.

VBA & Macros for Business Automation

Master Excel VBA & Macros to automate repetitive tasks, generate custom functions, and run complex operations.

play icon

Taught by Instructors with Experience At

Overview

What you’ll learn

This beginner-friendly course will teach you how to build custom procedures that can complete painful 3-hour tasks with a simple click of a button. We’ll start with the fundamental coding principles and then gradually progress to more advanced modules covering code loops, data arrays, user input boxes, and more. Throughout the course, we’ll introduce real-life exercises and case studies that will allow you to auto-generate pivot tables, streamline chart creation, and extract and summarize data. The comprehensive case studies include built-from-scratch tutorials on a PwC billing summary file and a Mercedes Benz P&L creation tool.

80+ High Quality Lessons

Downloadable Excel and PDF Files

Built-From-Scratch Business Automation Projects

Lifetime Access on Any Device

Student Profiles

Who are these courses for?

University Students

If you're a college student looking to secure an internship or full-time job in a top tier business, finance, or investment firm, these courses are for you.

Working Professionals

If you're a working professional looking to level up your technical career skills, these courses are for you.

Career Switchers

If you're looking to boost your technical skills to better your chances of switching into a business or finance role, this course is for you.

Build practical business automation tools

Assemble and combine loops, arrays, filters, and other key functions and methods to create coding procedures that will run complex, time-consuming tasks in less than a second. This includes automating the calculations and formatting of raw data exports commonly used by many corporate business analysts.

Create complex data summarization projects

Apply conditional statements, collections, and a range of debugging tools and techniques to build best-practice habits. Step-by-step, students will learn the fundamental programming concepts needed to build dynamic, reusable code applicable to data-oriented spreadsheet tasks.

Practical lessons designed for your business career

Our courses are specifically tailored to current or aspiring professionals in business, finance, and other corporate office teams. This includes financial analysts, business analysts, operations analysts, data analysts, and strategy analysts among many others.

Course Curriculum

Module 1: Course Introduction
  • Course Overview
  • What is VBA and What its Used For
  • Important Excel & VBA Settings
  • VBA Glossary
  • VBA Keyboard Shortcuts
Module 2: Macros & VB Editor
  • Create your First Macro
  • More Macros & Macro Buttons
  • VB Editor (VBE) & Window Setup
  • Creating Macro with VBE Open
  • Absolute vs Relative Macro recording
  • Adding a Macro to your ribbon & quick access toolbar
Module 3: Objects
  • Object Model
  • Object Properties
  • Object Methods
  • Object Library
  • Testing Objects with the Immediate Window
Module 4: Referencing and Custom Functions
  • Sub Procedures vs Function Procedures
  • Basic Custom Function & Sub procedure Example
  • Referencing Ranges
  • Referencing Worksheets
  • Referencing Workbooks
  • Range Properties & Methods
  • Properties & Methods Exercise
  • Case Study Part 1
  • Case Study Part 2
Module 5: Variables
  • Introduction to Variables
  • Variable Declarations in VBA
  • Scoping Variables
  • Object Variables
  • Working with Collections
  • Commenting Code
  • Case Study Part 1
  • Case Study Part 2
Module 6: Errors & Code Debugging
  • Breakpoints & Code Step Through
  • Declaring Variables - Option Explicit
  • Find and Replace in VBA code
  • Using debug.print & Immediate Window
  • Using Locals Window & Watch Window
  • Error Message: Using On Error
  • Mini Case Study: Find the Bugs
Module 7: VBA Key Statements & Functions
  • If Then Formula
  • AND OR Statement
  • Select Case
  • With & End With
  • Goto Statement
  • For Each Loop
  • For Next Loop
  • Do while & Do Until Loops
  • Text Functions
  • Formatting Functions
  • Date Functions
  • Worksheet Functions
  • Case Study: Data Table Compiler
Module 8: Arrays
  • Arrays Overview
  • One Dimensional Arrays
  • Two Dimensional Arrays
  • Dynamic Arrays
  • Maintaining Array Values
  • Variant Arrays
  • Case Study: Employee Commission
Module 9: Other VBA Features
  • Message Box
  • VBA Input Boxes
  • Excel Input Boxes
  • Excel Tables
  • Pivot Tables
  • Charts & Visuals
  • Calling Other Procedures (Public vs Private)
  • Transferring Arguments & Global Variables
  • Case Study: McDonald’s Mini Table & Chart Tool
Module 10: PwC Billing Report Case Study
  • Case Study Overview
  • Billing Amount Total
  • Billing Amount Percentage
  • Sorting and Formatting
  • Sheet Looping
  • Extracting Unique Names
  • Placing Summary Names
  • Collecting and Placing Billing Amounts
  • Calculate Summary Billing Amount Total
  • Calculate Summary Percentages
Module 11: Mercedes Benz P&L Case Study
  • Finance Case Study Overview
  • Collect Unique P&L Line Labels
  • Calculate Global P&L Revenue & Expenses
  • Calculate Global P&L Key Income Lines
  • Fill Regional P&Ls
  • Global P&L Detail Expansion: Collecting Unique Classes
  • Global P&L Detail Expansion: Inserting New Rows
  • Regional P&L Detail Expansion
Get Certified!

Impress recruiters with your resume

Upon completion of all course lessons, you will receive a digital certificate with your credentials. Furthermore, you can add it to your LinkedIn to show your skills to recruiters!

career principle certificate
Testimonials

What our students say

This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.
This is some text inside of a div block.

Heading

This is some text inside of a div block.

Our Students Now Work At

Instructors

Meet Your Instructors

Kenji Farre

Senior Instructor
Hey there, I’m Kenji, a Cornell University graduate and Microsoft MVP with work experience at companies like Amazon, Goldman Sachs, and PwC. Over the past year, our tutorials have helped 15M+ people level up their Excel, Business, and Data skills. I know exactly where the pain points are -I’ve lived them myself. Looking forward to getting started!

Michael Quach

Senior Instructor
Aloha! I’m Michael, a Cornell University graduate born and raised in Honolulu, Hawaii. I’ve worked at companies like Tesla, Cushman & Wakefield, and IHG Hotels & Resorts. Throughout, I’ve experienced first-hand the importance of being proficient in Excel, finance, and valuation to perform in any business role. My hope is that our courses will help you take your career to the next level.
Course Pricing

Learn the skills you need to advance your career

Select the course or bundle that works best for you

VBA & Macros for Business Automation
Single Course
Was:
$149.00
Includes:
  • {yes} Access to Full VBA Curriculum
  • {yes} VBA Course Completion Certificate
  • {yes} VBA Glossary & Shortcuts Guide
  • {yes} Automating Pivot Tables, Charts, and other visuals
  • {yes} Business Case Study: PwC Monthly Billing Summary Report
  • {yes} Finance Case Study: Mercedes Benz P&L Tool
  • {no} Access to Full Excel Curriculum
  • {no} Excel Course Completion Certificate
  • {no} Case Study: Excel Interview Test
  • {no} Case Study: Excel Interactive Dashboard
Get started
Excel + VBA for Business & Finance
Bundle
Was:
$279.00
Includes:
  • {yes} Access to Full VBA Curriculum
  • {yes} VBA Course Completion Certificate
  • {yes} VBA Glossary & Shortcuts Guide
  • {yes} Automating Pivot Tables, Charts, and other visuals
  • {yes} Business Case Study: PwC Monthly Billing Summary Report
  • {yes} Finance Case Study: Mercedes Benz P&L Tool
  • {yes} Access to Full Excel Curriculum
  • {yes} Excel Course Completion Certificate
  • {yes} Case Study: Excel Interview Test
  • {yes} Case Study: Excel Interactive Dashboard
Get started
No items found.

FAQs

Frequently Asked Questions

How long will this course take me to complete?

The course is designed for students to complete around 2 modules per week, for a total of 4-5 weeks until course completion. However, the course can be completed at your own pace (faster or slower) and you'll have unlimited access to the materials.

How is this course different from other VBA courses?

We’ve designed this course to help solve the real office business tasks that we’ve encountered as interns and full-time analysts at top-tier companies like Tesla, Amazon, and Goldman Sachs. Other courses tend to fill their curriculums with unrealistic theoretical examples that don’t consider important real-world business factors. With this in mind, we’ve created real-world exercises with our PwC billing summary file and Mercedes Benz P&L creation tool. We also include an interactive discussion forum to help students with additional inquiries.

What level of VBA experience do I need?

This course is designed for beginners and intermediate users. If you have previous experience with VBA programming, consider skipping the first module.

What are the pre-requisites for this course?

No prior business or technical knowledge is required, but most students will start VBA with a basic understanding of Excel and its capabilities.

How long will I have the course materials for?

You will have lifetime access to the lessons and materials. The course can be taken on both smartphone and computer.

More questions?

For any other general inquiries, please contact us at info@careerprinciples.com