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 …
Copywriting and the Other Kind of Model
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 →
School is Not Like the Pub…
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 …
Dude, Where’s my Pivot Table Data?
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 -- …
Hell…
Escape Hell...Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook! …
Time for an Excel Timestamping Shortcut
Time for another Excel shortcut, of course! This is related to Ctrl + ; which will give you today's date (demonstration on my Instagram -- be sure to follow @gjmount!)Ctrl+Shift+; will give you …
Continue Reading about Time for an Excel Timestamping Shortcut →