Easily learn how to work with VBA's fundamental constructs and structures to automate Excel

The VBA Fundamentals video courses (Part I and II) are my founding courses on Excel VBA.


VBA Fundamentals helps you gain the knowledge you need to work with the most important and fundamental VBA constructs.


By the end of the VBA Fundamentals (Part II) video course, you should be able to:

  • Understand how to approach and tackle most common practical problems and situations you may face when working with macros and VBA; and
  • Automate most Excel tasks by appropriately working with, and leveraging, VBA.

VBA Fundamentals (also) helps you build a solid knowledge basis (in Excel macros and VBA) you can build onto as you learn about more advanced VBA and Excel Development:

  • Concepts; and
  • Strategies.

Join hundreds of Excel users from all walks of life (including students, professionals, and retirees) who have learned about Excel macros and VBA with the Training Materials in the Power Spreadsheets Academy.

I am looking forward to bringing this project to fruition and I am amazed at the power and versatility of the VBA code and what is possible. This is only the beginning and as a flight examiner once told me, obtaining your pilot's license is your ticket to learn and the same holds true for VBA coding.

Gustavo M.

USA

Thank you. I just became very interested while hearing from you the many benefits excel macros and vba has to offer. I'm an accountant and just realized the many missed opportunities. I guess it doesn't hurt grabbing this wonderful chance of a lifetime.

Eduarte P.

Philippines

Training Bundle Information

I designed VBA Fundamentals with the VBA beginner in mind. If:

  • You're an Excel macro user with basic knowledge of Excel macros and VBA (as covered in my Excel Macros for Beginners video course);
  • You want to take your knowledge of Excel macros and VBA to the next level (by mastering VBA's fundamental constructs and structures); and
  • You're looking for help with each step along the way;

The VBA Fundamentals Training Bundle is for you.

I have some experience with VBA but do not believe I am using it efficiently. I spend too much time on the net trying to learn how to do certain tasks. I prefer a more organized learning method such as your program.

Jerry B.

USA

Hi J,


I just wanted to let you know that I think I am starting to understand VBA as I have been successfully writing complex code and it has been working and that has made me rather excited!

David P.

Australia

Training Materials included in VBA Fundamentals

(1) VBA Fundamentals Part I video course and VBA Fundamentals (Part II) video course (USD 300 value), including downloadable HD course videos.

  • The main Excel VBA constructs and structures explained in plain English.
  • Tons of tips and tricks.

(2) Example Excel workbooks (USD 100 value) with the:

  • Data; and
  • VBA code;

I display in the VBA Fundamentals video courses.


(3) Course transcripts and slide decks in PDF format (USD 100 value).

Just wanted to share the great news of completing my first work related VBA coding for a major customer concern by eliminating the manual data entry of technical data. All in all, the code covered more than 40 pages but it works like a charm. In terms of improving the overall efficiency. it reduced the total time to accomplish this task from 45 minutes down to less than 20 seconds. I cannot thank you enough for your tutorials and on-going VBA course which has been invaluable. Keep up the excellent work and thanks again for your support.

Gustavo M.

USA

VBA Fundamentals (Part I) and VBA Fundamentals (Part II) Video Course Curriculums

VBA Fundamentals (Part I) has 247 videos (8+ hours), divided into the following modules:

  • Welcome! Please Start Here: 5 videos (27:42).
  • Procedures and Sub procedures: 11 videos (20:23).
  • The structure of a VBA statement: 13 videos (23:14)
  • Objects: 34 videos (1:30:01).
  • Properties and methods: 46 videos (1:17:15).
  • The With… End With Statement: 14 videos (23:42).
  • Formulas and Cell References: 14 videos (24:48).
  • Expressions and operators: 14 videos (23:50).
  • Variables and data types: 30 videos (1:22:29).
  • Variable scope and lifetime: 19 videos (30:01).
  • Object variables: 9 videos (18:21).
  • Constants: 13 videos (19:55).
  • Arrays: 24 videos (34:47).
  • Course Wrap-Up: 1 video (12:18).

VBA Fundamentals (Part II) has 201 videos (8+ hours), divided into the following modules:

  • Welcome! Please Start Here: 1 video (12:10).
  • Call Procedures and Pass Data Between Procedures: 18 videos (41:47).
  • Work with Functions in VBA: 27 videos (53:43).
  • Create User-Defined Functions: 43 videos (1:33:53).
  • Control Code Execution: Introduction: 5 videos (10:08).
  • Control Code Execution: Conditionally Execute Statements: 20 videos (1:00:55).
  • Control Code Execution: Handle Errors: 22 videos (52:49).
  • Control Code Execution: Repeat a Set of Statements: 35 videos (2:00:33).
  • Create Automatic Procedures: 29 videos (1:16:18).
  • Course Wrap-Up: 1 video (8:05).

(...) when you asked if I would like to subscribe to your VBA fundamentals course I hesitated then decided to go for it. I'm very happy that I did and would recommend your course to anyone who asks!

John F.

USA

Bonuses

Bonus #1: A substantial price discount.


Lock immediate savings as a "thank you" for enrolling now. These savings are (already) reflected in the prices displayed on this webpage.

You were the only instructor for excel macros that I have seen that has offered so much in his introduction to excel macros course and has been very good at their explanations.

Leo R.

USA

Great resources and great value.

John B.

Australia

Bonus #2: Access to my Excel Macros for Beginners video course (USD 300 value).


Excel Macros for Beginners is my introductory-level course on Excel macros and VBA.

  • 60 downloadable HD course videos.
  • 9+ hours of video content.
  • Includes companion files:
    • Example Excel workbooks.
    • Transcripts.
    • Slide decks.

You can learn more about Excel Macros for Beginners here.

It’s actually going well – I did decide to back up and review the Macro course. Your teaching style is good.

Tracy W.

USA

I am enjoying the course very much! I am actually doing the Excel macros for Beginners (77%) to ensure I have a firm foundation before getting too deep into the VBA fundamentals.


I am learning some things that have been overlooked in other courses I have taken. Your presentation on the Object hierarchy helped greatly in understanding some online VBA examples.

Tracy W.

USA

Bonus #3: Access to all books inside the Power Spreadsheets Library (USD 99.8 value).

  • 20 comprehensive and actionable step-by-step eBooks in PDF format.
  • 72 example Excel workbooks.
  • 1 PDF cheat sheet.
  • 1 example PDF file.

Learn more about the Power Spreadsheets Library here.

Where was this guy years ago? Author does a great job of explaining precisely what the book is about. Would love to see a comprehensive book by this guy! His approach is orchestrated for learners; in language that is easy to understand for learners. Well done.

Eric N.

USA

Bonus #4: Access to the Excel Examples and Cheat Sheets Collection (USD 100 value).


Most Tutorials at Power Spreadsheets are accompanied by files. Depending on the Tutorial, these may include:

  • Example Excel workbook(s) and/or PDF file(s) with the data or VBA code I display in the Tutorial.
  • Cheat sheet(s).

The Excel Examples and Cheat Sheets Collection gives you convenient access to all these companion files in a single place.


Bonus #5: Access (inside the Power Spreadsheets Academy) to the following 2 bonus courses (USD 100 value):

  • The Get Started with Excel Macros and VBA in 3 Days video course.
    • As implied by its title, in this course, you learn how to get started with Excel macros and VBA in 3 days.
  • The VBA Basics text-only course.
    • VBA Basics is a text-only course for VBA beginners.

It is a wonderful detailed introduction in a simple and understandable way. thank you.

Mahesh V.

India

Love the courses/lessons. They have assisted me in understanding and writing VBA code.

Stephen S.

USA

Bonus #6: Expert support (USD 147+ value).


If there's anything in the VBA Fundamentals video course or other Training Materials included in the VBA Fundamentals Training Bundle that you don't understand:

  • Ask questions; and
  • Get advice.

You can do this:

  • Through the Course software; or
  • By email.

It is refreshing to find someone who shows concern about the satisfaction of their clients as do you. I thank you for that.

Don S.

USA

Hi J,

Thanks for the continued support. I really appreciated it!!

David P.

Australia

Note: There are some limitations to these support services. For example, we can't (i) complete, (ii) partially develop, (iii) fully develop, (iv) provide advice in connection with, nor (v) answer questions in connection with, any of the following (or anything similar) for you: (i) macros, (ii) VBA procedures, (iii) VBA Projects, (iv) VBA Applications, (v) homework/work/employment assignments. We also can't answer questions on topics not covered inside the Training Materials included in the VBA Fundamentals Training Bundle. We're happy to answer qualitative and technical questions that are related to the Training Materials included in the VBA Fundamentals Training Bundle.


Bonus #7: Help shape the future of the Power Spreadsheets Academy.


You can help me shape (through your advice, comments, questions, and suggestions) the future of the Power Spreadsheets Academy.


I'm constantly making improvements to the Power Spreadsheets Academy. Any improvements I make to the VBA Fundamentals Training Bundle during the term of your Membership and based on your feedback will benefit you.


Bonus #8 (if your email address is eligible): Automatic one-time subscription to The Power Spreadsheets Newsletter.


Get updates and resources to help you be more efficient and work faster with Excel. You can unsubscribe anytime.

Hi, I'm J!

J.A. Gomez - Creator of Power Spreadsheets

J.A. Gomez

Power Spreadsheets

I'm the creator of Power Spreadsheets and (among others) VBA Fundamentals. I've been working with, and teaching about, Excel, macros, and VBA for several years. 


Nowadays, I spend most of my time working on and researching about:

  • Automation;
  • Excel;
  • Macros; and
  • VBA.

However, this wasn't always the case.


Prior to mastering Excel, macros, and VBA, I (also) faced common self-limiting beliefs and doubts:

  • I thought that I would never be able to learn how to program; and
  • I believed that (only) "certain" people could master tools like macros, and VBA.

My own experience showed me these self-limiting beliefs were wrong. Despite coming from a non-technical background and having no programming experience, I mastered Excel:

  • Macros; and
  • VBA.

When I started learning about Excel macros, and VBA on my own, I took the long and difficult route. I invested thousands of hours:

  • Reading books and blogs;
  • Watching video lessons; and
  • Visiting online forums.

This trial-and-error approach was flawed. It made the experience:

  • Difficult; and
  • Less fulfilling.

And that's not even considering the time and money I lost. During my time helping thousands of people, just like you, at Power Spreadsheets, I've noticed that (unfortunately) most of them make similar mistakes to the ones I did.


This is one of the main reasons why I'm constantly developing and refining my training materials.

  • I want to save you the:
    • Time;
    • Mistakes;
    • Trial and error; and
    • Confusion.
  • I want to teach you how to use macros and VBA:
    • Easily; and
    • Effectively.

I'm convinced that, if I could overcome my limitations and self-limiting beliefs to master Excel macros and VBA, you also can. I didn't have any unique gifts, traits, or experiences to indicate that I would be able to become an authority in the field of Excel macros and VBA.


I'm (also) convinced that you can master macros and VBA without making the same mistakes I, and thousands of others, made.


My experience has allowed me to identify the approaches and processes that work best to learn how to automate Excel with macros and VBA. I know what it takes to take you:

  • From a complete beginner with absolutely no knowledge about macros and VBA;
  • To a confident Power User who's able to create powerful VBA Applications.

I first applied the learning techniques and strategies I use in the VBA Fundamentals Training Bundle to my own process of mastering Excel VBA. In other words: I've created the Training Bundle I would've found most useful when I started to learn about this topic.

My experience with macros is similar to yours. I have had some exposure in utilizing macros that others have built but just kind of flag it as something I never learned and therefore cannot do. Something like you say only nerdy people can do. It's time to just get on with it and learn how.

Anita P.

Canada

I am really impressed by your road to this amazing knowledge and the challenges you endured to achieve this mastery level of excel knowledge. This give me the strong heart to overcome my believes too and hope to be like you soon. Everything is possible after I learn about your experience.

Mohamed I.

USA


My work in Excel, macros, and VBA is quoted, and referred to, by Excel, macro, and VBA users (of all levels) at the largest, most reliable, and most prestigious Excel and VBA discussion forums and websites, including the following.

My work is quoted in the largest Excel and VBA discussion forums and websites

The Training Materials inside the Power Spreadsheets Academy are so detailed and thorough that members come from:

  • Top-ranked universities; and
  • Top-tier companies.

Here's a small selection of schools and companies where students and professionals have used the Power Spreadsheets Academy.

Selection of schools and companies where students and professionals have used the Power Spreadsheets Academy

Note: Students, employees, or other parties related to these organizations have enrolled in the Power Spreadsheets Academy. These organizations do not endorse, approve, sponsor, or otherwise have any affiliation with the VBA Fundamentals Training Bundle or Power Spreadsheets.

My 30-Day No-Questions-Asked Money-Back Guarantee Means You Take No Risk

30-day money-back guarantee

I'm happy to offer you the opportunity to take 30 days (from the date of your initial enrollment) to evaluate everything inside VBA Fundamentals. If you're not 100% satisfied, contact me before the end of this 30-day period and ask for your money back. I'll refund your investment, no questions asked.


There is absolutely no risk to you within these 30 days (from the date of your initial enrollment): You can ask for your money back for any reason whatsoever -or for no reason at all.


I trust (both) you and VBA Fundamentals. I stand behind the quality of the Training Materials. I'm confident that, if you put in the work, you'll learn how to work with Excel macros. In other words: I'm confident that:

  • VBA Fundamentals will deliver a lot of value; and
  • You'll find VBA Fundamentals worth a lot more than what you're paying.

Learn how to start automating Excel with macros now!

ONE (1) YEAR MEMBERSHIP TO THE VBA FUNDAMENTALS

TRAINING BUNDLE

  • One (1) year of access to all Training Materials included in the VBA Fundamentals Training Bundle
  • VBA Fundamentals (Part I) and VBA Fundamentals (Part II) video courses (USD 300 value)
  • Example Excel workbooks (USD 100 value)
  • Course transcripts and slide decks (USD 100 value)
  • Bonus: Access to the Excel Macros for Beginners video course (USD 300 value)
  • Bonus: Access to all books inside the Power Spreadsheets Library, including 72 Example Excel workbooks, 1 cheat sheet, and 1 example PDF file (USD 99.8 value)
  • Bonus: Access to the Excel Examples and Cheat Sheets Collection (USD 100 value)
  • Bonus: Access to the Get Started with Excel Macros and VBA in 3 Days video course and the VBA Basics text-only course (USD 100 value)
  • Bonus: Expert support (USD 147+ value)
  • Bonus: Help shape the future of the Power Spreadsheets Academy with your advice, comments, questions, and suggestions
  • 30-day no-questions-asked money-back guarantee

One-Time Payment

1,246.8+ 397

THREE (3) YEAR MEMBERSHIP TO THE PSA PLATINUM TRAINING BUNDLE

  • Three (3) years of access to all Training Materials inside the Power Spreadsheets Academy
  • Excel Macros for Beginners video course, including example Excel workbooks, and course transcripts and slide decks (USD 500 value)
  • VBA Fundamentals (Part I) and VBA Fundamentals (Part II) video courses, including example Excel workbooks, and course transcripts and slide decks (USD 500 value)
  • Easy Excel UserForms video course, including example Excel workbooks, course transcripts and slide decks, and cheat sheets (USD 500 value)
  • All books inside the Power Spreadsheets Library, including 72 Example Excel workbooks, 1 cheat sheet, and 1 example PDF file (USD 99.8 value)
  • Bonus: Early access to my (upcoming) Excel VBA UserForm Code Library (USD 100 value)
  • Bonus: Access to the Excel Examples and Cheat Sheets Collection (USD 100 value)
  • Bonus: Access to the Get Started with Excel Macros and VBA in 3 Days video course, the VBA Basics text-only course, and the Introduction to Excel Macros video course (USD 100 value)
  • Bonus: Expert support (USD 147+ value)
  • Bonus: Help shape the future of the Power Spreadsheets Academy with your advice, comments, questions, and suggestions
  • 30-day no-questions-asked money-back guarantee

One-Time Payment

1 payment of 2,046.8+ 497

or

Payment Plan

4 monthly payments of 511.7+ 147 each

Prices above are in USD and do not include taxes (if applicable).

FAQ

Here are answers to some frequently asked questions

How do I access the Training Materials included in the VBA Fundamentals Training Bundle after enrollment?

Can I access the VBA Fundamentals (Part I and Part II) Video Courses from anywhere?

How long do I have access to the Training Materials?

Can I download the Training Materials?

Is VBA Fundamentals for beginners? Do I need to have any particular experience/knowledge to use the Training Materials included in the VBA Fundamentals Training Bundle?

Are these Training Materials for Mac or Windows?

What Excel version do I need?

How long are the VBA Fundamentals Video Courses?

What payment methods do you accept?

How is my credit card payment processed?

What if I'm unhappy with the Training Materials?

What do I do if I need help or have more questions?

Copyright © 2015–2022 PDS Intelligence Pte. Ltd. All rights reserved

Privacy Policy | Terms and Conditions | Limit of Liability and Disclaimer of Warranty