Excel Productivity Addin
$39
Make the most of my Excel models Excel addin of the tools that I use the most and coe functionality to convert currency formatting of all my models.
- Excel plugin
- 9 core functions
- Designed for my models
- Focused on core uses
quicky
Meet Your New Best Excel Friend
INTRO
Overview of the Excel Productivity Addin
Tl;dr: Excel plugin designed for my models with my most used automation.
- Change currencies in all my models
- Hit a button to save a new version of a model
- 7 other key automation
Excel
- Excel financial model
- Built for PC and Mac
- Not for Google Sheets
Unlocked
- Works for all my models
- Nothing is locked or restricted
Updates
- The plugin is updated with new features as requested by you
- I’ll email you updates when they’re done
Support
- If you’re really stuck, ping me an email or catch me if I’m online and I’ll help you figure out what to do for free
Video
Addin Walkthrough
understand the addin
Be Guided Through How to Understand Addin for This Game changing Tool
No one wants to invest in a tool that promises to make their life 100x better without some hand-holding in how to use it! Tools are only as good as you use them.
I made a video to guide you through the Addin.
Details
Let’s Go Through All the automation in the Plugin
You can convert currencies
I’m in Israel, I Need to Show My Currency!
Having listened to founders’ needs for years, I know some founders don’t want to use Dollars. Cool. You can mash a button and turn your currencies can change to 17 other signs.
This model uses formatted currencies in $ (Why I use US Dollars). I often get asked if it is available in other currencies such as €? So I made an Excel PC to do that (It was hard!)
At the press of a button, you can now convert the model into 17 different currencies. You just need to purchase the productivity add-in.
Here are the currencies you can use with the macro.
Currency list | The format you will see |
---|---|
EUR | € |
USD | $ |
GBP | £ |
YEN | ¥ |
INR | ₹ |
Krone | kr |
Peso | kr |
BRL | R$ |
RM | RM |
HKD | HK$ |
ILS | ₪ |
- Exclusive to all 50Folds fundraising models, with the press of two buttons you can change the currencies of the 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.
Repeatedly Create a New Version of Your File So You Have Backups
- You should create multiple versions of your model as you build it in case you mess up!
- Press this button every time you have done a lot of work to automatically create a new version of your file.
- When you press it, it will add “v1” to your file. Press again and “v1” will become “v2”
Change Formula References (E.g. A1 to $A$1).
Change A1 to $A$1 and other variances in formulas for the cells you have selected. This is incredibly useful once you know how to use it. Examples:
- Absolute = 1 (Example $A$1)
- Row absolute = 2 (Example A$1)
- Column absolute = 3 (Example $A1)
- Relative = 4 (Example A1)
- Magically add an IFERROR statement to your cell selection so no more ugly errors. It will show an “N/A”.
Add IFERROR Checks to Selected Formulas with a Zero
- Magically add an IFERROR statement to your cell selection so no more ugly errors. It will show a “0”.
- Sometimes it is better to show a zero in case dependent formulas don’t like N/A.
Change If(ISERROR) to IFERROR Formulas Which Are Easier to Read
- You used to have to use IF(ISERROR()) formulas. IFERROR is far easier to read as is half as long.
- This utility will convert your formulas to IFERROR making it fast to update models you have made.
Transpose Your Cells from Horizontal to Vertical Without Changing Your Formulas
- If you have formulas in a row and you want to make a copy of them so they are vertical, run this.
- If you are making cohorts, this is a really handy tool.
Make or Rebuild Array Formulas
- Sometimes you have to have array formulas to make formulas work.
- You need to press “CTRL/CMD+Shift+Enter” and if you forget to do it it is annoying.
- Sometimes you want to change arrays and it’s painful to do manually.
- This will make/rebuild array formulas for your selection.
Set the Zoom on Each Sheet to Your Desired Focus
- As you model, you might zoom in and out on different sheets leaving each sheet at a different zoom.
- This tool will instantly zoom to your desired %. I most often use 85% and 100%.
Change Formulas, Assumptions and Links to the Right Colors
If you have a large model and you haven’t set the right colors for everything, this tool will instantly format everything for you.
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
Sets Every Sheet to A1 So Your Model is Set Up to be Read Perfectly
- Before you share your model you want to have each sheet at the top (In cell A1) so it’s easy to read.
- If you have been modeling then you may be halfway down sheets.
- This sets everything so it’s ready to be read by someone else.
Resize and Reposition All Your Comments to the Right Place
- Comments can more around and be sized the wrong way. That’s boring to fix.
- This formats all your comments right so they are the right size and in the right position.
Find All the Links to External Sheets
- Creates a new sheet with the location of any links to another sheet.
- If you get annoyed with notices on open about ‘External links’ this will fix it for you.
- 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!
Remove Styles in Your Sheet That You Are Not Using
- Removes any format styles you aren’t using so cell styles are clean.
- Sometimes this can make your file faster, but it just cleans things up for best practice.
Check the File Size Per Sheet
- Creates a sheet with the bytes for each sheet so you can see if a particular sheet has become too large.
- This happens when Excel thinks you are using cells you are not.
- 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.
Remove All the Comments in Your File
- You can delete ALL comments in a sheet.
- For example, with a 50Folds model, if you don’t want to see my comments, it’s easy to remove them all!
Who made this model?
Alexander Jarvis
CEO & Founder
- I’m the #1 seller of startup financial models in the world
- Worked in M&A (Lazard Financial Institutions Group)
- I intimately know startups and what VCs care about having done both for over 10 years
- TEDx, Top Quora Writer, accelerator mentor, fund advisor etc
- I made the first version of this model for my own $20m raise
Purchase
Excel Financial Model Plugin
Convert currencies in my models, save the file version with a button smash (so you never lose files), and the macros I actually use in one place!
What’s inside
- Excel plugin
- Works with all my models
- 9 core functions
Comments (10)
-
-
Um, thanks?
-
Dear Jarvis
I have explored the statements and really useful formats and I m student yashika Vyas from Bangalore India and willing to start the e commerce online business ..would request you to give me some discount to purchase your product ..Please reply and expecting reply on [email protected]
Many Thanks-
I don’t do that
-
-
-
-
I’m looking to use Per User Pricing for a range of different online learning modules.
Can that be incoporated into this model?
-
Wasif – this is a plugin, not a model
-
-
How do we change the currency of the workbook if we are using a Mac?
-
Colman – I hired a VBA nerd to audit and check the plugin worked on mac and he said all good.
-
-
Is the add-in (partially/fully) compatible with Excel for Mac (2019 )?
-
Hey Xander – sorry slow reply. I hired a dev to check my code. He said it’s fully compatible with mac.
I tested ages ago and I think I only had one issue with one macro so I added a caveat. But as I said, I hired a better coder than me to check and he said all good.
If any issues I’ll hire someone to fix it asap.
-
I like the pictures