Excel Roundup 20160201
In this week’s roundup, formula challenge, better charts, fixing numbers, and much more.
1. Fix Excel Numbers That Don’t Add Up
If you’ve imported data from the web, and things don’t look right, see how to fix Excel numbers that don’t add up, This technique uses the Paste Special – Add feature, and I made a short video to show the steps.
You’re probably familiar with Shark Week, but last was Excel Dinosaur Week. While Chandoo was busy assembling dinosaurs from a set of parts, Jon Peltier was calculating how long it would take for a dinosaur to catch a human.
I built this chart from Jon’s instructions, and added his VBA code to animate it. For extra excitement, I added a text box with a caption that changes (it’s linked to a cell) when the dinosaur gets the human. Run, human, run! (I’m easily entertained.)
And if you love charts, take a look at Jon’s time-saving Charting Utilities.
3. Excel Stopwatch
If you need to keep track of time, Sumit Bansal shows how to build a stopwatch in Excel. There is a basic version of the stopwatch, and a fancier one for ToastMasters.
4. Better Charts
You don’t need a dinosaur chase in every chart. Ann K. Emery explains how to simplify your charts, and emphasize the key information, by using text and colour.
There’s another good chart makeover on the Storytelling With Data blog, where Cole Nussbaumer Knaflic transforms a pie chart into a clear report. There is an Excel file that you can download.
5. Scrabble Challenge
If you enjoy a game of Scrabble, almost as much as you love working in Excel, try the shortest formula challenge on the ExcelXOR blog. Download the sample file, and use a formula to find the word that gives you the highest score. That should get your brain going for the start of this week/month!
6. Excel Humour
Finally, for a bit of spreadsheet humour, you can see what people are saying about Excel, in my weekly collection of tweets. Here’s one of my favourite tweets from this week’s collection.
Get Weekly Excel News By Email
To get Excel news and tips by email, add your name for the Contextures Excel newsletter.