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 >>

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 >>

How to Remove Duplicate Values in Excel

Five Ways to Find and Remove Duplicate Values in Excel For people who work with large data sets in Excel, or databases for that matter, one of the most common error checking tasks is the removal of duplicates values.  Some people refer to this process as de-duping.  The main reason this is necessary in data sets ... Continue Reading >>

How to Use INDEX MATCH MATCH

If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>