I call PivotTables the “WD-40 of Excel” because they allow you to loosen up and extract meaning and trends out of your data.Introductory SlideShare:Here are a few of my top posts …
Did that just work? Case formatting in Excel
I recently came across this quote from Isaac Asimov -- it is so true:I absolutely love this quote. Breakthroughs hardly happen when you expect them. This requires a level of humility and even …
Continue Reading about Did that just work? Case formatting in Excel →
Converting a CMS Table to Excel to analyze HCPCS codes
In this video I show how to take a PDF from CMS (Centers for Medicare & Medicaid Services), convert it to Excel, and transform it into a Pivot Table-friendly table with just a few keystrokes.Check …
Continue Reading about Converting a CMS Table to Excel to analyze HCPCS codes →
Data and the Liberal Arts Edge: Discussion with Matt Walje
An increasing number of jobs in industries as diverse as healthcare operations and maritime piracy analysis require quantitative aptitude.The response to prepare for this demand is often an emphasis …
Continue Reading about Data and the Liberal Arts Edge: Discussion with Matt Walje →
Bonini’s Boredom
Today I came across a fascinating concept called Bonini's Paradox -- the more complexities you add to a model to make it "realistic," the less useful it becomes.Take a map of your town, for example. …
Shiny Data Syndrome
I've been reading Guy Kawasaki's The Art of the Start 2.0.It's a great read not just for start-up entrepreneurs but, as the title says, for "anyone starting anything."This quote in particular got my …