The VBA Pro Course
The Step-by-Step System for Learning Macros & VBA
to Automate Excel & Build Awesome Applications
Learning Macros & VBA will take your Excel skills and career to the next level.
Watch the overview video below to learn more.
Why Learn Macros & VBA?
Learning VBA has had a tremendous impact on my career and helped put me in high demand with employers and clients. VBA is the programming language that we use to write macros and automate Excel. It allows us to really harness the power of this awesome application.
The VBA Pro Course is an online course that will teach you how to use VBA to:
- Save time with your job.
- Eliminate boring repetitive tasks.
- Take your career to the next level.
In the training, we learned about the story of our friend Andy. As his Excel skills were improving he was taking on more projects. But he didn't have time to complete all these projects manually.
This was the story of my life when I started using Excel on a daily basis in accounting and finance roles. I was doing a lot of the same tasks everyday. Updating the same report, copying data to a different spreadsheet, formatting exported data, etc.
Not only were these tasks boring, but also a waste of time!
Fortunately, Excel has an automation tool built right into it. Visual Basic for Applications (VBA) is the programming language we use to write macros and applications in Excel.
I started using VBA to write simple macros to automate quick tasks. This learning process was a lot of trial and error for me. I spent a lot of time searching the internet for solutions, and copying & pasting code.
I'll be honest, I didn't fully understand what I was doing when I started out.
Over the last 10 years I have learned a lot about VBA. I have used it to develop robust applications and add-ins. This has not only helped me save time, but also made me a valuable resource to my employers. I am able to build systems that are relied on to run the business on a daily basis.
This responsibility also gave me more freedom. I had more time to work on fun and creative projects that had a greater impact on the organization.
I was also able to go on vacation and not have to worry about teaching my co-worker that 28 step process I go through to update a report. Instead, I was able to write a macro that did it all with the push of a button.
Who Is This Course For?
I have designed The VBA Pro Course to take you from complete beginner to a VBA pro. That sounds like a tall order, and it is. However, you will learn in an easy step-by-step manner that will give you a solid understanding of the VBA language.
This course is for you if you answer YES to any of the following questions:
- Do you use Excel frequently in an accounting, finance, engineering, marketing, HR, or analyst role?
- Do you sometimes wish there was a faster way to update or format a spreadsheet?
- Are you stuck with the task of modifying a lot of files, doing the same task to each file?
- Do you want to build robust applications and add-ins to distribute to users?
- Do you want to profit from your ideas on how to make Excel better?
- Do you wish you could go on vacation on not have to worry about teaching your co-worker that 28-step process you do on Monday's, knowing they might screw it up...?
Just like Excel, there are an infinite number of uses for VBA. This course is designed to equip you with the skills to solve problems and be creative.
What Others Are
Saying About The Course
Accountant
I just went through the first two modules this morning and I was impressed. I was amazed that this was only the beginning of the course. I would consider myself average with VBA. I have written several programs and add-ins but most of that has been copying code here and there.
I learned more detail this morning than I ever expected from an intro. I thought the presentation was great. The video was clear and the audio quality was excellent.
I think the VBA Pro Course is a great fit for a wide range of Excel Users. If you use Excel regularly and have to do the same tasks every month then this course will help you automate those tasks.
If you've been using Excel for a long time (like me!) then this course will help you develop Userforms, automation apps, add-ins and the ribbon bar.
Overall, a professionally developed course, excellent interface and an easy-to-listen-to instructor. As you can tell, I highly recommend the course.
I've worked almost all the way through Module 1 and am learning new things even though I'd consider myself an intermediate VBA coder. Thanks for all the info and great presentation.
When I started this course I was only recording macros and avoiding variables like the plague. Now, I am writing my own VBA code and using variables to make it more efficient.
I am now the excel expert in the office and have increased my earnings well beyond the cost of the course. I have enjoyed the course and it's layout. It helps build a solid core of understanding and then builds upon it. I especially enjoy the assignments at the end of each module. This really helps cement the skills that have been taught.
Continuous Improvement Leader
I always wanted to learn VBA but was intimidated by it. I had bought all the books like macros for dummies etc. One day I just said I’m going to learn it. I came across one of Jon Acampora’s videos. Man he made it look so easy. He got me excited but learning again.
So, I bought his course. Since then I’ve gotten so good that I was able to change jobs and double my income. Thanks Jon for all you do and for providing a simple approach to learning how to program macros.
The course is amazing. I jumped into the deep end of the pool, but your lessons are clear and concise.
I have really enjoyed the course you put together! The progression of the course is very logical and the challenges are always a lot of fun!
I've learned so much and applied it to my day to day responsibilities. I was recently promoted to Finance Manager and I believe your class and my application of this things you taught within that class influenced that decision to promote me. I thank you!
What is an Online Video Course?
The VBA Pro Course is an online video course. This means you can watch the screencast videos any time you want, in the comfort of your own home or office.
- The course is is divided into 11 training modules.
- Each of these modules is comprised of 8-12 video lessons.
- Each video lesson contains a short 5-10 minute video that helps you build your knowledge and skills.
- You get 24/7 access to watch the videos from work, home, tablet, and smartphone. Videos can also be downloaded to watch offline.
In total, you are getting over 10 hours of videos that will take you from beginner to pro. The short videos also make it easy to come back and re-watch a video on a specific topic to get a refresher.
Step-by-Step Learning Keeps You On Track
Learning VBA can get overwhelming in a hurry. So I have designed this course to allow you to consume the content in bite-sized chunks.
This allows you to practice each concept and get a better understanding of what you are learning.
We start with the basics by learning the core concepts of the VBA language, and slowly progress to building robust applications and add-ins.
The short videos also make it easy to come back and re-watch a video on a specific topic to get a refresher. Plus, the course site tracks your progress to keep you organized. You will know right where you left the course next time you login.
The lessons come with companion Excel files so you can follow along with the videos and practice the techniques.
What Am I Going to Learn?
Here is a detailed list of
The 11 Traning Modules
Modules 1 & 2: Intro to Macros & VBA
Module 1 Syllabus | Videos: 10 | Total Duration: 50 min
Module 2 Syllabus | Videos: 10 | Total Duration: 49 min
Modules 1 & 2 are an intro to macros and VBA. If you're brand new to VBA then these modules will cover all the basics of the coding language and key concepts. We look at:
- How to create your first macro.
- Different ways to run macros.
- The Excel object model.
- How to reference and work with common objects like workbooks, worksheets, and ranges.
- The various ways to copy and paste with VBA, including the most efficient way.
- Variables and data types.
- And a whole lot more!
I've had people that have been coding VBA for years tell me they learned a lot from these modules, so it's not just for the beginner.
Module 3: The VB Editor & Excel for Development
Module 3 Syllabus | Videos: 5 | Total Duration: 30 min
In the Module 3 you will learn how to setup Excel for development, and how to use the VB Editor. The VB Editor is the application you will use to write the code and create userforms, and this module will explain how to use all the major components.
Modules 4 & 5: VBA Coding 101 & 201
Module 4 Syllabus | Videos: 11 | Total Duration: 34 min
Module 5 Syllabus | Videos: 14 | Total Duration: 68 min
In Modules 4 & 5 we take a deeper dive into coding with the VBA Coding 101 & Coding 201 sections. We use real world examples to learn coding techniques like:
If Statements - The foundation of programming and decision making.
Arrays - Drastically improve code performance and efficiency.
Variables - Declare and set variables to improve code readability and speed
Loops - Loop through collections of sheets, ranges, objects, & more.
Message & Input Boxes - Make your macros and applications interactive.
Error Handling - What does "On Error GoTo 0" mean?
After setting the foundation in the first half of the course, we spend the second half learning how to build applications and add-ins.
Once you understand how to write macros and automate simple processes, you will want to start tackling bigger, more complex projects. This can all be done with VBA by developing robust applications and add-ins.
Module 6: Designing Awesome Applications
Module 6 Syllabus | Videos: 2 | Total Duration: 17 min
In Module 6 we go over principles for designing awesome applications. You will learn the difference between macro enabled files and add-ins, and how to decide which one to use for your project.
"I am really enjoying your course. I haven't learned this much VBA since I started over a year ago.
VBA is Awesome!!!"
Modules 7 & 8: Building Userforms
Module 7 Syllabus | Videos: 15 | Total Duration: 62 min
Module 8 Syllabus | Videos: 10 | Total Duration: 38 min
In Modules 7 & 8 you will learn how to create Userforms. Userforms allow our applications to be more interactive and professional looking. You will learn how to program the different controls in the userform like buttons, textboxes, dropdowns, and more.
I also explain how to create the Google-like search box that I use in most of my applications. Users love this feature!
Module 9: Customize the Excel Ribbon
Module 9 Syllabus | Videos: 8 | Total Duration: 38 min
In Module 9 I explain how to add buttons to the Excel ribbon. You will learn about some of the different tools we can use to make this process easier and develop professional looking menus. I also explain how to customize the right-click menus so you can launch your forms and macros from anywhere in Excel.
Module 10: Creating Excel Add-ins
Module 10 Syllabus | Videos: 12 | Total Duration: 51 min
Module 10 is all about creating add-ins. Excel add-ins allow us to use our macros and applications on any workbook we have open. You can use add-ins to automate a simple process or create a robust application. You will also learn how to save user settings and distribute your add-ins to other users.
Bonus Module: Spreadsheet Based Apps
Module 11 Syllabus | Videos: 13 | Total Duration: 63 min
In Module 11 we build a spreadsheet based application I call the File Manager. This application allows you to automate processes of creating and modifying a set of files.
You can use this for just about any process where you want run the same macros on a large number of files. It will not only save you time, but also allow you to establish systems that your organization can rely on to get things done.
We also learn how to program Excel Tables with VBA. I explain all the great benefits of using Tables and working with them in VBA.
Some Awesome *Bonuses*
Just For You!
Bonus #1: Excel Companion Files
Along with the videos you are also getting the Excel files I use throughout the course. These files make it easy to follow along with the videos.
You will be able to step through the code to learn it, and also use the code in your own projects.
Bonus #2: The Best Course Software
The course site is very easy to use. It tracks your progress for you, allowing you to come back right where you left off. This keeps you organized and helps you focus your time on learning.
You can access the course anytime, from any device. Watch the videos on any tablet or smartphone.
Bonus #3: Comments Section on Every Lesson Page
Each page in the course has a comments section. You can ask questions here and also see what other students in the community are asking. I will be here answering your questions and helping you along the way.
Bonus #4: Certificate of Achievement
You will be emailed this awesome Certificate of Achievement when you complete the course. You can automatically post it to your LinkedIn profile, share it on social media, add it to your resume, and print & frame it.
This will help you market your new skills and let employers know that you are a certified Excel Superstar!
Your Instructor
Jon Acampora
Hi, my name is Jon Acampora and I am your instructor for this course.
I have been using Excel for over 10 years as financial analyst and systems developer. Over that time I have become passionate about learning Excel, and finding the fastest and most efficient ways to accomplish a task.
My interests with Excel cover a broad range of topics from data visualization to application development. I have developed dozens (if not hundreds) of VBA applications and add-ins.
I have been awarded the Microsoft MVP Award for my contributions to the Excel community and helping others learn.
More than anything, I really enjoy teaching you these skills and techniques to help you work efficiently and get your job done faster! I am always happy to help answer questions, and I'm here to support you on your journey to learn Excel (and impress your boss). 🙂
How Much Does The Course Cost?
Right now I'm offering lifetime access to The VBA Pro Course for $347 $297.
I love online video courses because they allow me to provide you with training at a much lower price than live in-person seminars.
A 3-day seminar can run well over $3,000, not to mention travel costs and the fact that you typically have to sit in a stuffy conference room with so many distractions, that you probably end up retaining about 5% of what was taught...
With the VBA Pro Course you can watch the videos any time you want, ask me questions, and be part of a much larger community of learners.
It's a fantastic way to learn because you are able to pause the instruction and go practice what you've learned. Every task is different, and it is great to be able to practice what you have learned on your own work.
Plus, you get lifetime access to the course. This means you can use it as a resource in the future as you continue to learn VBA.
You can access the course from your work computer, home computer, tablet, smart phone or any device with a web browser.
There's no risk with my 30-day Money-Back Guarantee
My goal is to help you learn VBA so you can automate Excel and take your career to the next level. I want you to love this course and use it as a resource for continued learning. If you take the course and are not satisfied with what you learned, you can get a full refund.
There are no hoops to jump through. If you're not smiling, then I want to know about it. 🙂
Get Me Started Already!
Here's what you need to do to get started. Choose a package below and click the Enroll Now button.
- Fill out the secure payment form. You will also create an account for the Excel Campus Members Area.
- The payment will be confirmed within a few seconds and you will get immediate access to the course.
All the modules and videos I discussed are there, and I will be in the comments section answering your questions. Watch the welcome video to get an overview of the course and how to use the software.
Again, I want to thank you for joining me on this journey and I look forward to seeing you on the inside... Please click the button below to get started right away.
Single Student Package
Lifetime Access to the Course
1 payment of $297 USD
11 Training Modules
5 Awesome Bonuses
Practice Files & Code Samples
Immediate Lifetime Access
30-day Money Back Guarantee
Special VIP Package: Live Q&A Calls
Single Student Payment Plan
Lifetime Access to the Course
3 monthly payments of $99 USD
11 Training Modules
5 Awesome Bonuses
Practice Files & Code Samples
Immediate Lifetime Access
30-day Money Back Guarantee
Special VIP Package: Live Q&A Calls
After clicking the Enroll button above you will:
- Complete the secure order form with your credit card or PayPal. You will also create an account for the Excel Campus Members Area.
- The payment will be processed immediately, and you will get immediate access to the entire course.
Frequently Asked Questions
When does the course start and finish?
How long do I have access to the course?
How long does it take to complete the course?
Can I download the Excel files used in the course?
Can I watch the videos on my iPad or tablet?
What version of Excel do I need?
How do I ask questions and get support?
What payment methods do you accept?
Can my employer pay for my enrollment?
Can I purchase multiple memberships for my employees?
What if I am unhappy with the course?
Join This Awesome Group
Until I found your course my attempts to learn VBA have been disappointing.
...too many books and 'free courses' offer too much information and not enough hands-on experience for me to make sense of the material. I think you have just the right balance here.
Jimmy L.
Engineer
I believe Jon's teaching style, methods, simplicity and presentation makes this course the best way for me to learn macros & VBA.
Janine R. Consultant
Jon doesn't get bogged down in theoretical concepts. His approach is to get you up and running creating your own macros immediately. It is quite obvious by his presentation that he knows the subject very well. The code used for this series can be easily used for your own particular situations.
Michael D. Accountant
Get Started Learning VBA Today!
Single Student Package
Lifetime Access to the Course
1 payment of $297 USD
11 Training Modules
5 Awesome Bonuses
Practice Files & Code Samples
Immediate Lifetime Access
30-day Money Back Guarantee
Special VIP Package: Live Q&A Calls
Single Student Payment Plan
Lifetime Access to the Course
3 monthly payments of $99 USD
11 Training Modules
5 Awesome Bonuses
Practice Files & Code Samples
Immediate Lifetime Access
30-day Money Back Guarantee
Special VIP Package: Live Q&A Calls
After clicking the Enroll button above you will:
- Complete the secure order form to pay by credit card or PayPal. You will also create an account for the Excel Campus Members Area.
- The payment will be processed immediately, and you will get immediate access to the entire course.
Note: If you have any trouble creating an account and registering for the course, please try the Google Chrome or Firefox browsers. The course software uses some of the latest web technologies and does not work well with some versions of Internet Explorer. Please contact me with any questions. Thank you! [email protected]
© 2024 by Excel Campus LLC. - Disclaimer | Contact Me