What happened in the world of spreadsheets last week? Here’s the latest roundup.
Contextures Posts
Here’s what I posted last week:
To narrow down the choices for data entry worksheets, you can remove used items from a data validation drop down list. That’s a big help in some sheets, where you shouldn’t choose the same item twice.
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:
Excel Card: If you haven’t sent your Christmas cards yet, you could use this Excel greeting card, from Jordan Goldmeier.
Totals: 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.
REST API: Microsoft’s Excel team shows how you can get started using the Excel Services REST API in the cloud.
Excel Books: 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.
Excel Bug: Charles Williams has found a Status Bar Calculate bug in Excel 2013, and he hopes it’s fixed soon.
Excel Front End: 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.
__________________________________
0 thoughts on “Excel Roundup 20131223”