Learning Macros & VBA will take your Excel skills and career to the next level.
Watch the overview video below to learn more.
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:
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.
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:
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.
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.
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.
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.
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.
|1. How to Create a Macro Enabled Workbook (2:58)|
|2. How to Write a Macro and Step Through The Code (4:20)|
|3. 7 Different Ways to Run a Macro (6:35)|
|4. The Excel Object Model and Referencing Objects (5:05)|
|5. How to Reference Workbooks in VBA (5:14)|
|6. How to Reference Worksheets in VBA (6:27)|
|7. How to Reference Ranges in VBA (Part 1) (5:10)|
|8. How to Reference Ranges in VBA (Part 2) (5:27)|
|9. Working with Object Properties in VBA (5:00)|
|10. Working with Object Methods in VBA (4:09)|
|1. Declaring Variables and Data Types (5:24)|
|2. How to Set Variables in VBA (6:30)|
|3. How to Use Variables as Parameters for Properties & Methods (5:02)|
|4. Sub Procedure vs Function in VBA (5:09)|
|5. How to Use the Macro Recorder to Get Code (4:18)|
|6. Common Ways to Copy and Paste Cells - Part 1 (4:11)|
|7. Common Ways to Copy and Paste Cells - Part 2 (2:36)|
|8. Common Ways to Copy and Paste Cells - Part 3 (7:41)|
|9. Writing If Statements in VBA - Part 1 (3:27)|
|10. Writing If Statements in VBA - Part 2 (5:18)|
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:
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.
|1. Overview of the Developer Tab in Excel (4:40)|
|2. Overview of the VB Editor (7:12)|
|3. Keyboard Shortcuts for VB Editor Part 1 (6:39)|
|4. Keyboard Shortcuts for VB Editor Part 2 (5:56)|
|5. Option Explicit - What Is It and Why You Must Use It (6:12)|
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.
|1. Coding 101 - Intro to Coding in VBA (2:31)|
|2. Overview of the List Sheets Macro & Creating the File (3:06)|
|3. Writing a Macro Part 1 - Message Box (5:37)|
|4. Writing a Macro Part 2 - If Then Statement (2:07)|
|5. Writing a Macro Part 3 - For Loop (3:38)|
|6. Writing a Macro Part 4 Compile Code (1:32)|
|7. Coding Tip - Using Syntax (1:18)|
|8. Variable Scope (3:28)|
|9. Procedure Scope (2:55)|
|10. With Statements (3:06)|
|11. User Defined Functions in VBA (5:07)|
|1. Error Handling Part 1 (6:43)|
|2. Error Handling Part 2 (3:14)|
|3. Error Handling Part 3 (4:33)|
|4. For Next Loop for Cells and Ranges (3:45)|
|5. For Next Loop with Numbers (3:35)|
|6. For Next Loop for Collections (4:06)|
|7. Undo History (4:54)|
|8. Input Boxes (10:29)|
|9. VBA Arrays Part 1 - 1 Dimension Arrays + The Locals WIndow (3:22)|
|10. VBA Arrays Part 2 - Looping Through the Array (2:14)|
|11. VBA Arrays Part 3 - Examples of Avoiding the Excel > VBA Bottleneck (7:53)|
|12. VBA Arrays Part 4 Multidimensional Arrays (4:42)|
|13. VBA Arrays Part 5 Resize and Preserve Arrays (3:15)|
|14. Timer Function + How to Drastically Improve Performance with Arrays (5:03)|
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.
|1. Overview of Designing Applications (9:26)|
|2. Macro Enabled vs Add-in Files (7:37)|
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!!!"
|1. Intro to Userforms (1:41)|
|2. How to Insert a Userform (3:35)|
|3. Overview of the Listbox Control (10:23)|
|4. Working With Selected Items in the Listbox (6:47)|
|5. Remove Items From a Listbox (2:51)|
|6. How to Launch (Show) a Userform (4:26)|
|7. How to Make Code Reusable - Listbox Example (4:56)|
|8. Stepping Through Userform Code (2:20)|
|9. Userform Cancel Button (2:36)|
|10. How to Populate a Combobox (4:18)|
|11. Using Constants to Reduce Coding Errors (2:04)|
|12. The Combobox Change Event and Select Statements (6:49)|
|13. Aligning Userform Controls and Buttons (1:38)|
|14. Calling Procedures with Arguments - Programming the Command Buttons (4:12)|
|15. Homework - Challenges for Programming the Userform (2:40)|
|1. The Google-like Search Box (2:15)|
|2. Creating a Search Box with the KeyUp Event (8:35)|
|3. Userform ShowModal Property (2:24)|
|4. Making the Userform Flow with the Tab Index (5:22)|
|5. How to Set Focus on a Control (1:30)|
|6. Userform Keyboard Shortcuts - The Accelerator Property (2:09)|
|7. Adjusting Form Properties at Run Time (3:13)|
|8. Radio Buttons (3:06)|
|9. Checkboxes (3:54)|
|10. Organizing Navigating and Cleaning Up Your Code (5:12)|
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!
|1. Intro to Customizing the Ribbon (2:38)|
|2. Ribbon XML (3:23)|
|3. Adding Buttons to the Ribbon with the Ribbon Designer (10:33)|
|4. Additional Buttons and Controls for the Ribbon (4:00)|
|5. Custom Images for the Ribbon Buttons (3:21)|
|6. The Custom UI Editor for Ribbon Customization (2:03)|
|7. Customizing the Riboon for Excel 2007 vs 2010 and Beyond (4:14)|
|8. Customizing the Right-Click Menus (8:06)|
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.
|1. Creating an Add-in File (4:50)|
|2. Tips for Working with Add-in Files (6:31)|
|3. Saving Versions of Add-in Files (2:32)|
|4. The IsAddin Property (2:29)|
|5. Overview of How to Save User Settings (4:40)|
|6. Save User Settings to the Add-in File (5:25)|
|7. Save User Settings to an INI or Text File (4:33)|
|8. Save User Settings to the Windows Registry (6:41)|
|9. Different Ways to Install Add-in Files (3:12)|
|10. Distributing and Updating Add-in Files (2:44)|
|11. Windows APIs and 32-bit vs 64-bit Excel (3:18)|
|12. Password Protect VBA Project Files (4:18)|
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.
|Overview of the File Manager Application (4:11)|
|1. Working with Tables in VBA - List Objects (7:21)|
|2. Looping Through Tables - List Objects (6:20)|
|3. How to Create Files from a List or Table (8:20)|
|4. Improving Performance with ScreenUpdating and DisplayAlerts (3:19)|
|5. Replace or Overwrite Files on Creation (4:08)|
|6. Add a Timer and File Count Message (3:13)|
|7. Adding Data to Files (5:25)|
|8. Flag or Enable Files in the List (2:04)|
|9. Run Actions on Existing Files (4:19)|
|10. Add a Timestamp to the File List (4:10)|
|11. The Actions Table (7:11)|
|12. Add Hyperlinks to the File List (2:41)|
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.
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.
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.
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.
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!
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). 🙂
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
You can access the course site from your work computer, home computer, tablet, smart phone or any other device with an internet connection.
The course site remembers your progress, so you can pickup right where you left off on any device. That means you can watch a few videos at work, then continue right where you left off on your home computer.
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
This depends on how much time you have to spend each day on watching the videos. I recommend watching one or two videos a day, and then practicing the techniques in your job. If you complete one module per week then it will take 8 weeks to complete the course.
Yes! You will be able to download all the files I use throughout the course. This makes it easy to follow along and test the code.
Yes, the course can be accessed on any tablet or smart phone, and it looks beautiful. You can watch the course on your iPad while following along with the Excel files on your computer screen.
You can use any version of Excel for either Windows or Mac. I use Excel 2013/2016 for Windows in most of the videos in the course. All the functions, formulas, and techniques explained in the course can be used on either the Windows or Mac versions of Excel, from 2003 and beyond. The bonus module on Power Pivot and Power Query will only apply to Windows versions of Excel from 2010 and beyond.
Each video lecture page has a comments section at the bottom. You can use this section to ask questions and see what questions other students have. I will be there helping to answer your questions.
All major credit cards including Visa, MasterCard, and American Express are accepted.
Yes, you can use your company's credit card to pay for the course. A receipt will also be emailed to you that you can submit for reimbursement to your employer. Most companies are willing to invest in making their employees even more awesome! 🙂
Yes, there is a team package available at a discounted price. This package includes 3 memberships to the course for you and your team members. Each team member will have their own account and be able to track their progress in the course. Please contact me (firstname.lastname@example.org) if you would like to register more than 3 members.
If you are unsatisfied with your purchase, contact me within 30 days of purchase to get a full refund. I want you to be fully satisfied and learn a lot!
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.
I believe Jon's teaching style, methods, simplicity and presentation makes this course the best way for me to learn macros & VBA.
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.