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 …
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 …
What’s Your F1 Key?
I've been reading MrExcel XL: The 40 Greatest Excel Tips of All Time and found this curious anecdote: the best spreadsheet modellers often remove the F1 Key from the keyboard.This allows them to …
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 →