I stumbled across an awesome utility add-in for excel that will save you tons of time doing mundane little formulas and formattings to your data. The folks over at ASAP Utilities have created this wonderful tool and it’s completely free for the taking.
There must be over 100 functions in this add-in, here’s a few of the categories:
- sheet manipulations – copy, create (multiple sheets using highlighted cells as the names), deletes, etc, etc
- data manipulations – apply formulas in mass, convert text to numbers and vice versa, tons of stuff
- Text formatting
- Range manipulations
- Mass cell selections
- many many many more … you have to see this to appreciate
Here’s their download page.