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

excel lookup examplesif statements excel 2010how to forecast revenue in excelhistogram excellexcel 2010 transpose functionexcel row headingstask planner template excelbell curve generatorvlookup rowcreate vlookup excel 2010histogram createrdelete duplicate names in excelalexa ranking websitehow to do vlook upzs associates internshipexcel hlookup and vlookupgraph chart excelfrequency histogram makerexcel delete duplicate valuescompare two columns in excel sheetsymbol for tick in wordexcel decision tree templatedefinition of row in excelhow to check duplicates in excel 2007find unique values in excel 2010duplicate numbers in excelp&l format in excelnested if condition in excelexamples of checklists in excelexcel 2010 custom number formatcreate macros in excelformula of hlookuppowerpoint checkmarkexcel count occurrencesmba refresher courseucla fembadeleting pivot tablelist of random numbers in excelexcel spreadsheet tricksline chart in excel 2010if isna matchhow to create financial models in exceliferror function excel 2010excel 2007 vlookup tutorialwhat is a stacked column chartcell reference range excelcreating a histogram on excelside by side bar graph excelcell reference range excelsymbol excel formulabruinbus uclaucla course listingsfrequency histogram makersample excel formulas and functionsvlookup dan hlookupvlookup based on two valuesfind duplicates in an excel columnhow to calculate sg&avba create graphexcel formulas with examplesexcel delete duplicate valueshow to do cumulative sum in excelnested if and functionsprimo pdf portablehow do i insert a tick in word 2010query pivothow to build formulas in excelcustom number format in excelrandom number generator vbanested excelexcel templates databaseexcel string comparisonduplicates in excelhow to insert a tick in excelhow do you do vlookup in excelexamples of if statements in excelwhat is a stacked bar chartexcel sort arrayascending in excel