Excel Roundup 20131223
What happened in the world of spreadsheets last week?
Here’s a video from the Microsoft Office team, showing a couple of cool, and free, tools that you can download – Mouse Without Borders and Office Remote. Your family might be impressed, if you show them these tools during the holiday get-togethers. My family would probably say, “Please move, you’re blocking the television.”
Here’s what I posted last week:
- To narrow down the choices, you can remove used items from a data validation drop down list..
- An updated version of my data validation combo box technique, that lets you add new items on the fly.
- Finally, for a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read last week, that you might find useful:
- If you haven’t sent your Christmas cards yet, you could use this Excel greeting card, from Jordan Goldmeier.
- Apparently it was sporadic totals week, and nobody told me! To see how to achieve this, you can watch videos by Chandoo, Mr. Excel and Kevin Lehrbass. Pick just one, or watch all three! There is a screen shot of sporadic totals below, if you’re not sure what they are.
- Microsoft’s Excel team shows how you can get started using the Excel Services REST API in the cloud.
- Simon Murphy wonders if he should write a book about Excel development. What do you think? Maybe he could start with a chapter or two, sold as a mini-book on his website, and see how that goes.
- Charles Williams has found a Status Bar Calculate bug in Excel 2013, and he hopes it’s fixed soon.
- Scott Lyerly is looking for your input on his Excel as a front end solution. What do you think about his idea of keeping SQL statements in a database table, and using those to update the code in an Excel file?
What Did You Read?
If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.
Please include a brief description, and a link to the article.