Current Version: Version 1.0
Compatibility: PC Only | Excel 2007 - 2016 | Works on 32-bit or 64-bit

# SideKick (Every Superhero Needs One!)

This very simple add-in is the one tool I use every single day as a financial analyst. As a data analyst, I retrieve data from all sorts of sources. This includes databases, websites, and other Excel files. The one problem I kept running into is not all these sources provide numbers in the same way. One database might report pounds while another reports tons, one spreadsheet might have numbers in thousands when the rest of my data is in millions.

After years of manually "massaging" my data, a brilliant idea came to me....what if I had a tool that could quickly do all these mathematical tweaks for me? A couple months of testing and tweaking later, my SideKick was born!

Here's a preview of this powerful tool in action!

## Skip Over Text, Formulas, Dates, And Blanks!

The special power of SideKick is that it only affects the types of data you want it to affect. By default, Sidekick will only perform its calculations on hardcoded numbers (excluding dates). This means if you have subtotal formulas within your data, you don't need to worry about holding down the Ctrl key and manually excluding them from your selection. You can select the whole range and quickly put SideKick to work!

## Accelerator Keyboard Shortcuts

For all you shortcut junkies out there, SideKick has keyboard shortcuts to quickly navigate the userform. By keying the Alt key and a specific letter key, you can enable or disable a particular option. The letter used in combination with the Alt key is underlined within the option label.

Below is a list of all the possible shortcuts you can use with SideKick. My favorite is using Alt + s and then Enter to quickly change the signs of my range selection.

• Divide By [Alt + d]
• Multiply By [Alt + t]
• Add To [Alt + a]
• Subtract From [Alt + c]
• Calculate [Enter Key]
• Include Formulas [Alt + f]
• Switch Signs [Alt + s]
• Zero Out [Alt + z]
• Include Blanks [Alt + b]
• Hardcode Numbers [Alt + r]

## SideKick Can Reside In Many Different Places

Since SideKick is just one button, I didn't want to create a whole new tab so I decided to default the SideKick button inside the Formulas tab. If you really don't want it there, you can go into the settings and move SideKick to its own tab (the Add-ins tab).

I highly recommend that you also include SideKick in your QAT (Quick Access Toolbar). By having SideKick reside in your QAT, you can call SideKick every time you need him from your keyboard. The keyboard shortcut to call a QAT button is the Alt key and a number (based on button order in the QAT). For example, in the below diagram, you could use the keyboard shortcut Alt+3 to call SideKick. This is because Sidekick is the 3rd button in the QAT.

In order to add SideKick to the QAT, simply right-click on the SideKick button and select Add To Quick Access Toolbar. You can then move the SideKick button into a different position within the QAT by right-clicking on the SideKick button again and selecting Customize The Quick Access Toolbar. It's that simple!