12 time-saving add-ins will increase your efficiency in Excel by 50%. The plug-ins will automate the most common tasks such as removing duplicates, merging tables and cells, combining data from duplicate rows, generating random numbers, clearing data, finding and replacing in all workbooks, shuffling and selecting random rows, columns and cells, splitting names, navigating between workbooks and worksheets etc. The add-ins work in Excel 2003-2010. Mehr…

With this nifty add-in you can quickly clean your data imported from an external source. It will help you remove leading and trailing spaces, excess spaces between words, non-breaking spaces, line breaks, non-printing characters and other unwanted symbols. You can also convert words to a proper case: UPPER, lower or or Proper Case; change numbers stored as text to number format and delete apostrophes. The add-in works with Excel 2003-2010. Mehr…

Mit diesem Add-In können Sie in Excel-Tabellen Dubletten oder einmalig vorkommende Inhalte finden. Bei der Dublettensuche in einem Bereich oder dem Vergleich zweier Listen unterschiedlicher Spaltenzahl dürfen Sie beliebige Vergleichsspalten wählen. Dubletten können Sie löschen, selektieren, färben oder an einen anderen Ort kopieren (neue Arbeitsmappe, neues/altes Arbeitsblatt). So funktioniert's: http://www.ablebits.com/go.php?to=drevideo-s Mehr…

This nifty 10-piece collection for Excel makes common tasks easy and fast. The utilities will help you move columns by drag-n-dropping; delete all empty cells, rows and columns; filter by the selected value, calculate percentage, apply any basic math operation to a range; copy cells' addresses to clipboard, synchronize selection on different sheets and much more. Try them and enjoy the results! Mehr…

Silent BCC for Outlook is the perfect tool to monitor outgoing e-mail. Once installed, the plug-in will deliver you BCC copies of all messages sent from all user accounts of a PC. Users won't ever know that a BCC copy was sent from their machines since BCC addresses are removed from Sent Items. They can't turn off the plug-in or alter your monitoring settings. You can tweak the add-in to be copied on every outgoing e-mail or allow exceptions. Mehr…

Split a column of names into individual cells in no time. If you have a spreadsheet with numerous differently formatted names in the same column, the Split Names add-in will quickly clean up the mess and separate name parts into several columns. The add-in works for Excel 2010 - 2003 and perfectly recognizes First names, Middle names, Last names, and over 100 salutations, name suffixes and post-nominal letters. Mehr…