Category: Microsoft (Windows OS & Office)

Perform Fuzzy Lookups / Approximate String Matching in Excel — Smoak Signals | Business, Technology, Etc.


Most likely you have a love/hate attitude towards spreadsheets. This highly useful tip will make you fall back in love with Excel. Microsoft does a great job at providing a solid add-in that makes fuzzy lookups relatively easy to perform. Are there more powerful approximate string matching tools out there? Of course. But if you’re using Excel, this […]

via Perform Fuzzy Lookups / Approximate String Matching in Excel — Smoak Signals | Business, Technology, Etc.

Advertisements

via #Excel Native 3D Ranges with the TEXTJOIN Function Plus Bonus by David Hager — Excel For You


In a conversation with Bill Jelen about the TEXTJOIN function, he mentioned whether I had tried using 3D references as arguments. I said that I had not tried native 3D ranges, and I did not believe it would work. Well, I was wrong (again). It does work, in spite of there being no documentation from […]

via #Excel Native 3D Ranges with the TEXTJOIN Function Plus Bonus by David Hager — Excel For You

Sumif function – Excel — PC Tipster’s Blog


Sumif is a powerful function where you can total numbers that meet a specific criteria. Learn how to do this in 67 seconds!

via Sumif function – Excel — PC Tipster’s Blog

via How to make your presentation stand out — Cassey Louise


I don’t think any of us could count how many times that we used the same templates for our PowerPoint presentations. Although switching to Prezi was a quick fix for time constrained creativity, making your presentation stand out takes more than switching programs. Whether you’re presenting research to a panel, pitching an idea to your […]

via How to make your presentation stand out — Cassey Louise

Norton releases new Windows 8 compatible apps – Computer Business Review


Norton releases new Windows 8 compatible apps – Computer Business Review.

Azure plugin for Eclipse with Java


Azure plugin for Eclipse with Java.

As the Microsoft developer world turns: Guidance for the perplexed | ZDNet


As the Microsoft developer world turns: Guidance for the perplexed | ZDNet.