If you work in consulting or some other profession that requires you to analyze data, sooner or later, you'll need to build a histogram.  This is because the histograms is one of the most effective methods to visualize and understand a data set.  Averages, sums, and counts are calculations that only tell you part of ... 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 >>
Excel's MATCH formula is an extremely useful yet underutilized function within Excel's toolkit of formulas.  The reason people underestimate its value is because the MATCH formula's primary objective is fuzzy and ambiguous.  Without the proper context, its usefulness and potential applications are not obvious. The MATCH Continue Reading >>
One of the most annoying things to have to do in Excel is writing a Nested IF statement.  For those of you that haven't done this before, a Nested IF is basically a long formula with multiple IF conditions that you need to account for.  The most common usage of this formula is to assign ... Continue Reading >>

Related pages

excel macro tipsexcel remove duplicate entrieseliminate duplicates in excel 20103d stacked bar charthow to find out duplicate records in exceldivide using excelcalendar planner excelexcel csehow to put error bars in excel 2007random numbers excelhow to perform a goal seek analysis in excel 2013powerpoint 2010 free trialexcel display arrayexcel filter unique valuesnormal curve in excelnormal distribution excel templateexcel count occurrencespercentage bar graph exceladvanced excel tips and tricksmaking graph excelwhat is vlookup in ms excelexcel if function multiple criteriaextract duplicates in excelshortcut for in excelxl lookupvba vlookupexcel count duplicates in columnnormal distribution curve creatorexcel 2013 match functionmaking histogramsvlookup formula excelhow to find duplicate values in excel 2010sorting formula in excelvlookup in ms excelmicrosoft office suite free trialcount if examplesimple if statement in excelhow to find and delete duplicates in excelhotkey excelpdf file convert to excel sheetsort formula excelfind duplicates in excel 2010vlookup practice problemsifs formula excelexcel chart horizontal axisexcel linking cellswhat is the lookup function in excelexcel index array formulainsert a check mark in wordaverage gpa at uclahow to create vlookup formulacomparing columns in excelvlookup not working excel 2010vlookup true falsehow to create an histogram in exceltypes of excel spreadsheetsexcel vlookup and hlookupexample of countifshortcut key of filter in excelexcel lookup vectorexcel if function multiple criteriaexcel vlookups and pivot tablesselect rows with duplicate valueshow do you remove duplicate rows in excelucla anderson schedulemy housing uclashortcuts of excelcustom number format in excelwrite formula in excelexcel vba matchexcel distribution plotiferror in excelreference table in excelmaking a line graph in excelexcel formula toexcel shortcut delete rowvlookup function excel 2010