Error Checking

Auditing an Excel file with a ton of tabs is one of the least enjoyable experiences in Excel.  When I worked in consulting, it wasn't uncommon for me to receive a file from a client containing 50 more spreadsheet tabs.  And as an analyst, I had the unfortunate task of having to review all of ... Continue Reading >>
The IFERROR formula was designed to solve a common aesthetic problem that most of us have encountered when using Excel - when we know that there are errors in our data, but we'd prefer not to see Excel's standard error message notation.  Error messages usually consist of all caps lettering that is preceded with the "#" ... Continue Reading >>
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 >>
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 >>
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 >>
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 >>

Related pages

how to combine 2 columns in excel 2010match cells in excelrandom name selector downloaddecimal placementsquotation marks in excelthe goal movie goldratt free downloadexcel auto multiplywhy we use hlookup in excelz distribution excelhow to add a horizontal line in excel chartcorrect mark symbolvlookup with vbafancy excel templatesexcel insert shortcutvba vlookup examplehow to do an hlookuphow to use transpose in excel 2007excell histogramnormal curve in excelvba code for vlookup function in exceldinot bold fontteacher tools random name generatorwhy we use hlookup in excelhow to make hlookup in excelboundaries circle chartmba in uclaabout excel formulas with exampledraw a normal distribution curve in excelbell shaped curve excelcreating random numbers in excelhbr case solutionsbc reverse lookupexcel 2010 match functionexcel indexingexcel useful shortcutshow to set up formulas in excelhow to divide by 1000 in excelhow to do bell curve in excelcompare three columns in excelrange lookup in excelvlookup formula examplecountif formulasexcel duplicate cellexcel sort arrayhistogram templatecount command in excelexcel stacked line charthow to create vlookup in excel 2007inventory formula exceltick mark symbolsformula for excel spreadsheetsvlookup range lookuphow to open filter in excel using keyboardgoldratt the goalname draw randomizerexcel hlookup functionformula for excel sheetexcel double lookupisna meaningvlookup function excelwhat is the tick symbol in wordhow to remove duplicates in excelif statement examples in excelhow to put a histogram in excellabeling graphs in excelhow to convert numeric value in words in excel 2010excel hlookup formulaexcel macro enableducla book store hourssumproduct vlookupmicrosoft excel vlookup formulagenerate lotto numbers in excelthe goal eliyahu goldratt summaryhow to draw standard deviation graph in excelhow do i compare 2 columns in exceluses of formulas in excelerror bar excel 2010goldratt goal