Current Version: Version 3.0
Compatibility: PC Only | Excel 2007 or later (including Office 365 Desktop) | Works on 32-bit or 64-bit
License: 1 per user
help-page: Tickmark Help Page

Understand And Audit Spreadsheets With Ease!
The 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.
Bulk Discounts For Your Organization
Buy Tickmark for your whole team, department, or company and save! The discounted price will be applied automatically during your checkout process.
-
5-9 units per single order –> 10% off the total cost
-
10+ units per single order –> 15% off the total cost

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 to 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 using RGB color codes.


Everyone is Different, So Create Your Own!
While the Tickmark add-in comes with pre-built Tick icons for you to use, the tool also gives you the ability to create up to 30 of your own Tickmark icons. Simply import a picture into your spreadsheet or create your own icon from scratch using Excel shapes and then upload it using the Custom Tick Manager. The Tickmark add-in even has the ability to create a Ribbon icon that looks exactly like your custom creations!

Feature Video
If you are curious about how this feature works, the below video walks you through a couple of different methods to create and store your very own custom tickmark icons with the Tickmark Add-in

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.
Data Organizer
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
-
Formula
-
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 (with “Back” buttons)
Another pain point that can arise while getting to know a spreadsheet model is navigating the sheer size of the model itself! How many times have you been given 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 choose to order the links Alphabetically or in the tab order. You can also add “Back” buttons to each tab so you can easily flip back and forth between all the spreadsheets.

Insert Instructions Tab
Let’s face it, one of the most undervalued tabs in a spreadsheet is the Instructions Tabs. It’s unfortunately far too many people forgo documenting how to use/update the spreadsheets they create. Tickmark attempts to make this step in the creation process a bit easier by allowing you to click a button and instantly create an Instructions tab that is ready for you to fill out.
Inserted is a tab at the beginning of your workbook named “Instructions” that has a textbox pre-created with bullets so you can begin to type away those vital instructions so you don’t have to worry about taking vacation days while your teammate updates your files!


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 oftentimes 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!
Outside References
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.


Formula Auditing
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.


Spreadsheet Legends
Create a legend where you can inform your users (or remind yourself) of the meaning behind your color schemes. Select multiple 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.
Link Tick Icons
Seamlessly create hyperlinks between your Tickmark icons to navigate complex models or create Audit Trails.

Wait…There’s More!
-
Convert selected cells to numerical values (great for vlookups & xlookups!)
-
Convert selected cells to text (great for vlookups & xlookups!)
-
Swap two selected cell ranges with each other
-
Add outline groupings to all hidden rows or columns
-
Collapse/Expand all outline groupings (for selected sheet or entire workbook!)
-
Remove all outline groupings (for selected sheet or entire workbook!)
-
Unhide all hidden rows/columns/both (for selected sheet or entire workbook!)

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! Download the Free 14-Day Trial Here.

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 you interact with your spreadsheets. Click the Buy Now button below to quickly get your hands on this amazingly powerful Excel add-in!
No Monthly Subscription Fees
Once you purchase this add-in you will never have to pay anything further. There are no hidden fees or monthly charges.
Add-in Licensing
Each license purchased (ie add-in unit) of this product is licensed for use by 1 user. This single user may activate this product on up to three of his/her computing devices to account for future equipment refreshes or working at home. If users are found attempting to share licenses, we reserve the right to terminate add-in functionality immediately.
Companies may choose to purchase multiple licenses (add-in units) in a single order. Once the license codes are distributed and activated, they will be tied to the respective users. Companies may contact TheSpreadsheetGuru via email in order to transfer licenses in the event an employee leaves the company or no longer needs the product’s functionality. Feel free to contact us if you have any questions/concerns surrounding the licensing process.
Bulk Discounts For Your Organization
Buy Tickmark for your whole team or department and save! The discounted price will be applied automatically during your checkout process.
-
5-9 units per single order –> 10% off the total cost
-
10+ units per single order –> 15% off the total cost
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. Pick up a copy of the Tickmark Add-in today!