Current Version: Version 1.3
Compatibility: PC Only | Excel 2007 - 2016 | Works on 32-bit or 64-bit
License: Up To 3 of your personal devices per single license
Help Page: Tickmark Help Page
Understand And Audit Spreadsheets With Ease!
The brand new Tickmark Excel Add-in is a tool geared to help analysts understand, audit, or explain spreadsheets easier. This add-in was built to help all users of Microsoft Excel alleviate the painful process of getting handed another person's spreadsheet model and needing to understand it, improve it, or audit it quickly and effectively.
Add Tickmarks To Your Spreadsheet
Add various tickmark symbols to your spreadsheet with a click of a button. The icons available in the add-in include:
- Popular Symbols
- Numbering 1-99
- Letters A-Z
- Various accounting abbreviations
Instantly Remove Your Tickmarks
Need to start over or clean up the spreadsheet? Use the Remove Ticks button to remove all the tickmarks added on the active spreadsheet.
Choose Your Own Colors!
You can choose to insert your tickmarks as pictures or shapes. If you choose the "shapes" option, you are free to change the fill color as you would any other Excel shape. If you want a specific color by default, you can set preferred color formats for most of the tickmark icons in the Settings Userform.
When you first get handed another person's spreadsheet model, one of the most overwhelming parts can be understanding the setup of the overall model.
With the Tickmark Add-in's Data Organizer button you can easily decipher whether the data on a spreadsheet falls into one of the following categories:
- Hardcoded Number
- Off-Sheet Referencing Formula
- Formula with a Plug
Take a look at how running the Data Organizer can quickly turn plain data into being meaningfully formatted. The Data Organizer can be run on an entire spreadsheet or just on an area of selected cells.
As you can see from above, after running the Data Organizer you can immediately tell what numbers are being input into the spreadsheet and where the formulas are located. The Data Organizer even caught a formula for Widget 7 within the spreadsheet that had a +20 added to it that you may want to look into.
The Data Organizer's applied formats are not limited and you can go into the Tickmark settings and change any of the fill or font colors to match your formatting preferences.
You can even click a button to insert a pre-built legend so you can easily inform users or remind yourself what each format represents.
Insert Hyperlinked Contents Tab
Another pain point that can arise while getting to know a spreadsheet model is navigating the shear size of the model itself! How many times have you been give an Excel file to update and there are over 50 tabs to try and decipher? The Tickmark add-in allows you to insert a Table of Contents tab with hyperlinks to each one of the spreadsheet tabs in your workbook. You can also add "Back" buttons to each tab so you can easily flip back and forth between all the spreadsheets.
Find Plugs In Formulas
Adding a plug can be common practice if you need your number to visually foot or if you have a one-off reason to modify a calculation. There are typically two ways to make such adjustments (1) add the plug off to the side of your analysis and modify your formula to point to the "Plug Cell" or (2) just add the number directly into the formula itself.
Plugs directly inside formulas can be detrimental because they can be easily forgotten about, they are not visible, and are often times not documented as to their reason for being there.
After running the Plug Finder on a spreadsheet tab, you instantly get a list of cells containing plugged numbers within formulas. These cells are also marked with a marker of your choosing (dot, circle, or box) in order to bring attention to the cells that were possibly tampered with. The markers are all shape objects, so they will not affect any formatting on your spreadsheets.
Unhide All Sheets
Tired of individually unhiding each tab hidden in your Excel file? With the Tickmark add-in you can unhide all worksheets in your Workbook (including Very Hidden worksheets) with one click of a button!
Lists all the outside sheets that are being fed into the current worksheet's formulas. This instantly gives you visibility into what tabs are feeding into your current worksheet.
The listing includes Internal sheets inside your workbook and External files referenced.
The almighty Formula Auditing tools found in Excel's Formulas tab has been replicated so you have quick access to these powerful functionalities within the Tickmark Add-in.
Insert An Arrow Shape To Point Things Out
Draw and insert arrows based on the currently selected range of cells. You have the ability to determine the direction and length of the arrow based on how you select your cells. You can also go into the Tickmark Add-in settings and determine the default line color and line thickness for your arrows. Take a look at how various cell selections determine how the arrow looks!
Highlight Important Info with Boxes & Circles
Places a box or circle around your currently selected range of cells. This is a great way to bring attention to specific parts of your data that need attention. Through the Tickmark Settings you can even determine the default border color and thickness to make your boxes and circles align with your preferences.
Create Comment Bubbles That Actually Stand Out
Add a comment bubble shape on top of the ActiveCell. You determine the direction of the spike. You can also go into the Tickmark settings and set your own default color formats and shape size!
The Tickmark add-in comes with lots of formatting and functionality settings allowing you to completely customize the add-in to your preferences.
Create a legend where you can inform your users (or remind yourself) the meaning behind your color schemes. Select mulitple cells to create more than one at a time.
Scroll To The Top Of Every Tab
This button goes through every worksheet and scrolls to cell A1 (Top, Left). This is a great feature to run before sending your model off to someone or when you first open up a model to ensure you are starting off at the very top of every spreadsheet you dig into.
A Free 14-Day Trial Just For You
I personally couldn't live without this add-in but I can understand if you think you may not use it. That is why I am willing to provide you with a trial version of this add-in so you can try it completely free for 2 weeks. I don't lock down any of the features, so you have complete access to every functionality!
Free Future Updates
As with all purchased products sold by TheSpreadsheetGuru, you don't have to worry about purchasing too early! After you purchase this add-in, you will be placed on an exclusive updates email list where you will directly receive any update made to this product.
30-Day Money Back Guarantee
I'm so confident you will love this add-in, I'm willing to give you 30 days from your purchase date to decide if this is the tool for you. If you come to the conclusion that this add-in was not what you were expecting, just shoot me an email and I'll refund you your money back.
So what's there to lose? Now is your opportunity to pick up this revolutionary add-in that will change the way your interact with your spreadsheets. Click the Buy Now button below to quickly get your hands on this amazingly powerful Excel add-in!
What Are You Waiting For?!
Stop struggling to understand huge and complicated Excel Models and use the Tickmark Add-in to help create order in your spreadsheets. Tickmark is not just an add-in for auditors but a tool every analyst can use to ensure his or her models are accurate and can easily be understood by others. Pickup a copy of the Tickmark Add-in today!
Have A Question? Ask Away!
You can use this form to directly communicate with me in case you have questions about features, need a PO for a bulk order, or have any other needs concerning this add-in. I can typically reply back to you within 24 hours.
Leave A Review Of Tickmark!
I want to hear from you! Share your story of how Tickmark has help you or your company. I love hearing feedback and getting ideas for future updates. I look forward to reading your thoughts! :)