Teaching analytics with modern Excel
I live by a little rule called Mount's Law of Content Marketing: If I'm asked about the same thing three times, and I could my answer into a blog post, then I should. In that spirit, this post …
Continue Reading about Advancing into Analytics: FAQ’s about the book →
I'm launching a book at a weird time. Toward the (one can only hope) end of a pandemic, book sales are booming, but it's so hard to …
Continue Reading about Five ways to support Advancing into Analytics (besides buying it) →
The thing that struck me about writing a book is just how much it is like starting a business: you can do your research and assemble a meticulous plan, but you can't quite know what the result will …
Continue Reading about Five reasons I wrote Advancing into Analytics →
Ah, the "Franken-Table." You've probably created one: a worksheet with umpteen VLOOKUP()'s referencing various other worksheets and perhaps (gasp!) even other workbooks. It's ugly and inefficient: …
Continue Reading about Learning guide: Introduction to Power Pivot in Excel, one-day workshop →
Online conferences are getting to be a tough sell: the supply has exceeded the demand. It's just so hard to make (and keep) the time for a conference when you're sitting at …
You've likely heard on the news that a certain poll has a "margin of error of +/- 3%." What does that mean, really? What is a margin of …
Continue Reading about Demo guide: the margin of error, visualized in Excel →
