Excel Roundup 20140317
Happy St. Patrick’s Day! Four years ago, we celebrated by creating Ireland’s flag in Excel. The flag is a simple column chart, with the 3 columns coloured to match the flag’s design. It’s an easy project, so you’ll be done in time to go out to celebrate.
The blog post also has a video of some festive Canadian Irish music, featuring Great Big Sea, playing with The Chieftains. I’ve linked to it again this year, at the end of this post. The music will get your toes tapping, while you work on Excel projects today.
Here’s what I posted last week:
- After applying an AutoFilter, use this trick to show the top 10 values in the visible rows.
- If the items in a pivot table Report Filter drop down are out of order, here’s how to sort them.
- Roger Govier shared his technique for creating multiple dependent drop downs, based on Excel tables.
- 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:
- You can pick a business book to read, based on your favourite book as a child. The Excel Bible isn’t listed, but what children’s book would be a a good match for that?
- Did you read any of the articles that explained how Steve Ballmer, Microsoft’s former CEO, used Excel to balance his work and family time? He said “a spreadsheet”, but I’m sure he meant Excel. Or could he still be using MultiPlan?
- The FrankensTeam did a guest post on Jon Peltier’s blog, showing their approach to plotting gaps in Excel charts.
- Chandoo shows us the 6 best charts to use, when you want to show your progress against a goal. There’s a sample file to download, so you can experiment on your own.
- Jon Acampora recommends the best keyboards if you like to use Excel’s keyboard shortcuts. My laptop looks like most of the “bad” pictures in the article.
- Ross Hall explains what you should do if you inherit a spreadsheet that nobody really understands.
Here are some upcoming events, courses and new books, related to Excel.
- Registration is open for the Amsterdam Excel Summit. The one-day event runs on May 14, 2014, and features sessions by several Excel MVPs, such as Bill Jelen (Mr. Excel), Ken Puls and Charles Williams. All the sessions are in English, and the limit is 100 participants, so sign up now, if you’re interested.
What Did You Read?
If you read (or wrote) any other interesting Excel articles recently, that you’d like to share, please add a comment below, or send me an email.
Please include a brief description, and a link to the article.
Toe Tapping Music
Here’s the video, to put you in the St. Patrick’s Day mood – Lukey, by Great Big Sea, with The Chieftains.
Or watch on YouTube: Lukey, by Great Big Sea