Tickmark Excel Audit Add-in by TheSpreadsheetGuru.com

The Tickmark Excel Add-in (Coming Soon!)

OVERVIEW: This is an add-in geared to help analysts understand, audit, or explain spreadsheets easier. Most of the buttons create images that overlay and highlight a portion of the spreadsheet. Here is a brief overview of what this tool can do!

Current Features

Add Ticks - Add various tick mark symbols to your spreadsheet

Remove Ticks - Removes all tickmarks from the ActiveSheet

Data Organizer - Formats all cells based on if they are a formula, hard-coded number, external link, or external formula (referring to another spreadsheet)

Plug Finder - Searches all formulas on the ActiveSheet for plug (+/-) numbers (ie "=SUM(A1:B5) + 5" --- the "+5" would be considered a plug number)

Unhide All - Unhides all worksheets in the ActiveWorkbook

Outside Refs - Lists all the outside sheets that are being fed into the current worksheet's formulas

Legends - Creates a legend where you can inform your users what your color schemes mean

Contents - Creates a Table of Contents tab with hyperlinks to each worksheet

Scroll Up - Goes through every worksheet and scrolls to cell A1 (Top, Left)

Arrow Callout - Draws an arrow based on the currently selected range of cells (you determine direction and size)

Box/Circle Callout - Places a box or circle around the currently selected range of cells

Comment - Adds a comment bubble shape on top of the ActiveCell


Plug Finder Demo - What Do You Think?

What do you think about the Plug Finder button? See it in action here:

What Do You Think?

As I build this add-in, I would love to hear your thoughts and suggestions. I am not currently in the audit profession, so I would more than appreciate hearing from those in the profession and finding out what you would use in an add-in.  Are there specific tickmarks that the Big Four audit firms always use? Let me know in the comments section below!