Excel Campus Logo Tagline White Transparent 400x56

The VBA Pro Course

The Step-by-Step System for Learning Macros & VBA
to Automate Excel & Build Awesome Applications

The VBA Pro Course is currently closed for enrollment

But not to worry, it will be open again soon.  Please click the button below to get notified.

Learning Macros & VBA will take your Excel skills and career to the next level.
Watch the overview video below to learn more.

Learn How to Automate Excel VBA Pro Course Jon

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.

Andy How Will I Find Time For All The Excel Tasks

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.

Web Search for Excel VBA

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.

Benefits of Learning VBA

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?

Beginner to Expert VBA Pro Course

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.

The VBA Pro Course Cover - Learn by Building Apps

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

Gary W.
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.

George R. Systems Analyst

What is an Online Video Course?

vba-pro-course-logo-on-devices

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.

Step By Step Learning Excel

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!​
Intro To Macros and VBA Module 1 Code Examples

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.

Handle Formula Errors Like a Super Hero
Peter C. Quality Control Manager

"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

Build Interactive Userforms

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.

Google-like Search Box VBA Userform

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

Customize the Excel Ribbon

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

Learn How to Create Add-ins

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

File Manager Automate Processes on Excel Files

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.​

Download Excel Course Files - Ultimate Lookup Formulas

Bonus #2: The Best Course Software


Course Software Keeps You On Track VBA Pro NK

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


Comments Section Every 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


Certificate of Completion Excel Campus

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

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). 🙂

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

The VBA Pro Course is currently closed for enrollment

But not to worry, it will be open again soon.  Please click the button below to get notified.