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

histogram binvlookup won t workucla class scheduledividing numbers in excelexcel erase duplicatesvlookup different worksheetcool excel charts and graphsvlookup tutorial videoif cell is not blank excelcool excel graphshow to show total on stacked bar chartestimate federal taxes owedshuffle names in excelusing brackets in excelpeltier techxml error checkeruse of vlookup in excel 2010online bell curve calculatoradvanced excel array formulasexcel delete duplicate lineswriting macro in exceltick icon in wordestimating excel templateeliminate duplicateswhat is the formula of vlookup in excelstacked column chart in excelwhat is the meaning of vlookupvlookup in exeltop 20 most visited websitesestimate federal taxes owedvba if statement multiple conditionslookup excel 20072 stacked bar charts side by sidevlookup conditional formattinghistogram bin rangeexcel frequency histogramexcel layout templatesexcel null checkv lookup for dummieslenovo laptops for studentsexcel sort buttonvba lookupnormal probability plot excel 2010irs allowance calculatoradobe acrobat download cneteli goldratt bookshow to do cumulative sum in excelpopular excel macroshow to use true or false formula in exceloffset function in excel for dynamic rangesmultiple if then statements in excel 2010vlookup explanationhomework schedule makerhot to use vlookupbin limits excelscientific notation in excelexcel stacked columnhow to make a horizontal bar graphdraw histogram in excelcalendar in excel templateif clause in excelvba formatnumberisna excel functionexcel formula list with examples 2007if clause exceloffset function excelvlookup in excel exampleshow to use excel vlookup functionexcel duplicate valuesexcel searchable databasems excel functions with examplesvlookup excel worksheetshortcut excel keysvlookup columnexcel vlookup 2 columnsscenario builder excelshort cut key for filter in excelpaste special dividemicrosoft excel cheapmicrosoft office free trial 60 daysexcel color schemeexcel chart bell curveexcel countif rangefind duplicates excel 2007excel lookup table exampleexcel multiple if and statementsvlookup refexcel iserror formulaformula in excel sheetvlookup 2010 for dummies