How-To Geek on MSN

How to use fuzzy matching in Power Query to clean up Excel data

Merge lists even with typos and inconsistent names. Tune the similarity threshold, use a transform table, and audit results ...
Investors Chronicle

IC Investing Online: Excel Web Queries

Q: My book on Excel 97 explains how to download information from a website directly into Excel using a Web Query. Is it possible to use the Web Query facility in Excel with the IC site? A: Yes. The ...