We've all had that nasty feeling -- our vlookup formula returns an error, leaving a screaming #N/A where you had expected to see numbers. This is usually because of some loophole in your dataset -- …
Use this Excel Print Formatting Every Time
Even in the digital age, much of what is created on the computer gets printed. You can make a great spreadsheet, but if it doesn't look good in print, it loses credibility. Here is the formatting I …
Continue Reading about Use this Excel Print Formatting Every Time →
Filter Multiple Pivot Tables with One Slicer
Note: This is my first Excel post! I have improved since then, both in my blogging and Excel skills. I've made some modifications to the post, but the first paragraph remains for sentiment's …
Continue Reading about Filter Multiple Pivot Tables with One Slicer →
History, Statistics, and more interesting facts
Very informative piece here about the future of statistics in an age of data analytics. I had never considered the point that statistics and probability were disparate subjects until a couple of …
Continue Reading about History, Statistics, and more interesting facts →
Happy Spreadsheet Day!
With Apple, Uber, and other tech-savvy companies making big product announcements this time of year, you may have overlooked an anniversary. This week marks the 35th anniversary of the spreadsheet.I …
In (partial) defense of Millennials
George Anders at Forbes has a brief but unbalanced piece on Millennials' spending habits. The article shows why data-driven stories, just like any other stories, need to be put into context.Anders …
Continue Reading about In (partial) defense of Millennials →