Spreadsheet Day Rotating Header Image

Spreadsheet Roundup 20150107

Here is a roundup of selected spreadsheet articles from last month.

  • If a data validation list has hundreds of items, this technique can help. Type a couple of letters in one columns, and see a short drop down list in the adjacent column, with only items that contain those specific letters.

Links to Recent Excel Books on Amazon.com


Spreadsheet Day 2014 Roundup

Spreadsheet Day http://spreadsheet-day.com/blog/

Yesterday was Spreadsheet Day, and we celebrated the 35th anniversary of the VisiCalc release and shipping date.

The celebration is getting more popular every year, and below are some of the articles that I found yesterday.

Thanks to everyone who participated!


Happy Spreadsheet Day 2014

Spreadsheet Day http://spreadsheet-day.com/blog/

Happy Spreadsheet Day 2014! This is the 35th anniversary of the VisiCalc launch date in 1979, so I hope that you have some special celebrations planned.

If you’re not sure how Spreadsheet Day began, you can read the history here.

Spreadsheet Day is now listed in the Days of the Year website, so you can show that page to your boss, when you ask to have the day off, as an official holiday.


Spreadsheet Roundup 20140701

Spreadsheet Day http://spreadsheet-day.com/blog/

Here are a few of the spreadsheet articles that I found recently, that you might find useful:

  • Randall Bolten lists 19 spreadsheet tips that will make you a faster and better spreadsheet user. There are 2 categories – Instant payoff tips, and long-term payoff tips.
  • Did you know that you can use a function to display images in a Google spreadsheet? Learn that tip, and 9 more things you can do.


Spreadsheet Guru Contest 2014

Spreadsheet Day http://spreadsheet-day.com/blog/

This looks interesting – the Analytics section of INFORMS is holding its 3rd annual Spreadsheet Guru contest.

In case you’ve never heard of them, The Institute for Operations Research and the Management Sciences (INFORMS) is the largest society in the world for professionals in the field of operations research (O.R.), management science, and analytics. You might be familiar with its Spreadsheet Productivity Research Interest Group (SPRIG).