How to Use the VLOOKUP HLOOKUP Combination Formula

VLOOKUP and HLOOKUP are two of the most popular formulas in Excel and using them together is one of the first formula combinations that people learn.  While using INDEX MATCH for vertical lookups and INDEX MATCH MATCH for matrix style lookups are superior approaches, it's still a good idea to learn this formula combination and ... Continue Reading >>

The Eight Things You Should Always Check Whenever You Receive an Excel File

Photo by adamr Taking over another person's Excel file always has the potential to become a difficult task.  While some people actually create documentation, consider a new user's point of view, and take the time to call out the mousetraps that you might encounter, most of the time, you'll be getting a straight file dump.  Therefore, Continue Reading >>

How to Streamline the Excel Error Checking Process: Excel’s Inspect Workbook Feature

Checking for errors in your Excel files is always a pain.  It's generally a very manual process that takes a lot of time, with a certain level of ambiguity regarding your return on investment - you could spend hours checking for issues in your Excel file, find nothing wrong, and your only tangible benefit is ... Continue Reading >>

The Eight Most Impactful Excel Shortcuts That You Should Master

If you've ever gone online to research improving your Excel skills, you've undoubtedly come across a post or two listing all of Excel's keyboard shortcuts.  In the latest version of Excel, Microsoft has made it easier than ever to learn shortcuts, by assigning shortcuts to nearly every function and making the discovery of the input Continue Reading >>

Top Mistakes Made When Using INDEX MATCH

INDEX MATCH Not Working?  The following article provides the most likely causes of your problems with using INDEX MATCH. If you're an advanced user of Excel, you've likely already made the switch from VLOOKUP to INDEX MATCH because of the several advantages that INDEX MATCH provides.  Within Excel, INDEX MATCH is one of the most Continue Reading >>

My 2015 Goals

For all intents and purposes, 2014 was a good year, starting with my beloved team the Seattle Seahawks winning the Super Bowl and capping off with the same team clinching the number one seed in the playoffs for the NFC conference.  The end of my Seattle sports team woes alone is enough for me to ... Continue Reading >>

How to Download Excel for Just $10 Dollars

If you want to have Excel for your home computer but don’t want to spend a lot of money, the answer to your problem is Microsoft’s Home Use Program (HUP).  While you can obviously buy the software on your own, the HUP allows you to purchase the entire Office suite for just $10 dollars. Program Background Microsoft’s ... Continue Reading >>

Excel Random Student Name Generator

While cold calling is practice that most students dread, from a teacher’s perspective, it’s an effective way to encourage students to prepare for and participate in class. We’ve all been on the wrong side of this situation at least once in our lives, coming to class completely unprepared.  And the natural thing to do when unprepared Continue Reading >>

How to Write an Excel Criteria Statement That Links to a Specific Cell

I generally give Excel a lot of credit for being an intuitive and easy to learn tool.  However, writing criteria statements that link to cells is probably one of the most un-intuitive aspects of formula writing in Excel.  This is a very common mistake that occurs and therefore, should always be error-checked whenever you are ... Continue Reading >>

The Economist’s Which MBA? Online Fair – November 20th, 21st and 23rd:

Meet MBA admissions officers from programs around the world at this free online fair. Chat with alumni, join webinars, watch videos and download resources. Sign up or learn more at http://economist.com/whichmba/mba-fair/?fsrc=randomwok ** Sign up now for your chance to win a free iPad when you visit 5 or more school booths Continue Reading >>