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.

Contextures Posts

Here’s what I posted last week, on my Contextures site and blogs:

Instead of using several clicks to clear pivot table or Excel table filters, add a button that clears them all with one click.

Make it easier for people to enter data in your worksheet, by showing input and error messages on data validation cells.

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:

Excel Tricks: 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!

Power Pivot: Rob Collie shows a simple, and useful, trick for combating “stale” Slicers in PowerPivot.

Health: 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?

Sparklines: This sparkline tip was in a Tableau article, but could apply to your Excel sparklines too.

Excel Crashes: Ryan Kelly had a problem with Excel crashing when he used VBA on his MacBook, and explains how he fixed it.

Excel Help: 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.

_____________________

Periodic Table of Excel Keyboard Shortcuts
Periodic Table of Excel Keyboard Shortcuts

Leave a Reply

Your email address will not be published.

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