VBA & Macros for Business Automation
Master Excel VBA & Macros to automate repetitive tasks, generate custom functions, and run complex operations.
Taught by Instructors with Experience At
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
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
- Course Overview
- What is VBA and What its Used For
- Important Excel & VBA Settings
- VBA Glossary
- VBA Keyboard Shortcuts
- 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
- Object Model
- Object Properties
- Object Methods
- Object Library
- Testing Objects with the Immediate Window
- 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
- Introduction to Variables
- Variable Declarations in VBA
- Scoping Variables
- Object Variables
- Working with Collections
- Commenting Code
- Case Study Part 1
- Case Study Part 2
- 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
- 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
- Arrays Overview
- One Dimensional Arrays
- Two Dimensional Arrays
- Dynamic Arrays
- Maintaining Array Values
- Variant Arrays
- Case Study: Employee Commission
- 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
- 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
- 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
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!
Excellent Experience!
David Rodrigues
Makes sense!
Ikmareka Hunt
I love that it's interactive
Ashley Thompson
Exceeded my expectations
Khin Yaminn
Exceptional Training Solution!
Michael Penna
Extremely Impressed
Josh McDonald
The Best!
Jasmine Akujobi
Amazing Course!
Erik Reznicek
Highly Recommend!
Yakuphan Alptekin
Very Valuable
Robert Remondino
Amazing, Detailed and Realistic!
Ishaan Mathur
Great Explanations!
Jamie Forschner
Just What I was Looking For!
Rashed Al-Romaithi
Thank you!
Keith Aul
Excellent
Bilal Kamara
Very, very helpful!
Marco Horn
I like this course and recommend it
Tom Munt-Davies
Great job!
Marco Franceschini
Super Helpful!
Isabella West
Cheers!
Marvel Tanudjaja
Clear Explanations!
Russell Tankoua
Worth the Money!
Jamaal Tobias
A Very Complete Course!
Teo Ballbe
Perfect!
Murilo Cangueiro
Wonderful Course!
Ebenezer Anane
Awesome Course!
Andy Giro
Just What I Needed!
Daniel Mwabila
Well Done!
Tristan Chiu
Great Content!
Naseef Kamal
Informative
Tam Tran
Keep up the good work!
Jennifer Ng
Awesome learning Power BI
Jim Brooks
Great stuff!
David H
Excellent
Joseph Daher
This course is worth it!
Selasi Kwame
Clear, concise instruction
Matt Pounch
I cannot recommend their courses highly enough!
Justin Galczynski
Well paced
Reeta Sooknah
I do recommend it!
Vladimir Sobur
Beginner friendly
Julian Mascio
Engaging
Justin Risin
Recommend to those in finance
Aditiya Kusuma
I grow tremendously
Antonio Newman
Very detailed
Steven Huang
Great course
Tim Lorentz
Learned a lot
Hai Nguyen
Our Students Now Work At
Your instructors
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!
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.
Learn the skills you need to advance your career
Select the course or bundle that works best for you
- {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
- {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
FAQs
Frequently Asked Questions
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.
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.
This course is designed for beginners and intermediate users. If you have previous experience with VBA programming, consider skipping the first module.
No prior business or technical knowledge is required, but most students will start VBA with a basic understanding of Excel and its capabilities.
You will have lifetime access to the lessons and materials. The course can be taken on both smartphone and computer.
For any other general inquiries, please contact us at info@careerprinciples.com