In 2012, back when I was in business school, I created a spreadsheet-based task tracker to manage my various commitments.  Because I'm somewhat of a visual design nerd, I leveraged Excel as my platform of choice because of all the detailed conditional formatting options available. It's now been more than 4 years since I created Continue Reading >>
The vast majority of Excel users have never used VLOOKUP's range lookup feature.  Most Excel users familiar with the VLOOKUP formula are just conditioned to know that, when they get to the range lookup option portion of the VLOOKUP syntax, they should just put in the word "FALSE" because they want an exact match.  This ... Continue Reading >>
Writing a Nested IF Statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced.  The first time I used this technique was during my new employee training, right before I became a business analyst in management consulting.  The overall concept of writing a Nested IF is ... 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 >>
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 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 >>
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 >>
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 vlookup range lookupisnumber searchtick correct symbolusing multiple if statements in excelvlookup vlookuphow to delete header in exceloffset and match function in excelxl lookupformatting charts in excelexample of lookup function in excelexcel macro nested ifexcel chart data labelsrandom name picker for contesthow do you do a histogram in excelsyntax excel definitionhow to extend a trendline in excelhow to remove a formula in excelusing vlookup function in excelcheck duplicates in excelbin in excel histogramtask tracking excel templateucla bruinbillsimple vlookup in excel 2010excel chart templatesshortcuts in excelexcel spreadsheet shortcutsmaking a histogram in excel 2010multiple vlookupshow to do bar chart in excelexcel filter shortcuthow to create a bell curve in excel 2010excel functions and formulasrandom sampling formula in exceldelete row based on cell value vbainsert check symbol in excelexcel chart axisadvanced excel tips and tricksexcel vlookup truehow to put not equal to in excel formulaexcel 100 stacked column chartmicrosoft office home and student 2007 trial downloadnested if and statements excelucla statistics coursesucla business cardsexcel duplicate countexcel if statement multiple conditionsexcel vba range functionexcel lookup and reference functionsmyucla comexcel vlookup formulas with examplesis there a way to delete duplicates in excelexcel programming commandscumbersome tabsexcel if statement with two conditionsmicrosoft trial downloadscompare two columns in excel sheetmultiple vlookup formulahistogram normal distribution excelexcel erase duplicatesconditional ranking in excelmultiple vlookup criteriaexcel chart axiswhat is the count formula in excelexcel offset vlookupexcel shortcuts in excelexcel cell contains textexcel stacked chartsucla anderson fembacomma separator excelsegmented bar chartsw4 allowances calculatorwhat is hlookup in excel with examplehow to use vlookup excel 2010www excel sheet formula comexcel formula for blank cell