"yes, this 3-stage complex formula building blueprint helped me keeping out of trouble and it will work for you too"

What Every intermediate and advanced excel user Should Know... About How To systematize their current function and formulas knowledge to hit the target, find and avoid errors in the syntax, understand others' formulas, and more...

Dear intermediate and advanced Excel user,

Interestingly, the first megaformula that got the results I wanted came from Rio de Janeiro, Brazil, in 2002. The spreadsheet from this arrogant Brazilian university professor impressed me so much because…

…his megaformulas transformed the boring matrix of cells into a
dynamic and powerful hydraulic simulator.

It was magic! He gained my respect forever because he revealed to me what was truly possible with Excel. And I wondered how his complex formulas got RESULTS. 

I cloned one of his megaformulas! But when I tried to adapt it to my particular situation, I got into serious trouble…

…it was like a kid that broke the pedestal that held an expensive decorative vessel. 

No matter how hard I tried, I couldn’t figure out why the damn complex formula wasn’t working….

Those powerful formulas was written in a language that only the professor and of course Excel understood. I became obsessed with the functions he used and started to study them one by one:  INDEX, MATCH, OFFSET, IF, OR, INDIRECT, ADDRESS, etc. I deconstructed his Megaformulas. I put them on separate columns, I studied their arguments and logic one by one…

…but no matter what, I got lost in the middle of the formula. When I tried to hit the target with my copycat formula, I always got it wrong.

I am not exaggerating when I tell you that I struggle for almost a year to understand these complex Excel formulas. But learning Excel functions and formulas was not enough.

I realized it was easier with a proven system 🙂

I should figure it out on my own because the professor never revealed his megaformula building system to me.

Now, I enjoy the creative process of writing and debugging complex Excel formulas because I developed a system that makes megaformulas writing and debugging a lot easier.

Imagine…you can bring the Excel function nesting power to its knees and get the RESULTS you want!

You can simplify the writing and debugging of complex Excel formulas because I packaged my proven system on my new Excel Formulas program, Master of Megaformulas – A 3-stage blueprint to write, edit and troubleshoot complex Excel formulas.

What the Master Of Megaformulas Blueprint will do for you?

In this practical Excel Formulas program, you will discover:

  • How to systematize your current (and coming) knowledge of Excel functions and formulas so you streamline and enjoy writing and debugging complex formulas from you or others
  • How to guide your thinking along the megaformula building process to avoid deadlocks and unnecessary errors, and false expectations
  • How to build any complex formula in 3 simple stages. Discover what’s the first thing you should do to hit the target, how to find the right mix of functions and logic for your needs, how to reduce the amount of trial-and-error necessary to get the results you want
  • How to understand others’ megaformulas with ease
  • How to debug any complex formula in 3 simple stages. Discover what’s the first thing you should do to find an error in the syntax
  • What functions you must avoid on your megaformula
  • The computer programmer’s 5-step megaformula building blueprint that will turbocharge your megaformula skills. You can use this roadmap as an alternative/complement of the 3-stage blueprint, two write or debug complex formulas
  • The timing and mindset for researching new functions
  • The simple criteria you must follow to choose the best functions for your megaformula. Stop using the wrong functions that will take you down the rabbit hole of errors and uncertainty
  • and much more

The program will also give you enough context so you face the megaformula territory with confidence and effectiveness. Also, In this comprehensive Excel Formulas program, you will learn:

  • The silent Excel behavior outsiders never notice, which every MF writer should know so they stop pulling their hair during errors and to reduce anxiety during the writing of long and complex formulas. If you want to go beyond level 3 of nesting with absolute confidence, then this is for you
  • A simple two-step technique to find any untraceable error on any megaformula. Well, only those who are aware of the silent Excel behavior I mentioned above can perform this technique successfully
  • 3 proven step-by-step nesting function techniques
  • How to be aware of unknown and advanced functions. Learn how to organize the 477 Excel functions into powerful groups and stop asking, which functions should I use?
  • Which functions can be nested together and which ones can’t be nested together. Yes, discover which are the good and bad associations you must avoid
  • How to manage parentheses and commas
  • How to figure out which formula would work best for your particular situation
  • How to check the results of intermediate steps. Learn how to use this technique in the middle of the writing or during the editing process
  • How to check the results of intermediate steps without creating intermediate columns that look unprofessional
  • Quickly figure out why your nested IF formula does not work
  • How to navigate a megaformula without messing it up. Learn how to easily position your cursor at the right spot to highlight the function, the arguments and how to select them without using the mouse so you never leave parenthesis out
  • How to quickly copy any nested function without dealing with the error-prone manual parentheses selection. Get rid of the insecurity of incomplete parentheses during your copying and pasting operations
  • How to simplify the writing and editing of complex and long formulas
  • A simple keyboard shortcut to make long formulas easier to read
  • Two commands to make a long formula shorter
  • How to manage more than 3 IF conditions
  • The two logical functions you can use to simplify IF megaformulas
  • How to edit an existing megaformula without breaking it
  • How to make additions to an existing megaformula without breaking it
  • How to get a failed megaformula working
  • The simple thing to do when a megaformula goes wrong
  • What are the 6 common errors and how to solve them
  • How to use the intellisense and tooltip tools to solve undefined/untraceable errors
  • How to preserve a megaformula on copying and moving
  • And much more!

What are others saying about The Master Of Megaformulas Blueprint?

Hi, John, I'm done with it already. It was easy to read and comprehend. I feel like I already knew most of the info, but it was nice to have it laid out step by step like you did it.
This is one step closer to my dream Excel learning idea: a set of Lego-like puzzle pieces that can be discretely moved around to fit the various possible configurations such as, the Range object and the Range property for example. Doesn't that sound like fun?
Thanks for all you do. Best Regards,
Tom Watkin
Good evening John, I have downloaded the information and look forward to increasing my knowledge of Excel. Thank you very much for presenting these formulas classes. I only wish I had found them much earlier.
Thomas Dame
Hi John,
I got through the document and learned some new ways to think about formulas. Also looking forward to your upcoming chapters!...
Thanks again!
John B. Schuyler
Thank you for making the Megaformulas course. This has definitely improved my understanding of how formulas work. The best part of the course is the analogies used to explain the concept for clear understanding. I haven't seen anyone using analogies to simplify Excel formula understanding.
The MMF is not only for Excel learners but also for masters to help improve understanding methodically.
...Thank you for yet another gem from excelgurublueprints.com. In short a must-have course for any Excel user. Please have a great day. Regards
Rajesh Dugar
Chennai, India
Hi John I speak french so sorry for my mistakes 🙂

However I want to thank you for the megaformula course, it is one of the best investments I have made. I am no longer apprehensive when approaching complicated formulas. My understanding changed my vision of Excel. This is why I did not hesitate on Macros For Busy Professionals. Have a good day
Michel Tremblay

How much should you invest in this megaformula building blueprint?

Being able to synthesize Excel into a few simple principles and techniques is only possible due to my 10+ years of hard-earned experience creating and using real-world Excel applications, in a corporate environment.

If you can increase your confidence to put Excel megaformulas skills in your resume and get a promotion, get a high-paying job, how much would your current salary increase? 10%, 15% or more? That would add thousands of dollars each year to your pocket.

If you become a freelancer, you will able to earn $50, $100+ per gig. And if you are a consultant, you will be able to face new and bigger projects.

The MMF program won’t cost you $500.

The MMF program won’t cost you $300.

The MMF program won’t even cost you $200.

If you want to boost your confidence, productivity and authority with megaformulas, you can start today for just one payment of:

USD 147

USD 67

With a small investment, the Excel megaformulas skill will pay you back again and again.

If you don’t learn how to write, edit and fix complex long formulas, you will never be a full-fledged Excel user.

You risk nothing

If within 30 days of purchase, you follow and implement the megaformulas guide lessons and you don’t learn how to write, edit and fix megaformulas from you and others, or you don’t feel more confident to use the program, or if you simply didn’t like the material, just ask for a refund and you will get your money back, no questions asked. I have been selling Excel infoproducts online since 2011 to thousands of professionals from around the world. Just contact us (use the subject, ‘Refund’). I will take care of it.

What's different from other Excel formulas courses out there?

Most of the Excel formulas courses are all about memorizing functions and formulas. The MMF program will show you a proven 3-stage blueprint to build any complex formula. Also, the MMF program will show you how to think like a megaformulas guru, how to learn functions in a way that you can match them with your situations, and how to be absolutely confident with complex formulas from you and others.

You get access to the tools (megaformulas building blueprint) and the Excel fundamentals that will give you context and confidence to face challenging MF situations.  

Other courses about formulas assume you know a lot of things. I don’t take anything for granted that you should know. I explain it the way it is done to a kid.

Who is the MMF blueprint for?

The MMF Blueprint is for intermediate or advanced Excel users who already have created basic/complex formulas and are looking for new ways to tweak their existing complex formulas for higher functionality, want to get more context to face complex formulas with confidence, or want to systematize their formulas knowledge and skills.

The MMF program is for professionals and consultants who want to systematize their knowledge to transform Excel from a normal spreadsheet program into a dynamic and powerful analytics tool​

You are covered by my 30-day money back guarantee.

What do you get when you enroll in the MMF program?

After you enroll, you get instant access to:

15+ in-depth lessons

Concepts explained using annotated graphics, simple language and analogies everyone can understand

10+ Formulas workbooks

More than 10 practice Workbook files in xlsx format (the same ones used in the program)


Post your projects on the forums and get feedback from me and other members on your same journey. Also, hone your skills by helping others in their Excel guru journey

User and password

Email with a username and a password to access the private members' area

Megaformula building blueprint

Follow a proven blueprint that will get your complex formulas done

Email support

One year of email support

Lifetime access

Learn at your own pace at any time. No need to follow rigid schedules

Free updates

Get free access to updated and new lessons, bonuses, for one year

Access anytime, anywhere

Access the members' area on any device (Android, iOS, Windows, Mac).

What else do you get when you enroll in the MMF program?

Practical bonus #1 - The Excel Functions Finder (EFF)


I have synthesized the Microsoft Excel 2016, 2019 functions scattered help into one single database you can sort, filter, pivot, and enrich at your convenience (using the simple and familiar Excel filtering and list tools).

This handy workbook with a library of 477 Excel functions is for you if you want to…

  • Find new Excel functions to improve your skills. Discover new functions by category, by data type, by version added, by name, by any keyword you type on the respective field filter text box
  • Find out what can be done. Stop using the same functions that keep you stuck in a beginner level
  • Discover how many Excel functions are in Excel 2016
  • Discover the exact Excel version on which a function was added. You can know if your customers or peers will be able to use some fancy function you plan to use or finally find out why some functions cannot be used in your Excel version
  • Discover the exact new category where some functions were relocated to. Newbies think some functions were deprecated but they are hidden in some function category
  • Find out what types of data type each function retrieves so you know where they fit
  • Keep track of new functions added in the upcoming versions of Excel
  • …and much more!

Practical bonus #2 - How To Keep Your Megaformulas Free Of Errors


After 20 years of writing, editing and debugging really complex Excel formulas (megaformulas) for Civil Engineering, science, data cleaning, and database projects, I have synthesized the best practices to be free of the most common errors that plague these megaformulas.

This practical 20-page Excel Formulas best practice guide is for you if you want to…

  • Know the simple parenthesis strategy that will avoid you unnecessary frustration with untraceable parentheses errors
  • Know how to enter dates, texts, etc., in your complex formulas without crashing them
  • Know the 5 elements that you should focus on to avoid almost 90% of the most common errors during formula writing, editing and debugging
  • and much more…

Practical bonus #3 - 21 Megaformula Writing And Troubleshooting Strategies

These strategies will help you ensure that your megaformula is the best it can be, presented the best way it can be.

Inside this handy toolbox, you will find…
  • new actionable Excel techniques to improve your existing megaformulas
  • how to make your formulas shorter
  • testing and debugging techniques
  • how to simplify nested IFs
  • a checklist to improve a megaformula
  • …and much more!

One of the most fascinating things about this program is that develops the mindset to write complex formulas in Excel!

Enroll now and learn once for all how to write, edit and fix megaformulas.



How much time should I devote to learning?

To complete the MMF program, you should complete 20+ lessons. But you don’t need to study the entire program in one sitting. 

You can read the lessons at your own pace and you can also skip the areas you are familiar with or that you want to study later.

No pressure teacher. No rigid schedules. Study at your own pace.

Click here to get started

What payment methods do you accept?

All major credit cards including Visa, MasterCard, and American Express are accepted. We also accept PayPal, Amazon Pay, and Wire transfer.

Click here to get started

When does the course start and finish?

The access to the course starts now and ends whenever you like because is a self-paced online course. You decide when you start and when you finish.

The course site remembers your progress, so you can pick up right where you left off on any device.  That means you can study a few lessons at work, then continue right where you left off on your tablet or home computer.

You can access the course site from your work or home computer, tablet, smartphone or any other device with an internet connection.  

Click here to get started

How long do I have access to the course?

You have lifetime access to the course.

Click here to get started

What Excel version do I need?

The program covers fundamentals that are common to all Excel versions. 

Except for some version-specific functions, all the functions, formulas and techniques will work on any version of Excel for either Windows or Mac. I use Excel 2016 for Windows in my screen captures.

The bonus Excel functions finder (EFF) will show you the functions that are available on Excel 2016 and 2019 versions.

Click here to get started

Can I access the lessons on my mobile device?

Yes, you can log in with your smartphone or tablet (Android or iOS) and read or download the material. If you want to manipulate the workbooks, you might need an Excel app installed.

Of course, you can also log in with your computer or laptop (Windows or Mac).

Click here to get started