how-to

Merge Worksheets in Excel

It’s no secret that I love Excel. I’ve said it before, I’ll say it now and I’m sure I’ll hum this tune again next week. Today I’m tackling a common problem that’s plagued office heroes for years. How do you merge multiple Excel worksheets into one master worksheet, automatically, and without macros or VBA? Down the line …

Merge Worksheets in ExcelRead More »

Want Hotel Status and Upgrades? Just Ask.

OK first of all, the Starwood Preferred Guest (SPG) program is amazing. In fact I’m comfortable declaring that it’s my hands-down favorite and the best loyalty rewards program I’ve ever used to date. The reasons are many, but I’ll save extolling these virtues for a later post. Before I go on gushing and retell how …

Want Hotel Status and Upgrades? Just Ask.Read More »

Downtown Toronto in the Distance

Save at Airports: Bring Your Empty Water Bottle

If you find yourself trudging through airports every week, as I often do, I don’t doubt you’ve noticed that bottled water doesn’t sell for less than $3. Quite often even that is cheap. Nearly ever week since January I’ve wandered through terminals searching for bottled water, and nearly every week I shout (in my head) …

Save at Airports: Bring Your Empty Water BottleRead More »

Dynamic Data Validation with Excel 2010 & 2013

It’s Christmas, and like many of you I find myself thinking about dynamic data validation using the structured tables that Microsoft introduced in Excel 2010. Welcome to my life. What’s Data Validation? When I say data validation I mean the ability to specify exactly what kind of data users may (or may not) enter into …

Dynamic Data Validation with Excel 2010 & 2013Read More »

Mount ISO Images in Windows 8

Well, it took a long ass time but Windows users can finally do what Linux and Mac nerds have been able to do… for about as long as I can remember: mount ISO images without third-party tools. That’s right. Mounting ISO images in Windows 8 is as simple as right-clicking the ISO image file, then clicking Mount. …

Mount ISO Images in Windows 8Read More »

How to Restart, Shut Down & Sleep in Windows 8

Microsoft’s been pretty busy lately, releasing a substantially redesigned Windows 8 just last week and putting the final touches on Office 2013 to be released in Q1 2013. I just installed Windows 8 a few hours ago, so this first post will address something which has already given many people heartburn: how the hell do we …

How to Restart, Shut Down & Sleep in Windows 8Read More »

Ditch the Mouse: Quickly Select Excel Ranges With Your Keyboard

I’m going to write a lot about ditching the mouse in favor of keyboard shortcuts, so consider this one of many to come. And while we’re at it, get used to me spamming this next sentence throughout my shortcut posts: Using keyboard commands over hunting and clicking with the mouse will save you time. Period. Next time you …

Ditch the Mouse: Quickly Select Excel Ranges With Your KeyboardRead More »