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) →
Five reasons I wrote Advancing into Analytics
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 →
Learning guide: Introduction to Power Pivot in Excel, one-day workshop
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 →
Preview: satRday Columbus
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 …
Demo guide: the margin of error, visualized in Excel
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 →
R-Powered Excel (satRday Columbus online conference)
This event has concluded. Thank you to the organizers, attendees and fellow speakers for making it a fantastic inaugural online event. You can find the video and a link to the session repository …
Continue Reading about R-Powered Excel (satRday Columbus online conference) →