Escape Hell…Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook!
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 the current time. These two shortcuts are helpful when you are getting a last-minute report out and want a quick […]
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 […]
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 in the foxhole of real-life data analysis and know how to survive! This comic aside on having hobbies vs. using […]
Ctrl + K allows you to insert a hyperlink in Excel. Be sure to use this when linking to the site!