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. Things were slow during Thanksgiving week, so Chandoo posted an "Ask Me Anything" challenge. Read through the questions, to see what people wanted to know.
  2. This could cause problems — Cameron Lackpour shows how multiple workbooks with links to the same source update each other.
  3. On a lighter note, Charles Williams went to the MVP Summit at Microsoft’s Seattle headquarters, and shared a few pictures from that event.
  4. If you haven’t used Microsoft’s Power Query add-in yet, Arshad Ali shows how to get started
  5. 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.
  6. 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

New Excel Books on Amazon

Here are the latest Excel books on Amazon.

PowerPivot for Advanced Reporting and Dashboards, by Robert Bosco J

“will teach you the fundamentals of PowerPivot as well as how to use the different data types available. This book also discusses useful tips and tricks for handling and resolving errors that might pop up while creating your report. With this book, you will be able to create relevant BI reports quickly and efficiently… You will then delve into relationships, hierarchies, and data model creation using imported data. You will also learn how to employ DAX functions to transform unstructured data into structured data.”

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.

__________________________________

powerpivotadvanced

You may also like...

2 Responses

  1. Jeff Weir says:

    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 to Debra Dalgleish Cancel reply

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