Free Excel Macro and VBA Video Course

Free Excel Macros and VBA Course

Join hundreds of thousands of Excel Power Users who have learned about Excel Macros and VBA with our Training Materials

No programming experience?
This Course is designed with the macro beginner in mind.

Short on time?
This Course's 3 lessons take (only) slightly more than 1 hour.

Need to practice?
Lessons 2 are 3 are accompanied by several example Excel workbooks.

My problem is, I learn by doing, not so much from reading about commands. So, I pretty much learn how to do something but sometimes lack the basics. I find this course helpful in taking me back to the basics. Thanks much for a well produce and informative course.

Tom K.

USA

I found this tutorial to be helpful. It provided me with an understanding of Objects and Properties in VBA. I previously took an excel MS Excel VBA fundamentals course (...)  and did not get this basic understanding (...).

Thank you for making this clear.

T.S. H.

USA

In 3 video lessons, you learn (among others):

  • What macros and VBA are.
  • Some of the main reasons for learning how to work with macros and VBA.
  • How to set up Excel to start working with macros and VBA.
  • How to easily start working with macros and VBA, even if you have no previous experience with:
    • Macros;
    • VBA; or
    • Programming.
  • The step-by-step process you follow to create macros without programming.
  • How to start working with the programming environment you use when dealing with VBA.
  • The basic structure of the VBA code behind a recorded macro.
  • The basic components of the VBA language used by most recorded macros.

I use Macros/VBA with Excel, Word and especially Access. I think I have some pretty good experience with these tools. My background is as a coder going back to 2nd generation computers. With this background, on this video, I learned something (...). Thanks for teaching an old dog new tricks.

Tom K.

USA

J.A. Gomez

Course Instructor and Creator of Power Spreadsheets

Hi, I'm J.

I've been working with, and teaching about, Excel, macros, and VBA for several years.

Prior to mastering macros and VBA several years ago, I (also) faced common self-limiting beliefs and doubts. I thought that:

  • I would never be able to learn how to program; and
  • Only "certain" people could master macros and VBA.


My own experience showed me this was wrong. Despite coming from a non-technical background and having no programming experience, I mastered Excel macros and VBA.

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 decided to learn about these topics. I invested a lot of time and money towards achieving this goal. This experience of learning about Excel macros and VBA has allowed me to organize and structure the information anybody, like you, needs to learn about these topics.

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

FAQ

Here are answers to some frequently asked questions

Is this Course free?

How do I access the Course lessons?

Is this Course for beginners? Do I need to have any particular experience/knowledge to take this Course?

Is this Course for Mac or Windows?

What Excel version do I need?

How long is this Course?