Geek

How to Use VLOOKUP in Excel

If you’re looking for the pound for pound, biggest bang for your buck, insert-trite-stereotyped-expression-here, Most Valuable Excel Function, a function that, when properly used, will dramatically increase your Excel mojo, impress your bosses, and make you look like an Excel pro, then let’s talk about Excel’s VLOOKUP function. Yes, it’s an old-timer as far as Excel functions …

How to Use VLOOKUP in ExcelRead More »

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 »

Starting My Bilingual Summer

Christine Gilbert, author of the wonderful and inspiring travel lifestyle blog Almost Fearless, recently wrote about her intention to learn a new language this summer, and challenged her readers to join. Well, join and compete with her, using Duolingo, a free online language learning site promising no ads or hidden fees now and forever. That’s right, free, forever. I’ve been …

Starting My Bilingual SummerRead More »

Grado iGi In-Ear Headphones Review

Santa was good to me this year. I’ll use the next few posts to talk about some of the shiny toys I’ve been playing with, but today I’d like to focus on my new headphones: Grado Labs iGi In-Ear Headphones. Grado Labs is a family owned company based out of Brooklyn, NY, probably best known for …

Grado iGi In-Ear Headphones ReviewRead 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 »