Excel Roundup 20140203

I’ve seen Excel used to create art, and it can also be use to make bingo cards. This week, I read about a teacher who combines those techniques – she makes art history bingo cards in Excel.

Here’s a picture from her blog post, and you can download the sample file from her site.

excelartbingocard

Contextures Posts

Here’s what I posted last week:

  • In addition to sorting a pivot table’s values from top to bottom, you can also sort the values or grand totals, from left to right.
  • If you import data into Excel, the dates might not format or sort correctly, and you can take a couple of steps to fix them.
  • 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:

  • Even if you don’t like statistics, or it makes your head hurt, take a look at Mike Alexander’s article on identifying outliers in your Excel data. You’ll feel smarter by the end of the article!
  • If you’d like feedback on a chart or other data visualization that you’re working on, check out the new forum – HelpMeViz. Even if you don’t submit your own work, you’ll benefit from reading the comments there.
  • If you need to compile data from several Excel files into one, you can use the sample code that Winston Snyder shared on his Data Prose blog.
  • There was traffic chaos in some parts of the southeastern USA last week, when snow and ice coated the roads. To help out, volunteers set up a spreadsheet, to organize a rescue of stranded motorists.
  • How do you like to learn new computer topics? Video? Books? Dive right in? Videos put Simon to sleep, and he wonders if you feel the same.

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

2 thoughts on “Excel Roundup 20140203”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.