You've found MegaExcel.com
Do it fast, do it right, and make it look
MegaExcel is an add-in to Microsoft Excel designed for management consultants, enabling them to build well-structured, well-formatted models much faster.
Additionally, it presents a unique structured training framework to help new consultants to quickly get very good at modeling.
I built MegaExcel in 2008 as an Associate at Booz & Company.
You can download a sanitized version of the MegaExcel Add-In Here.
- Michael Komarnitsky, July 26, 2011
I also built a MariMekko* Chart Excel Template- January 23, 2014
* AKA Cake Chart, Proportional Width Chart, Mondrian Chart....
Unsolicited Comments from Booz & Company Staff on the MegaExcel Toolbar
"Just got the impressive Booz MegaExcel Tool Kit incl. a quick intro from Andrea. This will, without question bring a step change in using Excel efficiently at Booz."
"Thanks for all your work on this - looks very impressive."
New York (Principal)
"Just received and installed the mega excel toolbar ... plus had an additional little intro by andrea! honestly: great stuff!!!! must have taken you ages to put together such a helpful reference kit!!!! thanks a lot from a happy future user! ;-)"
Vienna (Sr. Associate) - CMT
"First off - well done. I've had to help untold numbers of associates - and partners - with some of these same data cleaning and pivot table methods. I know very little aboutacros and VB; you've done an impressive job of brining it all together. Thank you and congratulations again - this will be a lasting legacy for sure! I'm still putting it through its paces, but everything looks great!"
Chicago (Sr. Associate) - Ops
"I just installed the MegaExcel add-in. Great work!"
Berlin (Sr. Associate)
"Really liked the pace and "advice style of delivery" - guidance rather than direction Thanks for putting the MegaExcel tool together and for running these workshops - overall excellent."
London (Sr. Associate) - IT
"I successfully installed everything---no problems---very smooth. Nicely done!"
Dallas (Sr. Associate) - VCS
"Congrats on the new Excel Mega Toolbar! This looks really good."
Dusseldorf, (Sr. Associate) - IT
"Thanks for the excel guide, it looks great"
Stockholm (Sr. Associate)
"Thanks and good training. Why would I have not received this in the past? "
San Francisco (Sr. Associate) - Ops
"Thanks for putting this together. Some great advances, particularly in power point."
San Francisco (Sr. Associate) - Ops
"I am very impressed with the tips, etc."
McLean (Sr. Associate) - Finance
"Warm regards, and thanks for an otherwize excellent upgrade"
Copenhagen (Sr. Associate) - HT
Sydney (Sr. Associate)
"Your Excel functionalities and MegaExcel Introduction is great!! Even after six years heavy consulting work I learned a lot new things."
Abu Dhabi (Sr. Associate) - Health
"Just installing now... fantastic!!"
Florham Park (Sr. Associate) – A&D
"Over the last weeks, I used the new version of the toolbar and it works fine. Especially the Ctrl+P = Print again is really helpful :) Otherwise it is great tool, now even better than before. "
Vienna (Associate) - IT
"Thank you so much for all of your hard work in putting together the Excel macro add-in. I'm sure it is going to save me and many of our colleagues tons of time."
Los Angeles (Associate) - ATI
"Your toolbar does a lot of cool stuff and is very useful. I've been working heavily with Excel for 9 years now and it is hard to find something new that I really like - your toolbar is one of these rare new things I like. Good job!"
Sao Paolo (Associate ) – HT
"Just installed the Booz Mega Excel and it is a very impressive piece of work so congratulations!"
"Thanks for the Excel Guide, very useful."
Dubai (Associate) - HT
"First of all congratulations to your fantastic tool! I am sure now everybody wants to learn more about it. :-) Could you let me know your thoughts about conducting the training sessions?
Dusseldorf (Associate) – VCS
"Thanks for doing the excel prep, it was sorely needed by many and tremendously appreciated."
McLean (Associate) - HT
"Compliments on the great work. I especially like the approach to standardizing business cases."
Amsterdam (Associate) - HT
"Thanks again for the presentation on Friday. That really was helpful for me - and I'd just like to follow up that I think it could help us with recruiting. I don't remember getting a good Excel pack at Sloan like you gave us - with a quick PowerPoint and reference guide to the shortcuts and types of things to learn, functions, etc. Would you mind if we were to share that with people outside the company? It can just be an informal email from a recent grad or current student. It can't hurt for you to get known as an Excel guru by a wider audience either."
New York (Associate)
"Have been using the new toolkit. Just wanted to let you know that it's great and the help files are really useful. Thanks!"
San Francisco (Associate) - HT
"Just to let you know, I have installed the new toolbar. The color palette swap was a life saver - one of my models had switched from Booz to default somehow (with very ugly results), and it would have been a nightmare fixing all the colors manually before delivering to client. Thanks for the well-timed update!
I really enjoy the toolbar, and there are a few things that have saved me a bit of time, e.g.. the control+N feature."
Chicago (Associate) - ATI
"This is great, I agree with all of the guidance in here."
Mclean (Associate) – A&D
"Great work on the presentation. This was very helpful."
Chicago (Associate) - CM
"Thanks for conducting a highly informative session. I used to think I was an advanced excel user but still learnt a lot. Your idea of having the right attitude is spot-on. In my experience, I have learnt by just using Microsoft help and that was so much more cumbersome than the guide you have created. Kudos!"
New York (Associate) - HT
"Great presentation and very valuable tips and tricks."
Mclean (Associate) – EC&U
"Good stuff - finally getting time to use your sheet as it was designed!"
Mclean (Associate) – A&D
"Great toolbar, so far I think its great, especially things such as being able to cycle through the % and numbers to get different decimal places."
"Love it!!! Thank you for putting the nice colors in!"
New York (Associate) - ECU
"Thanks for developing this tool. Quite some useful stuff in there."
Munich (Associate) - HT
"Thank you for your help on this!"
Tokyo (Associate) – Internal IT
"The Megaexcel template is AWESOME!!! I just installed it 30 minutes ago and discovered already very nice features which I will use definitly use in the future, but furthermore: I just start to realize how much time I as a Job Manager will save... nearly everything I usually tell a newby in the inital introduction to business modelling is covered in your models and examples - and even tons of more good tips...Great job!!!
so far only positive feedback: I forced my entire team to install Megaexcel and everybody loves it!"
"I wanted to say thanks for taking the time to build the excel tools you have built and also taking time to provide the webinar overview of the tools. I thought my skills in Excel we sufficient until I started with Booz over a year ago and realized how little I actually was using of it capabilities."
Atlanta (Associate) - Ops
"Thanks for all your hard work."
"Hi Michael, congratulations on the megaexcel. it's really great. thanks for your effort!"
Buenos Aires (Sr. Consultant) - HT
"I just installed the new excel toolkit, looks great!"
Amsterdam, (Sr. Consultant)
"Thanks very much for the work on the toolbar- looks like it will be very useful."
London (Sr. Consultant) - ATI
"Thanks Michael, the toolbar looks great and is very helpful!"
Amsterdam (Sr. Consultant) - Amsterdam
"Firstly, great job with the Excel Add-In, a lot of us have been waiting for such as add-in!"
Dubai (Sr. Consultant) - HT
"Just had the Mega Excel plug-in rolled out over here in Australia. It looks really good and I think your introduction to modeling will be a great help to new starters, and even to those of us with a bit of experience."
Melbourne, (Sr. Consultant)
"Good stuff! Thanks for the session and material! Just my initial spontaneous input:
1) Really good road map and inspiring overview
2) Be even more clear in the beginning about this session being a roadmap and not a skills course to manage expectations"
Stockholm (Sr. Consultant) - HT
"Wow. That template is a HUGE improvement. Common formatting, structure, etc . . . it should be much easier for someone to create an analysis and then hand it over to someone else . . . and actually have a good handoff while minimizing errors, understanding and time to absorb/understand. Really cool."
Chicago (Sr. Consultant) - OCL
"I'm very new to Booz and recently had to learn how to do excel modelling for the first time. I find your Excel Add on to be very useful as it provides a quick summary of useful short cuts and introduces many best practices on modelling to 'Excel' beginners. Thank you very much for putting the program and all related documents together."
Sydney (Sr. Consultant)
"Thanks so much again for creating this great tool!"
New York (Sr. Consultant) - IT
"Thank you very much for driving this useful tool!"
Berlin (Sr. Consultant) - HT
"great job on the excel training and toolbar."
Amsterdam (Sr. Consultant)
"Und wenns nur das Handbuch "How to become excellent in modelling" wäre, das wäre schon wirklich klasse! Vielleicht gibts ja eine Möglichkeit, dann könnte ich meine Aufregung vor dem ertsen Excel Modell schon etwas bekämpfen :-)"
Munich (Sr. Consultant)
"I like the new toolbar. I see a lot of time and work has gone into it and it's quite useful."
Canberra (Consultant) - Ops
"I wanted to write to you regarding the Toolkit, I found it very useful because it simplifies the job with several customized shortcuts. I just had the chance to read through the Modeling 101 that you included that looks fine. It's just a great tool."
Buenos Aires (Consultant) - HT
"I have a quick question for you on the fantastic MegaExcel plug-in you've released. Firstly I have to say this is really a great addition to our Boozian laptops - I'm working with the Excel training team in the London office to ensure that all new joiners are familiar with what it can do, and have seen the excellent guidance on data cleaning and model building...thanks very much for putting so much effort into it."
"I simply love the new bar..."
Buenos Aires (Consultant) - HT
"Just got around to installing the add-in and it's great stuff, lots of terrific new functionality."
Chicago (Consultant) - ATI
"Great work with the Excel macro you created."
"Thanks for putting together the Booz mega-Excel add-in -- it's very useful."
Houston (Consultant) - Ops
Great work so far on the Excel Toolbar."
"Thanks for developing the Mega-Excel for us! The cycle shortcuts are great, as is the template library."
Amsterdam (Consultant) - HT
Mclean (Consultant) – A&D
"The toolbar and guide looks very useful, especially for those fresh to excel (wish I had this when I first started using excel). Really like the integration of colours."
London (Consultant) - ATI
Unsolicited Comments from Booz & Company Staff on the MegaExcel Toolbar V3.0
"The next excel macros are fantastic as well! "control-k" for instant pivot chart made the whole install worth it right there :-)"
McLean (Sr. Associate) – EC&U
"Hey man, just wanted to say great job on the Excel toolkit and associated materials...looks great! ok, there's your ego-boost for the day."
Mclean (Associate) – IT
"Great you rolled it out! Now everyone can enjoy it!"
Vienna (Associate) – IT
"Nice guide to Excel Michael. I enjoyed reading it."
Canberra (Associate) - Ops
"Great job! You have definitely made this firm a better place to work."
Los Angeles (Associate) - ATI
"Hi Michael, I've just been through your presentation on how to be awesome at Excel. I felt compelled to write and say thanks for a really clear and useful document. You've managed to explain to me the major things I need to know and practice in excel."
Melbourne (Sr. Consultant)
"Just wanted to thank you and the Mega Excel team - the tool is great and of great help! It also came just in time - I had just started a new model for a client... thanks a lot!!"
Paris (Sr. Consultant)
"Your latest MegalExcel package is fantastic - thanks very much for all the considerable effort you've put in to making it so clear and useful."