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!
What our students say
Awesome Course!
Andy Giro
Well paced
Reeta Sooknah
Well Done!
Tristan Chiu
I love that it's interactive
Ashley Thompson
Exceptional Training Solution!
Michael Penna
Highly Recommend!
Yakuphan Alptekin
Amazing, Detailed and Realistic!
Ishaan Mathur
Thank you!
Keith Aul
Keep up the good work!
Jennifer Ng
Engaging
Justin Risin
Very Valuable
Robert Remondino
Awesome learning Power BI
Jim Brooks
Just What I Needed!
Daniel Mwabila
Excellent
Joseph Daher
I do recommend it!
Vladimir Sobur
Very detailed
Steven Huang
This course is worth it!
Selasi Kwame
The Best!
Jasmine Akujobi
Perfect!
Murilo Cangueiro
Amazing Course!
Erik Reznicek
Great stuff!
David H
Super Helpful!
Isabella West
Exceeded my expectations
Khin Yaminn
Great Explanations!
Jamie Forschner
Wonderful Course!
Ebenezer Anane
I cannot recommend their courses highly enough!
Justin Galczynski
A Very Complete Course!
Teo Ballbe
Great job!
Marco Franceschini
I like this course and recommend it
Tom Munt-Davies
Makes sense!
Ikmareka Hunt
Very, very helpful!
Marco Horn
Recommend to those in finance
Aditiya Kusuma
Clear Explanations!
Russell Tankoua
Beginner friendly
Julian Mascio
Clear, concise instruction
Matt Pounch
Excellent
Bilal Kamara
Cheers!
Marvel Tanudjaja
Excellent Experience!
David Rodrigues
Great course
Tim Lorentz
Just What I was Looking For!
Rashed Al-Romaithi
Learned a lot
Hai Nguyen
Worth the Money!
Jamaal Tobias
Extremely Impressed
Josh McDonald
Informative
Tam Tran
I grow tremendously
Antonio Newman
Great Content!
Naseef Kamal
Our Students Now Work At
Meet Your Instructors
Kenji Farre
Michael Quach
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