50Folds Excel Productivity Addin For Modeling

Alexander Jarvis
Aug 21, 2018 · 5 min read
Image for post
Image for post

A collection of my most recommended productivity hacks for modeling. These are exactly what I use to build my huge models. You can have them too, now.

Image
Image

Buy €39

Swap currencies in your model

Start by picking the currency you want as per instructions. Then just push this button to change everything.

Wait ten seconds and it’s done. You can change to another currency easily. This doesn’t work for other models.

Image
Image

Currency list EUR € USD $ GBP £ YEN ¥ INR ₹ Krone kr BAHT ฿ RUB ₽ Peso ₱ BRL R$ RM RM Rp Rp HKD HK$ ILS ₪ KPW ₩ RMB ¥ CHF CHF

Repeatedly create a new version of your file so you have backups

Image
Image

Change formulas references (E.g. A1 to $A$1).

  • Absolute = 1 (Example $A$1)
  • Row absolute = 2 (Example A$1)
  • Column absolute = 3 (Example $A1)
  • Relative = 4 (Example A1)
Image
Image

Add IFERROR checks to selected formulas

Image
Image

Add IFERROR checks to selected formulas

Image
Image

Change If(ISERROR) to IFERROR formulas which are easier to read

Image
Image

Transpose your cells from horizontal to vertical without changing your formulas

Image
Image

Make or rebuild array formulas

Image
Image

Set the zoom on each sheet to your desired focus

Image
Image

Change formulas, assumptions and links to the right colors

It sets your assumptions to blue, formulas to black and links between sheets to green. This is the investment bank standard.

This model has three macros:

  • Color selection
  • Color sheet
  • Color workbook
Image
Image

Sets every sheet to A1 so your model is set up to be read perfectly

Image
Image

Resize and reposition all your comments to the right place

Image
Image

Find all the links to external sheets

You really need to watch out for this as your numbers will not be accurate. This will tell you the sheet and cell where the external links are so you can fix the formulas. Life saver!

Image
Image

Remove styles in your sheet that you are not using

Check the file size per sheet

When you find a sheet that is too large, go to the bottom of the sheet and delete all the rows/columns (“CMD”/”CTRL” + “-”) to fix that.

Image
Image

Remove all the comments in your file

Get it now

Buy €39


Originally published at .

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch

Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore

Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store