Master VBA from scratch and automate your tasks in minutes

Save hours of work and be more productive by learning VBA from absolute zero!

Enroll now in our online training!

I WANT MY COMPLETE MATERIAL

With VBA PRODIGY you can:

Develop skills

Develop valuable skills that can be used in a variety of sectors in the job market.

Automate tasks

Learn how to automate repetitive tasks in your daily life and save time in your work routines.

Boost your career

Improve your skills and increase your chances of advancing in your career or obtaining new job opportunities.

What is VBA Prodigy?

By Gabriel Venturini

VBA Prodigy is a complete and essential ebook for Microsoft Excel users who are looking to maximize the potential of the VBA programming language. With practical and easy-to-understand content, this book will guide you from basic concepts to the most advanced applications of VBA programming.

With VBA Prodigy, you will learn how to use VBA to automate routine tasks, create custom functions, develop user interfaces, and other custom features that can significantly improve your productivity in Excel. In addition, the ebook presents valuable tips and tricks that will help you solve common VBA-related problems.

Furthermore, VBA Prodigy shows you how to integrate VBA with other Office applications such as Word, PowerPoint, and Outlook, making it even more useful for enhancing your productivity in all areas of work.

With VBA Prodigy, you will be able to improve your VBA programming skills and make your daily tasks in Excel more efficient and straightforward. Don’t waste any more time, download VBA Prodigy now and start mastering the VBA programming language!

One of the projects from our
Complete VBA Course

PRODUCT REGISTRATION SYSTEM

Creating registration systems with VBA is a common task for many Excel users who want to automate the data management of their companies or personal projects.

This is just one of the many projects we have within the VBA Prodigy training.

This is a simple but very important registration system, which you will learn to create in just a few minutes with our method.

EMPLOYEE REGISTRATION SYSTEM

The VBA employee registration system is a customized and efficient solution that helps companies and professionals manage their employee information in an easy and organized way.

This system allows users to take advantage of Excel’s advanced features to manage employee data while also adding custom features to meet the specific needs of the business.

Who is this training for?

  • Freelancers, self-employed professionals, or business owners who need to develop VBA solutions for their own company or for others and earn extra income.
  • Beginners who have already taken some courses or tried to learn on their own but have not been able to progress because they find VBA too difficult.
  • Professionals from any field who work with Excel and need to automate their routines, save time, and increase their productivity.

Prodigy Methodology

The methodology developed and refined over more than 10 years of experience in the job market has already enabled numerous students to learn VBA quickly and efficiently.

With a method that combines solid basic concepts, optimization rules, and practical exercises, I have helped students of all skill levels become proficient professionals in VBA.

If you want to improve your Excel programming skills, I have the knowledge and experience to help you achieve your goals.

  • Our VEP Method

Variables

It is important to have a solid understanding of basic Excel concepts. Learning basic programming concepts like variables, loops, and conditions will help establish a solid foundation for learning VBA.

Exercises

To truly learn VBA, you need to put into practice what you have learned. With a practical and exercise-focused approach, students are encouraged to apply what they learn in projects, solving real business problems.

Productivity

Students can expect a significant improvement in productivity, error reduction, and data processing capacity, as well as a higher level of confidence in their Excel programming skills.

  • Other courses without Methodology

Disorganized content

Classes that do not follow any logical sequence, classes seem "thrown" on the platform, with no direction or guidance.

Passive study

Platforms without exercises, or with mediocre exercises that have no relation to the job market. There is no progress.

Boring classes

Platforms with dozens of modules, hundreds of classes, and thousands of hours often with content that has no practical use.

Curriculum

Sufficient and necessary content for you to master VBA

  • START HERE
  • HOW WILL THE SUPPORT FOR QUESTIONS WORK?
  • MENTAL ALIGNMENT AND OVERVIEW
  • WHO IS THE COURSE INSTRUCTOR?
  • VISUAL BASIC FOR APPLICATIONS
  • INTRODUCTION
  • SAVE
  • IMPORT FILE
  • EXPORT FILE
  • PRINT
  • CLOSE
  • CONCLUSION
  • INTRODUCTION
  • UNDO ACTION
  • REDO ACTION
  • CUT
  • COPY/PASTE
  • CLEAR
  • SELECT ALL
  • FIND
  • FIND NEXT
  • REPLACE
  • INDENT
  • UNINDENT
  • LIST PROPERTY/METHOD
  • LIST CONSTANTS
  • QUICK INFO
  • PARAMETER INFO
  • COMPLETE WORD
  • INDICATORS
  • CONCLUSION
  • INTRODUCTION
  • CODE
  • OBJECT
  • DEFINITION
  • LAST POSITION
  • OBJECT BROWSER
  • IMMEDIATE WINDOW
  • LOCAL VARIABLES WINDOW
  • WATCH WINDOW
  • CALL STACK PROJECT EXPLORER
  • PROPERTIES WINDOW
  • TOOLBOX
  • TAB ORDER
  • TOOLBARS
  • MICROSOFT EXCEL
  • CONCLUSION
  • INTRODUCTION
  • PROCEDURE
  • USERFORM
  • MODULE
  • CLASS MODULE
  • FILE
  • CONCLUSION
  • INTRODUCTION
  • ALIGN
  • MAKE SAME SIZE
  • SIZE TO FIT
  • SIZE TO GRID
  • HORIZONTAL SPACING
  • VERTICAL SPACING
  • CENTER ON FORM
  • ORGANIZE BUTTONS
  • GROUP
  • UNGROUP
  • ORDER
  • CONCLUSION
  • INTRODUCTION
  • COMPILE VBA PROJECT
  • FULL DEBUGGING
  • PARTIAL DEBUGGING
  • CIRCULAR DEBUGGING
  • RUN TO CURSOR
  • ADD WATCH
  • EDIT WATCH
  • QUICK WATCH
  • ENABLE/DISABLE BREAKPOINTS
  • CLEAR ALL BREAKPOINTS
  • SET NEXT STATEMENT
  • SHOW NEXT STATEMENT
  • CONCLUSION
  • INTRODUCTION
  • RUN MACRO
  • STOP
  • RESET
  • DESIGN MODE
  • CONCLUSION
  • INTRODUCTION
  • REFERENCES
  • ADDITIONAL CONTROLS
  • MACROS
  • OPTIONS
  • VBAPROJECT PROPERTY
  • DIGITAL SIGNATURE
  • CONCLUSION
  • INTRODUCTION
  • ADD-IN MANAGER
  • CONCLUSION
  • INTRODUCTION
  • SPLIT
  • HORIZONTAL/VERTICAL SIDE-BY-SIDE
  • CASCADE
  • ARRANGE ICONS
  • CONCLUSION
  • INTRODUCTION
  • VBA HELP
  • MSDN ON THE WEB
  • ABOUT
  • CONCLUSION
  • INTRODUCTION
  • HOME PAGE
  • PROJECT – VBA PROJECT
  • PROPERTIES
  • CONCLUSION
  • INTRODUCTION
  • MACROS
  • RELATIVE AND ABSOLUTE REFERENCE
  • OBJECTS
  • METHODS
  • PROPERTIES
  • CONCLUSION
  • INTRODUCTION
  • TYPES OF VBA DATA VARIABLES
  • DECLARING A VARIABLE
  • OPTION EXPLICIT
  • COMMENT
  • BOOLEAN
  • STRINGS
  • DATES
  • OBJECTS
  • DIM
  • PRIVATE
  • GLOBAL
  • PUBLIC
  • STATIC
  • ARRAYS
  • CONCLUSION
  • INTRODUCTION
  • CELL REFERENCE
  • VALUE
  • TEXT
  • CURRENT REGION
  • ROWS/COUNT
  • COLUMNS/COUNT
  • OFFSET
  • USERFORM
  • FIND
  • CELLS
  • CONCLUSION
  • INTRODUCTION
  • FOR NEXT
  • LOOP DO WHILE
  • LOOP DO UNTIL
  • FOR EACH
  • CONCLUSION
  • INTRODUCTION
  • IF/THEN/ELSE
  • ELSEIF
  • OR
  • AND
  • SELECT CASE
  • GO TO
  • CONCLUSION
  • INTRODUCTION
  • USERFORM
  • COMMAND BUTTON
  • TEXTBOX
  • COMBOBOX
  • CHECKBOX
  • OPTION BUTTON
  • FRAME
  • TOGGLE BUTTON
  • MULTIPAGE
  • TABSTRIP
  • BUTTONS
  • CONCLUSION
  • INTRODUCTION
  • ON ERROR GOTO
  • ON ERROR RESUME NEXT
  • CONCLUSION
  • INTRODUCTION
  • WORKBOOK_OPEN
  • WORKBOOK_BEFORECLOSE
  • WORKBOOK_WINDOWACTIVE
  • WORKBOOK_WINDOWDEACTIVATE
  • SHEET
  • CHANGE
  • SELECTIONCHANGE
  • CONCLUSION
  • INTRODUCTION
  • INPUTBOX
  • MSGBOX
  • GET OPEN FILENAME
  • DIRECTORY
  • CONCLUSION
  • INTRODUCTION
  • SHEET NAME
  • FILE NAME
  • FULL FILE NAME
  • SUM, SUBTRACTION, MULTIPLICATION, AND DIVISION FUNCTION
  • TEMPERATURE
  • SQUARE METERS
  • BMI
  • SQUARE ROOT
  • PERCENTAGE VARIATION
  • CONCATENATION
  • EVEN AND ODD NUMBERS
  • FACTORIAL
  • CONCLUSION
  • INTRODUCTION
  • VLOOKUP
  • COUNTIF
  • COUNTIFS
  • SUM
  • SUMIF
  • SUMIFS
  • AVERAGE
  • AVERAGEIF
  • AVERAGEIFS
  • INDEX
  • MATCH
  • INDEX + MATCH
  • CONCLUSION
  • INTRODUCTION
  • PRODUCT REGISTRATION
  • CUSTOMER REGISTRATION
  • EMPLOYEE REGISTRATION
  • LOGIN SCREEN
  • PROGRESS BAR
  • CONCLUSION
  • INTRODUCTION
  • MICROSOFT WORD (GENERATE AUTOMATIC FILE)
  • MICROSOFT WORD (GENERATE AUTOMATIC INVITATION)
  • MICROSOFT POWERPOINT (GENERATE CERTIFICATE)
  • MICROSOFT POWERPOINT (AUTOMATIC SLIDE FILLING)
  • MICROSOFT OUTLOOK (SEND AUTOMATIC EMAIL)
  • MICROSOFT OUTLOOK (AUTOMATIC EMAIL EXTRACTION)
  • CONCLUSION

In addition to all the Course Content, You also Receive 3 Exclusive Bonuses

Bonus 01: Super Pack of Spreadsheets

No more creating everything from scratch! There are thousands of editable Excel spreadsheets, ready to be used according to your needs. Just choose the best one for your case! Even if you don't have much experience with Excel, with these ready-made templates, you will be able to edit advanced and complex spreadsheets.

Bonus 02: Dominating the Job Market

Digital book that will show you step by step the main strategies
of the job market. This e-book contains content on the main topics
of the current market: how to conquer the desired position, job interview tips, corporate behavior, career leverage, achieving the desired position, and tips to approve your resume in any company!

Bonus 03: Office Document Collection (Word, PowerPoint, and Power BI)

Pack of Microsoft Office Documents (Word, PowerPoint, and Power BI), you will have access to important and personalized 100% editable documents for you to use in your professional or personal life. It's the perfect solution for anyone who wants to simplify the management of their Office documents and increase efficiency in teamwork.

I WANT MY COMPLETE MATERIAL

Certificate of Completion

Upon finishing the VBA Course, the platform will automatically issue your certificate.

See this testimonial:

"I always wanted to learn how to program in VBA, but never knew where to start. With this course, I finally had the opportunity to learn everything I needed to automate tasks and increase my productivity at work."
Andrey da Rosa
Entrepreneur

Our Students

Joseph D. Oppenheim

⭐⭐⭐⭐⭐

"The VBA Prodigy training gave me a deep understanding of the basic concepts of Excel and programming, allowing me to automate repetitive tasks and save valuable time in my daily work. I recommend this course to anyone who wants to increase their efficiency and productivity."

Stephen T. Weissman

⭐⭐⭐⭐⭐

"The VBA Prodigy course was a game changer for me. Before enrolling, I was struggling to perform simple tasks in Excel, but now I'm able to automate many of my processes and save hours of work every day. The teacher is incredibly knowledgeable and always available to help his students."

Cathy C. Robbins

⭐⭐⭐⭐⭐

"Simply fantastic! ehehhe I just have to thank Gabriel and the team for the excellent service as always and the extremely valuable content. I've been a Gabriel's client for years and have taken all his courses, and VBA did not disappoint me. I have already applied programming in VBA in everything.

Chester S. Toms

⭐⭐⭐⭐⭐

"It was the best decision I made in my professional career. The teacher is an expert in Excel and VBA, and his tips and tricks for VBA programming were invaluable to me. Now, I'm able to automate many of my tasks and free up more time to focus on other areas of my work."

IMMEDIATE ACCESS TO EVERYTHING

VBA Prodigy is fully updated with the best of Visual Basic for Applications (VBA).

Get access to all of this today and start seeing results immediately. With your purchase today, you get all of this included.

In addition to what has already been mentioned above, see what you will take.

EXCLUSIVE COMMUNITY FOR STUDENTS

Private group with me and my team on WhatsApp to positively encourage you every day (optional).

PRACTICAL AND PERSONALIZED STUDY PLAN

We've prepared a study plan for you to help you learn at your own pace and stay on track.

EDITABLE EXCEL SPREADSHEET PACKAGE

Download and edit pre-made spreadsheets for administrative, accounting, financial, and more.

DAILY INDIVIDUAL PROFESSIONAL SUPPORT

Have questions about the course material? Send us your questions and we'll respond within a day (optional).

CREATION OF REGISTRATION SYSTEMS

We'll guide you through the creation of registration systems to apply your newly learned VBA skills.

EXCLUSIVE BONUSES

Access to all the exclusive bonuses we've prepared for you. TODAY ONLY!

THAT'S RIGHT, YOU READ IT CORRECTLY!

I truly believe in the transformative power of VBA. That’s why I offer a guarantee.

If for any reason within 7 days you are not satisfied with our e-book, just send us a single email through our support and we will immediately refund your money!

VBA PRODIGY

$ 29
00
or 3x of $10.41
  • Fully updated material
  • Support group and assistance
  • Exclusive bonuses
  • Completion certificate
  • Daily individual support
COMPLETE COLLECTION FOR ONLY $29
Limited time promotion.
74% OFF

Your Teacher

Hello, my name is Gabriel Venturini and I will be your teacher on this journey, with extensive experience in teaching programming and data analysis. I have over 10 years of experience in Microsoft Office products (Word, Excel, PowerPoint, Power BI, and VBA).

I am an expert in VBA (Visual Basic for Applications) and advanced Excel, having helped automate processes and optimize routines in various companies in different sectors. I have an engaging and accessible teaching style, conveying complex programming concepts in a clear and concise manner.

With a passion for teaching and extensive experience in technology, I am an inspiring and dedicated teacher who can help students achieve their professional goals and become VBA experts.

Frequently Asked Questions (FAQ)

The E-book is in PDF format. If payment is made by bank slip, it may take up to 48 hours for the payment to be processed, after which you will receive an automatic email with the login and access information to the E-book. If payment is made by credit card, you will receive the access information in your email within minutes!

YES, if you wish, you can print it and turn it into a booklet. It is quite cheap to do so at a stationery store, and it looks beautiful and is easy to handle for studying and practicing what you have learned in the lessons.

Support is provided via email for more specific questions. We also have support available via WhatsApp. Email support is valid for 1 year from the date of purchase.

If you apply the method as I teach it, step by step, and make it happen, it is practically impossible not to get results. The method has already been tested and validated by more than 2,300 students. I am fully convinced that it will work for you. It is very simple, just do what I will show you (even with little time to practice), and you will have results! If you apply it, there is no way to fail! You will learn!

Once you have watched 100% of the lessons, your certificate will be automatically released and will be available in the certificates tab.

If you still have any questions, please contact us at our email [email protected].

I WANT MY COMPLETE MATERIAL

Copyright 2024 – Prodigy VBA

All Rights Reserved

Privacy Policy / Terms of Use

“This product is sold with the support of Hotmart. The platform does not exercise prior editorial control over the products sold, nor does it evaluate the technicality and experience of those who produce them. The existence of a product and its acquisition through the platform cannot be considered a guarantee of content quality and results, in any case. By purchasing it, the buyer declares to be aware of this information. The terms and policies of Hotmart can be accessed here, even before the purchase is completed.”