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
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
|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)|
Module 2 Syllabus | Videos: 10 | Total Duration: 49 min
|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:
- 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
|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.
Modules 4 & 5: VBA Coding 101 & 201
Module 4 Syllabus | Videos: 11 | Total Duration: 34 min
|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)|
Module 5 Syllabus | Videos: 14 | Total Duration: 68 min
|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.
Module 6: Designing Awesome Applications
Module 6 Syllabus | Videos: 2 | Total Duration: 17 min
|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!!!"
Modules 7 & 8: Building Userforms
Module 7 Syllabus | Videos: 15 | Total Duration: 62 min
|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)|
Module 8 Syllabus | Videos: 10 | Total Duration: 38 min
|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!
Module 9: Customize the Excel Ribbon
Module 9 Syllabus | Videos: 8 | Total Duration: 38 min
|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.
Module 10: Creating Excel Add-ins
Module 10 Syllabus | Videos: 12 | Total Duration: 51 min
|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.
Bonus Module: Spreadsheet Based Apps
Module 11 Syllabus | Videos: 13 | Total Duration: 63 min
|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.
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!
Bonus #5: The VIP Package - Live Q&A Calls
As a special bonus for this webinar you will get access to my VIP Package. This includes 3 live Q&A group meetings with me.
You can submit questions ahead of the meetings, and it is a great way to get your questions answered.
I love to help answer questions, especially if you are feeling stuck somewhere, but I can't offer this level of support all the time. So this is a limited time bonus just for this webinar.
Bonus #6: Automate Pivot Tables with VBA
I've also added a new bonus module to the course on automating pivot tables.
The module contains 14 video lessons on writing code for the following topics:
- How pivot tables and the pivot cache work
- How to create pivot tables and pivot caches
- Building pivot tables and the 4 different areas
- Modifying layouts, options, styles, and number formatting
- Automating the pivot table refresh process
- Filters and Slicers
Pivot tables are an amazing tool for summarizing data and creating dashboards. In this bonus module you will learn how to supercharge your pivot tables by automating routine processes with VBA.
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
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 information. 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?
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 long do I have access to the course?
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.
How long does it take to complete the course?
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.
Can I download the Excel files used in 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.
Can I watch the videos on my iPad or tablet?
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.
What version of Excel do I need?
You can use any version of Excel for Windows. I use Excel 2013/2016 for Windows in most of the videos in the course. All techniques explained in the course can be used on Excel for Windows, from 2003 and beyond.
If you are using a Mac it is best to be on the latest version of Excel 2016 which is downloaded through an Office 365 subscription. This latest version has a new VB Editor that looks more like the Windows version. It is still limited on userforms though.
How do I ask questions and get support?
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.
What payment methods do you accept?
We also accept PayPal payments. You will be able to choose your payment type on the checkout page.
We can also accept check, money order, or wire transfer. Please contact us at email@example.com if you would like to pay with one of these methods.
Can my employer pay for my enrollment?
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! 🙂
We can also accept check, money order, or wire transfer and issue a quote/invoice if needed. Please contact us at firstname.lastname@example.org if you would like to pay with one of these methods.
Does the course qualify for CPE credit?
Yes! I have partnered with my friend Jeff Lenning from Excel University to get the course CPE certified. You will earn 16 CPE credits upon completing the course. The CPE version of the course is hosted on a different platform. You will need to take the course on that platform in order to get CPE credit. Here is the link to enroll in the CPE Version of The VBA Pro Course.
Can I purchase multiple memberships for my employees?
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 us (email@example.com) if you would like to register more than 3 members.
What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact us within 30 days of purchase to get a full refund. We want you to be fully satisfied and learn a lot!
Can I Get CPE Credit?
Yes! I do have a version of The VBA Pro Course that is eligible for CPE credit. I have partnered with my good friend Jeff Lenning from Excel University to get the course CPE certified.
Click here to read more about the CPE Version of the course
The CPE version of the course is hosted on a different platform due to the additional requirements for testing and tracking completion. You can enroll in the CPE version of the course by clicking the button at the bottom of this section.
What is CPE Credit and who is it for?
Certified Public Accountants (CPA's) and other professionals are required to take continuing education each year to maintain their license. The training is measured in Continuing Professional Education (CPE) credit hours.So, if you are required to obtain continuing education credit for your license or certification, please check out the CPE version of this course.
Therefore, the CPE version of the course is only for CPA's and professionals that need CPE credit. If you do not need CPE credit, then you do NOT need to take the CPE version of the course.
How Many CPE Credits will I earn?
You will earn 16 CPE credits by completing the course. The course is hosted on the Excel University online training platform. Excel University (Sponsor #124370) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Here is a page that contains more details on the CPE Information from Excel University.
What is the price of the CPE Version?
The CPE version of the VBA Pro Course is $347. It costs more than the regular version due to the additional costs for certification, online training platform requirements, and administration.
Do I still get all of the Bonuses?
Yes, you still get all the bonuses when you enroll in the CPE version of the course. This includes invites to the VIP Q&A meetings as well.
How do I enroll in the CPE Version?
Please click the button below to enroll in the CPE version of the course. That link will take you to the Excel University site where you will complete the checkout process. You will get access to the CPE version of the course on the Excel University course platform.
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.
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.