Just another Blog

My Technical, Professional and at times Personal Blog

Showing posts with label Excel 2010. Show all posts

Microsoft Office: Top 10 Tips

  1. Ignore Conversations in Outlook
  2. Wedge Mouse – didn’t know something like that exists!
  3. Excel 2013 Insert Live Chart – gives you a nice preview of what your chart would look like before actually creating one
  4. Instant Math in OneNote – gotta love OneNote
  5. Templates with Instructions
  6. Excel Surveys in Office Web Apps – this looks similar to a google spreadsheet form
  7. Copy Docs in Program
  8. Get Windows Surface RT with Office 2013
  9. Office Web Apps + SkyDrive in Windows Explorer – Download Skydrive for windows
  10. PDF reflow in Word 2013 – take a PDF and make it editable

Got any more? Leave me a message below.

Excel 2010 Fuzzy Lookup Addin

“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:

Column1 Column1
Upen Upend
Upendra Upendra
Upendra Rao Rao, Upendra
Upen Rao Upendra.Rao
Upendra|Rao
Rao, Upen
Upen, Rao

Here is the join I defined:

image

Here is the output:

Output
Column1 Column1 Similarity
Upen Upend 0.9435
Upendra Upendra 1.0000
Upendra Rao Rao, Upendra 1.0000
Upen Rao Rao, Upen 1.0000

Here is another example:

        Output    
Column1   Column1   Column1 Column1 Similarity
1   10   1 1 1.0000
2   3   2 2 1.0000
3   4   3 3 1.0000
4   5   4 4 1.0000
5   1   5 5 1.0000
6   2   6    
7   7   7 7 1.0000
8   9   8    
9   0   9 9 1.0000
10   4   10 10 1.0000

For people who work with Data a lot, I think this is a good tool to have in their toolbox.

Google+ Followers