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