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.
I wondered how their complex formulas got RESULTS. In the beginning, I was ashamed for understanding almost nothing about his megaformulas. Anyway…although I never met him in person neither knew anything else about him, he gained my respect forever because he revealed to me what was truly possible with Excel.
I started cloning and tweaking his complex formulas to adapt them to my needs (and because it was embarrassing to use something I didn’t understand). But no matter how hard I tried, I couldn’t figure out why the damn complex formula wasn’t working….
…I was unable to change it without breaking it.
Definitely, that powerful spreadsheet application 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.
Now, I enjoy the creative process of writing and debugging complex Excel formulas.
After years of hard work and dedication, I figure it all out!
Writing complex formulas to solve real business problems is cumbersome
if you ignore some principles (and if you don’t follow a proven blueprint).
If you know that Excel has hundreds of functions but —when it comes to calculating— you are faced with questions like which function(s) should I use? How should I combine (or nest) them? Is there a way to write better formulas? How to make a formula fast, scalable, easy to understand and auditable?…
…or If you have some worksheets with very long formulas (nested IF-THEN-ELSE/AND/OR/VLOOKUP/INDIRECT, etc.) and most are a bear to get working.
And want to become comfortable and at ease with these complex formulas, then this is great news for you!
Because I created my new Excel Formulas program, Master of Megaformulas – A 3-stage blueprint to write, edit and troubleshoot complex Excel formulas.
In this practical Excel Formulas program, you will discover:
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:
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.
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
After you enroll, you get instant access to:
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…
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…
These strategies will help you ensure that your megaformula is the best it can be, presented the best way it can be.
One of the most fascinating things about this program is that develops the mindset to write complex formulas in Excel!
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.
Today, you can start learning how to write, edit and fix complex Excel formulas for any project for just one payment of:
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.
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.
Enroll now and learn once for all how to write, edit and fix megaformulas.
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.
The access to the course starts now and ends after one year! But it 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.
You have one year access to the course, support, and forum. If you want to renew your membership, you can do so at 75% off. You will receive an email prior expiration to let you know.
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.
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).