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
Clear, concise instruction
Matt Pounch
Excellent
Joseph Daher
Beginner friendly
Julian Mascio
Learned a lot
Hai Nguyen
Loving It...
Peggy Martes
Informative
Tam Tran
I love that it's interactive
Ashley Thompson
Great Explanations!
Jamie Forschner
Well paced
Reeta Sooknah
Great course!
Cristine Ramos
Engaging
Justin Risin
The Best!
Jasmine Akujobi
Exceeded my expectations
Khin Yaminn
More than I Expected
Nour Eldin
Just What I was Looking For!
Rashed Al-Romaithi
Excellent Learning Experience
Dinah Fojas
Great stuff!
David H
Cheers!
Marvel Tanudjaja
Perfect!
Murilo Cangueiro
Amazing, Detailed and Realistic!
Ishaan Mathur
This course is worth it!
Selasi Kwame
Amazing Learning Platform
Samantha Li
Thank you
Evelyn Tah
I grow tremendously
Antonio Newman
Very, very helpful!
Marco Horn
Very detailed
Steven Huang
Well Organized
Hyascar Jesus Vargas Zelada
Superb Work
Johnny Chowdhury
Awesome Practice
Rupali Kapadia
Thank you, so much.
Katia Rues
Exceptionally Helpful
Garay
Pretty Good
Raghav Wasan
Easy to Follow
Oscar Pessoa Rivero
Exceptional Training Solution!
Michael Penna
I cannot recommend their courses highly enough!
Justin Galczynski
Enjoying it!
Yuling Zheng
Good for All Users
Tooma Tawita
Clear Explanations!
Russell Tankoua
Worth the Money!
Jamaal Tobias
Extremely Impressed
Josh McDonald
Well Done!
Tristan Chiu
I LOVE THE TRAINING PROGRAM
George Taylor
Awesome learning Power BI
Jim Brooks
Great Information and Details
Chris Sticklett
Easy to follow
Michael Dos Santos
Very well structured course
Will
Thank you!
Keith Aul
Strongly Recommend
Robert Wirima
Thoroughly Enjoyed Power BI
Selina Chee
Recommend to those in finance
Aditiya Kusuma
Worth Every Penny
Molly Dadzie
Excellent Experience!
David Rodrigues
Great Course on SQL
K R
Top Experience
Guillem Bigordà Freixas
Definitely recommend it!
Arif Rashid
Makes sense!
Ikmareka Hunt
Super Helpful!
Isabella West
Highly Recommend!
Yakuphan Alptekin
I do recommend it!
Vladimir Sobur
Very Valuable
Robert Remondino
Great job!
Marco Franceschini
Wonderful Course!
Ebenezer Anane
Excellent
Bilal Kamara
Keep up the good work!
Jennifer Ng
I like this course and recommend it
Tom Munt-Davies
Great Overview
Amanda Osmer
Awesome Course!
Andy Giro
Highly Recommend
J Lee
Great Content!
Naseef Kamal
Amazing Course!
Erik Reznicek
Great course
Tim Lorentz
A Very Complete Course!
Teo Ballbe
I Honestly Love It
Mitch Saffle
Wise Decision to Purchase
Jamaal T
Outstanding!
Linda Fligg
Just What I Needed!
Daniel Mwabila
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
🎁 Did you say free bonuses?
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.
Yes, this course is accredited by the CPD Certification Service. Career Principles is a certified CPD member.
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