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 →
Marketing: A Confused Economist’s Take
Somehow I through undergraduate and grad school without taking a marketing class. But in between my blog (did I mention to subscribe?) and a couple of ebooks, I've been interested in the topic. I've …
Continue Reading about Marketing: A Confused Economist’s Take →
Get In Line!
A good Excel analyst thinks about formats. Do these borders, colors and blocks help drive the overall narrative of your data? Or do they just make it look busy?Formatting can be a significant …
Multiply a Whole Range by the Same Cell
Here's a feature that takes advantage of the powerful "Paste Special" features in Excel. Say you've got a list of sales by employee and week. The sales reps get a 10% commission. You can easily …
Continue Reading about Multiply a Whole Range by the Same Cell →