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 »

Flash Fill Create Names from Email Addresses

Excel 2013 Flash Fill

I’ve been playing around with the Excel 2013 preview, and damn. It’s nice. Excel newbs and ninjas alike will find Flash Fill – one feature new to Excel 2013 – intuitive, powerful and super convenient. Flash Fill takes the grunt work out of list-making and data manipulation, relying on clever algorithms to recognize patterns and …

Excel 2013 Flash FillRead More »

Compare Two or More Lists in Excel with Conditional Formatting

I’ve recently posted two easy ways to compare two lists in Excel. One uses ISNA and MATCH and one IF and COUNTIF. I like both of these methods because they allow you to: Learn how to use and modify four powerful Excel functions Quickly apply AutoFilter to view just the missing values Easily manage and compare massive …

Compare Two or More Lists in Excel with Conditional FormattingRead More »

Compare Two or More Lists in Excel with IF and COUNTIF

As I previously discussed, Excel provides many useful ways to automatically compare two lists of data or information. In our other example we compared two lists of four digit account values; for this example we’ll compare two lists of names. You and a friend are throwing an epic party and have each maintained separate guest …

Compare Two or More Lists in Excel with IF and COUNTIFRead More »