“Have You Ever Wanted To Use Macros To Formatting And Processing Large Amounts Of Information In A Few Seconds And With High Accuracy, But Non-Sense Programming And VBA Explanations Has Always Prevented You From Getting Started?”

“Thousands Now Gain Pleasure From ‘Wrestling Excel To The Ground’ And Getting It To Do Exactly What They Want, Who Never Thought They Could”

From: John Franco
Dear Excel friend,

My name is John Franco, Excel author, and if you’re reading this then 6 things are probably true about you:

  • You understand the time-saving benefits of Macros, but just have no idea where to get started
  • You have tried to learn, but there aren’t too many guides for non-programmers like you
  • You are held back because you think that Macros and VBA programming is too “hard” to learn
  • You have a limited understanding of VBA and so can’t figure out how to adapt macros from others, or why some macros don’t work
  • You can’t work creatively because you spend most of your time repeating boring tasks and completing assignments
  • You work way too much to produce the outputs your company requires

It’s not your fault!

When I say that, I truly mean it.

Like I said above, over 90% of Excel users don’t know the first thing about Macros or VBA code! You are not alone in this.

Many others are sitting there helpless not knowing where to start, and just continuing on about their day at work, but knowing in the back of their mind that more things are possible with Excel.

If you have to do the same work again and again and trying to do it accurately so that nobody get angry, you know that the chances of mistake will be high and time consumption will be also high if you are doing it without macros.

Not everyone is prepared for this new economy. The current economy requires you produce meaningful new work not the work you have been always done. The new economy is driven by innovation and creativity.

In the current business environment, if you are involved in meaningless copy-and-paste activity or trying to be accurate while you are overworked doing boring data tasks, you are destined to forever struggle as part of the horde of undervalued an unproductive professionals, out there…

…because data is massive and comes from several sources, you are probably spending way too much time on gathering data, typing data, merging data, etc and not analyzing data, which is what companies value most.

And you can’t enjoy the work you do, if you spend time on boring tasks where you hardly exercise your creativity, synthesizing data in new ways, finding new patterns or developing new perspectives for yourself and your company.

I’m a lot like you, here is my “Macro” story…

I used to work for Odebrecht, one of the worlds largest construction company for over 8 years as a Civil Engineer and to be completely honest, I knew NOTHING about Excel. When I heard the word “Macro”, I couldn’t even begin to tell you what it was about or even what it did.

At that time I worked under a very stern boss. He was from Brazil, and he was VERY particular in the way he wanted things done. He was also considered an Excel “god”! He could do things with a spreadsheet that I never even knew were possible!

I learned by doing, and nothing more. Trial and error was my one source of teaching material, so I had to do things the hard way.

And because of HIS expertise, he required a lot out of ME. So this forced me to learn how to become a “guru” myself. Its true that when you surround yourself with people who are better than you at something, YOU become better in the process!

I began to build and create very advanced modules and formulas, and luckily he noticed my improvements, so I became his “Go-To Guy” in the office.

He would receive spreadsheets from consultants, and he would start to ask ME to fix their errors and mistakes. I was put under a lot of pressure to say the least, but I had to do it.

And if you think that these spreadsheets were easy to work with, think again!

I was getting so much work done in SUCH a small period of time that he thought I had my own little hidden army of workers with me!

The spreadsheets I would receive had complex logic, looooong formulas, had THOUSANDS of rows, and sometimes they even had 16-20 workbooks integrated into them. This was no easy task at all, but I had to pull through. After sometime, I just became the everyday go to guy for him. I would fix the errors that the consultants would include in their spreadsheets. They would have formulas so long that you needed to copy and paste them into a notepad in order to see them!

It was complete madness.

After a while, I figured out Macros, and what they could do for me in terms of saving time and automating my reports. I learned that I could just click a button and BOOM, the work was done for me.

So I started utilizing my new-found technique, and Ive got to tell you, my boss started getting a little suspicious of me….


Because I was getting so much work done in SUCH a small period of time that he thought I had my own little hidden army of workers with me! He probably thought that I hid my army of workers under my desk when he walked by or something, that was his only explanation! He was extremely impressed at my work and my value to my company skyrocketed.

The best part was that I started having time to look at data in new ways, to play with it and understand things more and bring new ideas to my department. This is at the heart of the concept economy we live in now!

I am about to reveal my non-programmers shortcut to mastering Excel VBA in just 6 weeks…

It doesn’t matter if you have never seen a macro in your career of if you have tried and failed implementing macros and you abandoned this for good…

…if you follow my proven Excel VBA and Macros advice, very soon you will be laughing at the assignments you used to cry about…because when you learn how Excel VBA works, you will be creating your own macros for everything and start saving time on everything too.

I mean everything…

You can systematize Data collection. Create your own macros for: importing data, cleaning messy datasets, moving and merging data from several sources, etc

You can Systematize Data analysis. Create your own macros for analyzing and understanding your data (write formulas, create Pivot Tables reports, create charts, etc)

You can Systematize Data presentation. Create your own macros for presenting data (edit charts on the fly, dashboard setup, export data using specific formatting, email data, report formatting, etc)

I enjoy the way the information is presented in the lessons. Very easy to understand unlike most of the material I have found on VBA programming.

Anita McLain | Student, Cleveland, Ohio

Dear John…Really you are fascinating and have an explanation method that is highly attractive. Your approach impressed me because it hits the point directly…

Emad T | Student

Hi John, The presentation and content get better with each tutorial. I am finally beginning to understand VBA. Well done, keep up the good work.

Alan Smith | Student

This is definitely a great course with lots of good examples; the analogies used are very much nearer to the normal life

Srinivaskalyan | Student, India

Dear Dr.John Great presentation for this tutorial (How to manipulate Excel objects – parentheses mine). Frankly, i have read many books about VBA and could not feel that i really got the meaning of the presented concepts. Your way of presenting these concepts were amazing. Thanks a lot for this great help

Emad T | Student

Dear John, …I want you to know how blessed I am meeting someone like you with this craft of yours…!Its really helpful and easy to understand. Nothing more to say, Ill keep this for life and share to my colleagues…

Wish you the best of everything through the years to come. Muchas Gracias.

Garry Pasan | Student

Explanation is awesome. This course is perfect for “non-programmers”. Thanks John

Vinod Gupta | Student, Hyderabad – India

Hi John, I am really enjoying your course so far. I can’t believe how much content is in just Week 2. So much to learn….

Kim Cook | Student

I have personally reviewed the program which is designed in a way to learn VBA quickly and easiest manner. The best part is the step by step approach and numerous examples and videos which is very important for a beginner. The learning from this program will definitely improve your productivity and efficiency at work.

Ayush Jain | Microsoft MVP 2010

Very simple, clear explanations of VBA lessons. You are a good Professor. I think you will be a famous person in the future. I haven’t seen like these explanations before, it’s very good

thank you

thank you

thank you

thank you

thank you

thank youuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu John Franco

Mohamed | Student

Announcing The comprehensive 6-week roadmap for mastering Excel macros (in a non-programmer way)…

How To Write Excel Macros From Scratch Online Video program

6-week roadmap to Excel VBA mastery so you add a WOW productivity factor to your work, designing, writing and running your own macros



This is the “insider” VBA course John wishes was around when he was starting out with macros earlier in his career. Learning even one or two of these VBA concepts would have short-cut his own success by… oh… five… maybe five years. Probably more.

Included in this in-depth 11+hours of macros training are VBA concepts many Excel users never get it… such as:

  • Understand Excel VBA once for all with intuitive, friendly and jargon-free explanations that just make sense. This course is written by an Excel user for Excel users not for developers). Learn programming using simple language you can understand. For example, understand algorithms using a friendly monkey, the object model using an analogy that involves trees and fishes :). Explain these complex concepts to your coworkers and boss with total confidence.
  • Connect the dots about how Excel VBA works by starting from the most basic fundamentals (programming background). Understand algorithms, the pillar programming concept, which regular Excel VBA training programs assume you already know. This new knowledge will build up you confidence to complete New and Challenging assignments
  • Fully understand Excel VBA language so you write programming expressions you computer understands. Analogies with English are used extensively, so you see VBA is not that complicated. No more trial and error to get a macro that gets the job done. Get rid of your limitations due to your limited VBA knowledge, make sense of err messages as you write and avoid errors from the ground up
  • How to create Excel Macros that work for variable size arrays and sheets. Learn how to iterate through cells, rows and columns in your sheets. Learn how to use loops that literally think and know where to start and when to stop processing information. And use this knowledge to process big spreadsheets with a mouse click!
  • How to find the best solution and the syntax for your macros. When you implement flowcharting right, you become a professional who always knows which is the best way to start your macros, how to find the VBA code and structure of simple to complex VBA macro projects (even at an enterprise level). You also increase your confidence to tackle bigger automation projects because your planning and design skills will make macros simple to write and read (decreasing debugging time and effort). This is another critical concept regular Excel VBA training programs assume you already know. When you gain this knowledge, you will design your own macros to reduce workload to almost half and will become a valuable asset for your company
  • How to code common Excel routines like: how to work with ranges, how to work with sheets and workbooks, etc. Code templates provided!
  • Know the main VBA functions you can use. List of main available functions provided! so you know instantly which functions exist
  • How to communicate with other applications using VBA: Access, Word, Outlook, PowerPoint, etc. Code templates provided! Gain Prestige creating powerful applications such as one that prepares the weekly presentation out of many Excel workbooks, or another one that creates contracts in Microsoft Word out of Excel tables
  • How to find the full syntax of VBA expressions to control any aspect of Excel objects: Charts, Pivot Tables, Sheets, Workbooks, etc. A one-line template is provided that works with every object of Excel. It’s something like fill in the blank template. Speed up the time to complete a job and do it minutes because you will be able to write simple lines of VBA code that do tens of boring tasks for you. Don’t work late anymore
  • Demystify the scary Excel Object model using a simple analogy that makes perfect sense. This knowledge is critical to know the full VBA syntax of your automation instructions. Also, download the object model organized in a friendly mind map, so you have the big picture of all Excel VBA objects you can use and how to access to them. Be Praised And Admired by your coworkers and boss who still don’t get it
  • Easy VBA examples so you see how the concepts are implemented in real situations.
  • And much more…

If you still think learning VBA is too hard to learn, I understand you are skeptical…

I am not exaggerating when I say that my VBA explanations use real language anybody can understand, because I am well-known in this industry as the Excel guy who puts it in simple terms. See the raving and unsolicited testimonials above.

This Excel VBA program is designed for non-programmers, just like you. I don’t assume you already know some programming concept and so I take you to Excel mastery from the ground up.

Structured and friendly Excel VBA Macros video training program ($297 value)…

Week 1 – “Flow” module – How Excel VBA works. The lessons of week 1 will demystify Excel VBA so you will perceive that Excel VBA is not that complicated. Here are some of the lessons:

  • How Excel VBA works
  • What the Excel VBA components are and how they work together
  • and much more…

Week 2 – “Language” module – Master the VBA syntax. The lessons of week 2 will empower you to write your first macros. You will make sense of terms. Your VBA background will be strengthened here. Here are some of the lessons:

  • How to speak the VBA language
  • What are the main Excel VB functions and statements
  • Why you need to use variables and how to work with them
  • How to manipulate Excel objects (Introduction)
  • and much more…

Week 3 – “Objects” module – Learn object oriented programming and the Excel VBA objects syntax. The lessons of week 3 will empower you to understand the Excel object hierarchy and to write the full syntax of objects. Here are some of the lessons:

  • What is an object & Excel Object Model revealed
  • How to manipulate Excel objects (In depth)
  • How to work with the Range object
  • How to integrate forms into your macros
  • How to work with another application’s objects
  • and much more…

Week 4 – “Where” module – Learn where the writing/debugging/support tools are located in the Excel VBA editor. The lessons of week 4 will empower you to use the VBA design environment with confidence and comfort. Here are some of the lessons:

  • How to use the VBA writing tools
  • How to use the VBA debugging tools
  • And much more…

Week 5 – “Flowchart” module – Learn how to design the logic of macros. The lessons of week 5 will empower you to use programming diagrams called flowcharts for any kind of problem you might have. Here are some of the lessons:

  • Introducing the most important programming concept: the algorithm
  • What is a flowchart and why to use one
  • How to diagram decision and loop structures, Function and Sub procedures
  • and much more…

Week 6 – “Write” module – Learn how to write the code of your macros. The lessons of week 6 will empower you to write macros professionally! This is where it ALL comes together! Here are some of the lessons:

  • VBA code writing productivity tips
  • How to code common Excel routines (how to iterate through cells and sheets, how to work with arrays, how to write Excel custom functions (UDFs), etc)
  • and much more…

Comes with Excel VBA practice and support files…

  • Put hands on the VBA code and learn by doing
  • Download Excel files and explore the macros as you want
  • Make copies to the original files and tweak the code to explore how the code works
  • Adapt the code to your own purposes and projects
  • Download pdf reports with concepts expanded
  • And much more…

Bonus 1 ($49 value)!

My gallery of 100 VBA snippets and 17 macros examples to collect, analyze, and present information, for ABSOLUTELY FREE!


You can get it absolutely for free when you get my “How To Write Excel Macros From Scratch” program TODAY.

This gallery of proven VBA code will help you in many ways:

  • Learn how the VBA concepts are used in real situations. Understand quickly the purpose of each line or block of VBA code because the code is fully commented and because flowcharts are provided
  • Speed up the writing of VBA code by pasting and tweaking the VBA snippets code into your own macros
  • Learn how to write common functions like SUMIF, VLOOKUP, INDEX & MATCH, etc. Or just copy and paste the code and adapt it to your own situations
  • Learn how to perform common commands like: FIND, Goal Seek, Filter, etc. Or just copy and paste the code and adapt it to your own situations
  • …and much more

Bonus 2 ($19 value)!

My advanced Macros design guide “How To Create Professional Excel Macros” – Simplified Excel VBA Programming Best Practices To Make Your Macros Easier To Read And Debug, Faster And More Professional, for ABSOLUTELY FREE!

You can get it absolutely for free when you get my “How To Write Excel Macros From Scratch” program TODAY.

This easy-to-follow guide will show you:

  • Best Practices To make your Macros easier to read and debug. Gain pleasure coding your macros and gain the respect of others who see your professional VBA code
  • Best Practices To optimize your macros for speed and best use of memory
  • Best Practices To document your macros for yourself and others who might need to use your macros. You can reuse your old macros easily to create new macros, when you understand and remember what your old macros are about. Most people discard their macros because they don’t remember what they were designed for
  • …and much more

Bonus 3 ($19 value)!

My advanced Macros design guide “How To Find The Code Of Your Macros Using Flowcharts” for ABSOLUTELY FREE!

You can get it absolutely for free when you get my “How To Write Excel Macros From Scratch” program TODAY.

This easy-to-follow guide will show you:

  • How to develop the flowcharting mindset so you implement flowcharts early in your development process and avoid code writers block. Boost your confidence to accomplish bigger and more complex VBA projects
  • How to write macros that are easier to write, read and maintain. Avoid the confusion that poorly-designed macros bring
  • How to choose the appropriate level of detail so you avoid flowcharts you cannot implement into workable solutions
  • …and much more

Bonus 4 ($29 value)!

My advanced Excel Charts VBA guide “How To Create and Modify Excel Charts Using VBA” for ABSOLUTELY FREE!


This easy-to-follow Excel VBA guide will show you:

  • How to change the look-and-feel of your Charts using VBA, chart element by chart element: Series, Plot area , Up/down bars, Axis: horizontal/vertical axis (category), horizontal/vertical axis (value), Chart area, Gridlines, Legend, Trendline, Chart title, Data table, Data labels
  • How to create Excel Charts with one click
  • A Gallery Of Charts VBA code to change every aspect of any chart
  • …and much more

This guide also comes with a macro sample Excel file so you can get some real hands on experience!

Bonus 5 ($29 value)!

My advanced Excel Charts VBA guide “How To Create, Setup And Format Pivot Tables Using VBA” for ABSOLUTELY FREE!

How To Create, Setup And Format Pivot Tables Using VBA

This easy-to-follow Excel VBA guide will show you:

  • How to create Excel Pivot Tables with one click. Comes with A Gallery Of Pivot Tables VBA code to change every aspect of any PT report
  • How to change the look-and-feel of your Pivot Tables using VBA, element by chart element: Row fields, Column Fields, Page Fields, Value fields. Impress your boss with Pivot Tables applications
  • …and much more

This guide also comes with a macro sample Excel file so you can get some real hands on experience!

Here’s how to get started!

Excel VBA and macros knowledge is scattered through books, forums, and blogs and synthesizing that information requires lots of work and motivation. You might spend months and end up with partial knowledge because gurus don’t have time to mentor you along the way and usually they don’t expose everything they know.

And such materials are complex using programming jargon or assuming you already know programming. My “How To Write Excel Macros From Scratch” program is already packaged for you, so you learn complex programming concepts using plain language you can understand and in only 6 easy stages.

If you want to get exactly the information you need in just a few minutes of time, then you can learn at your own pace because the course is progressively structured, so you don’t miss anything if you go in order.

If you think you don’t have time for learning macros because you are too busy, guess what? you will remain busy while you don’t implement macros in your work. If you don’t assign a few hours of your time this week to learn macros, you will still need extra hours to complete your assignments in the next weeks to come, and you will forever struggle with lack of time.

The “Master of Macros” program and bonuses value is more than $400.

If you order today, you can start mastering macros for just USD 299.

This includes private access to the Members area where you can download videos, practice files, bonuses and updates for 6 months, and email support for 1 month.

If you consider you can get a better job or a promotion when you gain Excel VBA skills, the price of this course is ridiculous.

With a small investment, Excel Macros will pay you back again and again. If you don’t learn macros, you will keep redoubling your time and effort for completing assignments.

If you’re serious about writing macros for the things you need in Excel, go ahead and click the “Get Started today” button below.


Delivered instantly in .mp4, .pdf, .xls format, via a private members site.

If you have any question about this product, contact us.

100% No risk guarantee

You love it or your money back

If within 60 days of purchase, you follow the book lessons, do the homework and cannot design and write your own macros for automating your work, or if you simply didn’t like the material, just ask a refund and you will get your money back, no questions asked.

Just contact us (use the subject “refund”). Will take care of it.

And also…

  • Private member area. Access videos, bonuses, additional material and updates in a private, password-protected area. Enter the area using your own credentials: user and password
  • Direct interaction with the author. Ask your questions directly to me, by email or via our contact form, and I will answer your questions personally

Enroll now and start learning how to write your own Excel macros from scratch







Is the program via online or download?

Both. You can watch videos online or download them.

Are there set lesson times or access at your own pace?

You can access at your own pace during the 6 months of your membership.

All the content is available since day 1.

To learn the basic 6 week course, how many hours/tutorials should I be viewing per week?

Each tutorial is like 30 min long. Each module/week has 5 lessons in average. So you would need something like 150 min per module/week.

Are there exercises for each topic?

Yes, with the corresponding practice file in .xls format.

If I am not getting correct results, can I send my practice to someone for comments/review? Is help only available through email or is it possible to chat or talk to someone?

You can use the support channel. I am only available by email.

Disclaimer: ClickBank is the retailer of products on this site. CLICKBANK® is a registered trademark of Click Sales, Inc., a Delaware corporation located at 917 S. Lusk Street, Suite 200, Boise Idaho, 83706, USA and used by permission. ClickBank’s role as retailer does not constitute an endorsement, approval or review of these products or any claim, statement or opinion used in promotion of these products.