Escape Hell…Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook!
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 time-suck. Lots of mouse clicks gone astray, clashing colors, etc. That’s why I present nearly all my data inside a PivotTable — […]
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 transform your raw data into the commission figures with the below steps. Subscribe to the newsletter for more Excel tips […]
Ctrl + K allows you to insert a hyperlink in Excel. Be sure to use this when linking to the site!
You’ve heard about “big data,” “data analytics,” and related fields (buzzwords?). Maybe you’ve thought about how to make a career out of it. One obstacle — you’ve spent college reading Chaucer, not running regressions. You may think the only route now is a fancy graduate degree right out of school or a lengthy, unpaid internship. This […]