Excel Twitters, Takeaways and Trials
It's been quite a while since the last one, but I've finally posted another list of Excel Twitters. The Twitter spam was making it too tough to collect the interesting tweets, and that's why I stopped. However, I managed to create a few search settings that helped a bit, and this new list is the result.
The new Excel Twitters list is on my Excel Theatre blog, where I have all the archived Excel Twitters posts, plus some Excel video tutorials, and a few other things.
My friend, Heather Mak, has started a new blog – Five Takeaways. In the blog, Heather and friends will "interview subject matter experts and ask them to provide the five takeaways (hence the name) of a subject area."
She asked if I'd like to create a list of five takeaways for Excel, so I'm working on it. If you'd like to help, please add a comment with one or more things that you'd include as an Excel takeaway. Thanks!
I've been testing some Excel products recently and here's one that I tried this weekend. Mathias Brandewinder of Clear Lines Consulting sent me a link to Akin, an Excel file comparison program. This is a free download, and was very simple to install. Open the Akin program, and select two Excel files to load.
Akin compares the files, and highlights the cells on the selected sheets, where there are differences. You can click on a row or column heading, or the Select All button, to see only the cells where there are differences. That feature is useful in a large worksheet, letting you focus on the differences, without searching through the sheets manually.
The program is easy to use, and a good tool to use if you're trying to find changes that someone else has made in a file. It shows changes to both values and formulas.
Here's a screen shot of the Akin window, with the original and modified value in cell B1 shown.