Spreadsheet Day Rotating Header Image

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


Spreadsheet Day 2013

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

Happy Spreadsheet Day 2013! In honour of this special occasion, here is a collection of my favourite spreadsheet tweets from this year.

I collect and post Excel tweets every Friday on my Excel Theatre blog. They give an interesting glimpse into the strange and wonderful ways that people use (and abuse) spreadsheets.

And remember, onions and spreadsheets don’t mix!


Create Labels in Microsoft Excel

On her blog, A Typical English Home, Angela Shear shows us how to make labels in Excel.

These aren’t the typical, boring address labels that you’d make at the office. No, these are fun labels, that you can stick onto a child’s toy box, to show what’s inside.


Easy to Use

Yes, Excel was built for budgets and lists, but creative people have found thousands of other uses for it too. As Angela explains:

“All you need is Microsoft Excel. It is incredibly user friendly and even though I’m relatively proficient in the Paint Shop Pro software I’ve had for years I still tend to favour Excel for label making!”

See the Instructions

I don’t see a sample file that you can download, but there are step-by-step instructions for making the labels.

To see the details, click here: How to Make Labels


Spreadsheet Day 2012

SpreadsheetDay822Happy Spreadsheet Day 2012! What are you doing to celebrate?

To mark this special occasion, I’ve posted links to 5 of my favourite Excel tips from the past year, on my Contextures Blog.

The tips include:

  • adding check boxes to a worksheet, that you can double-click to add a check mark
  • creating a chart with conditional formatting based on labels and values
  • building an interactive sales dashboards
  • and two more tips.

If you have any other favourite spreadsheet tips, for Excel or any other spreadsheet program, please share them in the comments below.