There's a common idea, even among some introverts, that introversion is the misanthrope's gene, cured only through spiteful solitary confinement.Funny, then , how it seems like the internet has placed …
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 →
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 …
LinkedIn: Good for Business, Good AT Business
As the social media platform for professionals, LinkedIn is great for business. I landed my first job out of school on LinkedIn and built my best professional relationships.But what I've more recently …
Continue Reading about LinkedIn: Good for Business, Good AT Business →
Excel Keyboard Shortcut: Autofit Column Width
Formatting a spreadsheet can be quite time-consuming. But like with many Excel tasks, knowing some keyboard shortcuts can really help.Alt + O,C,A will autofit the width of your selected column. …
Continue Reading about Excel Keyboard Shortcut: Autofit Column Width →
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 …