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.
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 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
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