Stop repeating recurring tasks. Learn the skills to turn your manual Excel tasks into the push of a button.
Freecontent below!
Learn More
Excel VBA is a great way to multiply your time savings by automating processes. This course builds a solid foundation in both coding basics and Excel specific objects. Techniques are influenced by object-oriented principles so that projects may be used across Excel workbooks. You won’t regret learning how to program. A strong foundational knowledge of Excel is recommended before taking this course (see Excel Course 1 and 2).
3.5 hours of high-quality video
Before/After files
PDF slides and reference sheets
Hands-on exercises
Disclaimer!
Introduction
Watch Preview
Visual Basic Editor
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Watch Preview
Procedures ("Macros") and Variables
Watch Preview
Macros
Exercise 1
Watch Preview
Ranges: The Backbone of Excel
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 2
Watch Preview
Create a Macro from Scratch
Free!
Click to watch a lesson
Free!
Click to download lesson slide(s)
Exercise 3
Watch Preview
Control Flow
Exercise 4
Wrap Up
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
What others are saying about this course!
“The amount of time needed to invest in a new skill like programming was always a turn off for me; however, after seeing a demo, I knew I needed to make time for this. The time I’ve saved automating my work processes is immeasurable. I’m so much more engaged in my work now that the monotonous tasks are out of the way. So glad I took this course.” -David
“Learning VBA not only helped me save tons of time but also taught me more about native Excel capabilities. Definitely a delighter which amplified my toolbox.” -Amber
“I worked with Matt to literally automate my 6-hour Monday task into less than 5 minutes, which was a matter of waiting for external servers to return GET/POST requests. I get back almost an entire day’s worth of work, and I no longer dread Mondays.” -Barry
“We needed to automate our trading strategy model. We spent over 30 minutes refreshing and updating one model. With over 200 stocks on our watch list, it is impossible to refresh each week. Not only can we update our Excel based model without touching the VBA, but we can also run all 200 stocks on our watch list each week in a matter of minutes.” -Susan
Matthew’s 15 years of experience spans Investment Banking, Corporate Finance, and Programming across Banking, Retail, Consumer Products, and eCommerce.
BizTrix offers the ability to mix and match course content to address team needs, including on-site trainings.
Learn More
If you are looking to level up your Excel skills by automating processes, then these courses are for you. VBA is not for the casual Excel user. You should have a solid understanding of Excel before starting VBA.
Anyone who repeats a recurring process in Excel should take this course. We’ve automated recurring reports, built macros for to format table information via shortcut keys, extracted point-of-sale information from retail partners using GET/POST requests, and more. You can too with VBA.
If you are unsatisfied with the course, let us know. We’ll refund your purchase provided you contact us within 30 days of purchase and refrain from watching more than 25% of course content.
Microsoft built its software for PC platforms, so full functionality is designed for PCs. Thus, courses are designed and taught with a PC. Shortcut keys may be different across PC and Mac, but functionality is nearly identical, and the techniques are agnostic. For example, Ctrl+S (PC) = Command+S (Mac). Some references aren't avilable for Mac (such as Microsoft Scripting Runtime), but those objects can be written in VBA.
We accept payment via Stripe. All payments are processed securely using 128-bit SSL encryption. Furthermore, we encrypt all the data passing between our site and your device using HTTPS.
Don't miss out on any updates and new courses that are coming soon!
