Excel Roundup 20131209

In this week’s video, you can see that Gwyneth Paltrow uses Excel to plan her holiday spending, just like the rest of us. Her budget might be a bit bigger than ours though! She mentions Excel around the 1:00 mark.

Or watch on YouTube: Christmas Preparations

Contextures Posts

Here’s what I posted last week:

  1. Instead of using several clicks to clear pivot table or Excel table filters, add a button that clears them all with one click.
  2. Make it easier for people to enter data in your worksheet, by showing input and error messages on data validation cells.
  3. 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. On the Ask a Manager blog, someone asked, "What’s the coolest Excel trick you know?" Read the comments to see the tips — and there are lots!
  2. Mike Alexander is sharing his Periodic Table of Excel Keyboard Shortcuts, and a Visual Guide to Choosing Chart Types. You can download them in PDF format, until Jan. 1st. You can see the table below.
  3. Rob Collie shows a simple, and useful, trick for combating “stale” Slicers in PowerPivot.
  4. On his Freewheel Burning blog, Pete Larson is dismayed to learn that the fancy new heart risk calculator he heard about is just an Excel workbook. Can Excel really help save lives?
  5. This sparkline tip was in a Tableau article, but could apply to your Excel sparklines too.
  6. Ryan Kelly had a problem with Excel crashing when he used VBA on his MacBook, and explains how he fixed it.
  7. Has your department stopped calling IT for help with Excel projects, because Excel gurus like you are doing the work, as Simon Murphy found?

What Did You Read?

Did you read any other Excel articles this week? Please share a link in the comments, with a brief description of the article.