Excel Roundup 20131202

Excel websites have been around for a long time, answering your spreadsheet questions. Last week, Bill Jelen celebrated the 15th anniversary of his Mr. Excel website, and posted this video. In it, Bill gives an updated answer to the first question that he received.

Were you using Excel way back then?

Contextures Posts

Here’s what I posted last week:

  1. It’s easy to remove duplicates in an Excel worksheet list. Just remember to make a backup before you start.
  2. To get a count of distinct (unique) items in a pivot table, use the free Excel add-in – PowerPivot. It’s available in some versions of Excel 2010 and 2013.
  3. If you’re planning a dinner, use Excel to figure out when everything has to go into the oven.
  4. 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:

  1. This could cause problems — Cameron Lackpour shows how multiple workbooks with links to the same source update each other.
  2. On a lighter note, Charles Williams went to the MVP Summit at Microsoft’s Seattle headquarters, and shared a few pictures from that event.
  3. If you haven’t used Microsoft’s Power Query add-in yet, Arshad Ali shows how to get started
  4. It’s too late for Thanksgiving, but you could use this next year. Stephen shows how to cook a turkey with Excel, by calculating the time to thaw and cook the bird. You’ll have to use an oven though – you can’t actually cook the turkey with Excel.
  5. On the MSDN blog, Lukas Steindl uses Power Map in Excel, to analyze tropical storm activity from 1945 to 2012. It also shows the recent Haiyan typhoon

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 20131202”

  1. I posted a shootout on the fastest way to create flat-files from CrossTabs aka ‘Normalizing your data’ or ‘Performing an UNPIVOT’. http://dailydoseofexcel.com/archives/2013/11/21/unpivot-shootout/
    The end result was some code that incorporated two approaches – snb’s very fast routine that works provided your flat file isn’t too large to fit in the spreadsheet, and my slower routine that writes the crosstab directly to a pivot in the event that a flat file would be too large to fit in a pivot.

Leave a Reply

Your email address will not be published.

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