- Ignore Conversations in Outlook
- Wedge Mouse – didn’t know something like that exists!
- Excel 2013 Insert Live Chart – gives you a nice preview of what your chart would look like before actually creating one
- Instant Math in OneNote – gotta love OneNote
- Templates with Instructions
- Excel Surveys in Office Web Apps – this looks similar to a google spreadsheet form
- Copy Docs in Program
- Get Windows Surface RT with Office 2013
- Office Web Apps + SkyDrive in Windows Explorer – Download Skydrive for windows
- PDF reflow in Word 2013 – take a PDF and make it editable
Got any more? Leave me a message below.
“A challenging problem in data management is that the same entity may be represented in multiple ways throughout the dataset. For instance, customer “Andy Hill” might also be present as “Mr. Andrew Hill” or “Hill, Andrew R.”. Variations can result from merging independent data sources, spelling mistakes, inconsistent naming conventions and abbreviations, or records with additional/missing information.
Fuzzy Lookup technology, developed by Microsoft Research, allows you to quickly identify data records which are textually similar. You can identify fuzzy duplicates within a single table or perform a fuzzy join between two different tables. The default configuration works well for a wide variety of data, but the matching may also be customized for specific domains.”
Download the tool here: http://www.microsoft.com/download/en/details.aspx?id=15011
Here is a very simple example. I created two tables as shown:
|Upendra Rao||Rao, Upendra|
Here is the join I defined:
Here is the output:
|Upendra Rao||Rao, Upendra||1.0000|
|Upen Rao||Rao, Upen||1.0000|
Here is another example:
For people who work with Data a lot, I think this is a good tool to have in their toolbox.