Ever been in such flow with your spreadsheet that you forgot what day it is? Here's a nice keyboard shortcut. Ctrl + ; will insert today's date. …
More Filtering Fun
Yesterday I quoted a tip on filters from "Learn Excel from Mr. Excel," a great read. Filters are a powerful Excel feature. They allow you to hone in on your data. The only problem is they're a little …
Filter on just part of a tab in Excel
Usually when you apply a filter to your Excel workbook it applies to the whole data tab. Sometimes you don't want this. Here is a great workaround from "Learn Excel 2007 through Excel 2010 From …
Continue Reading about Filter on just part of a tab in Excel →
Copy that Worksheet Faster
A regular task in Excel that's quite time-consuming is copying a worksheet. My old method involved right-clicking, visiting a menu, etc. -- too many steps.Here's a quicker way:h/t Mr. Excel XL: The 40 …
Keyboard Shortcut: Rename Worksheet in Excel
Here's a nice keyboard shortcut I recently picked up. …
Continue Reading about Keyboard Shortcut: Rename Worksheet in Excel →
The “Hired with Excel” Resource Page
Data-savvy analysts are in demand. Want to get started? Learn Excel. This series of posts is everything I wish I knew when applying for my first analyst job. Focusing on two commonly used Excel tools, …
Continue Reading about The “Hired with Excel” Resource Page →