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!
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!