Last night we revisited a family classic, RocketMan.It's a slapsticky 1997 Disney film about an idiot-savant space engineer who unexpectedly is sent on the first mission to Mars. Crude humor …
You’ll Shoot Your Eye Out! Cutting Back on Excel’s White Glare
http://pastebin.com/cvch6hWPDownload the exercise file here.I'm getting old.My eyes feel strained all the time.No kidding? Maybe it's from staring at a white screen all day:In this video I will offer …
Continue Reading about You’ll Shoot Your Eye Out! Cutting Back on Excel’s White Glare →
You don’t really know a coworker until…
"You don't really know a person until you have shared a pound of salt with him." -Russian proverb"You don't really know a coworker until you have shared a spreadsheet with him." - georgejmount.com …
Continue Reading about You don’t really know a coworker until… →
Generate Unique, Non-Repeating List of Numbers in Excel with RAND and RANK
Download the exercise file here.Let's say you need to come up with a seating chart. Using RANDBETWEEN, you may get duplicate entries for the same number, or missing numbers.Using RAND in conjunction …
Continue Reading about Generate Unique, Non-Repeating List of Numbers in Excel with RAND and RANK →
*.* is an Anatomy of Your Files
I am working on a project that requires data that comes to me in an unusual format from the Bloomberg terminal. Each year's set of data comes in its own subfolder. I want to move all this data out …
Excel Tip: Freeze Chart Size from Cell Adjustments
As I mentioned in my MyExcelOnline podcast appearance, charting is one of the hardest Excel tools to master. My tip in the podcast showed how to add data with two keystrokes.Sizing your graph can also …
Continue Reading about Excel Tip: Freeze Chart Size from Cell Adjustments →