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 →
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 →
Exc-elf?
Harry Potter fan? Think of Excel as your data's house elf. An Exc-elf, as I say.Tonight I am reading Guerilla Data Analysis Using Microsoft Excel. Excellent book: you can tell the authors have been …
Add Hyperlink in Excel
Ctrl + K allows you to insert a hyperlink in Excel. Be sure to use this when linking to the site! …
PROPER will convert your text
This happens a lot. You export data into Excel and everything is in caps. It's difficult to read and won't go over well when you present. The PROPER function will convert your text into normal …