A Cheat Sheet to get more out of Microsoft Excel
Ever wanted just the Cliff Notes version of Excel? We've got you covered with the Excel Power Users Quick Guide - and it's free.
What to do when you are offered ghost peppers or Trinidad scorpion peppers? Which one would you choose? Oz is here to help us out.
The chart on the right displays the Scoville Heat Units (SHU) of different peppers. Poblano isn’t even that hot. And Trinidad scorpion peppers doesn’t even score twice as hot. I guess, we can handle it after all.
But, wait a minute! Is there some trickery at work here?
When we add vertical axis to our chart, the entire result changes. Turns out that the creator of this chart had enabled logarithmic scale using Axis Options. Of course, he then deleted the scale to hide any trace of the change!
You can also see here the data that was used to create this chart. It is pretty apparent ghost peppers and Trinidad scorpion peppers are something we all should generally stay away from.
Always remember to take a look at the data! There are no two ways about it. Getting yourself in the habit of observing the data before believing any charts or analytics will prove to be immensely valuable to any aspiring data analyst. It has certainly helped me!
A big part of our jobs is to be aware of possible pitfalls in data analysis. So do not forget to share this video as widely as you can. And write your thoughts to us in the comments section below.
And while you are at it… Check out all the great Excel videos on Oz’s Youtube channel. He’s on Fire.
Excel Data Visualization: Presidential Approval Ratings with Slicers & Power Query – Chart Tricks
Advanced Excel Tutorial – VLOOKUP() Speed in Excel | Excel TV, Episode 54
Excel Tutorial Concat Function in Excel with TEXTJOIN – Excel.TV Episode: 53
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Get the FREE Excel Power User Guide