Teaching analytics with modern Excel
I love PivotTables because they do all the "data housework" for me, allowing me to analyze data rather than gather, manage, and format it.One undesirable feature of the PivotTable is how it treats …
Continue Reading about PivotTables: Replace Blanks with Zeros →
Conditional formatting is great for making quick sense of your data visually. It's a good idea to check for duplicates when receiving a dataset like this one. The next step of course is to figure out …
Think copywriting, and you likely picture shots of glamorous models with pithy slogans.I think of a different model: the business model. Cold, exacting, and anything but glamorous!In Dominic …
Continue Reading about Copywriting and the Other Kind of Model →
When teaching in Poland one summer, my coworker received a t-shirt from a student which read:School is not like the pub... You do not have to go to school every day.I've got a lot of mileage from this …
Working with other peoples' spreadsheets can be harrowing.When working with new data, a good analyst will ask: "Where is this data coming from?" You want to go ad fontes, as they say in philosophy -- …
Escape Hell...Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook! …
