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.

New Excel Books

What’s new on the Excel bookshelves at Amazon?

powerpivotalchemy PowerPivot Alchemy: Patterns and Techniques for Excel, by Bill Jelen and Rob Collie.
295 pages, Feb. 1, 2014
“This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis.”

 

excel2013dataanalysisMicrosoft Excel 2013: Data Analysis and Business Modeling, by Wayne Winston
”Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables—and how to effectively build a relational data source inside an Excel workbook.”

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.

__________________________________

powerpivotalchemy

You may also like...

2 Responses

  1. Jeff Weir says:

    What! You didn’t read my Did Jeff just Chart? masterpiece. Tch tch. http://chandoo.org/wp/2014/01/27/customer-segmentation-chart/

  2. Thanks Jeff! I’ll have to start a new section — What Jeff Wrote Last Week. ;-)

Leave a Reply to Jeff Weir Cancel reply

Your email address will not be published. Required fields are marked *