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 plot distribution curveexcel vba random numbergenerate random password exceltax return excel templatehow to make hlookup in excelexcel formula iserrorexcel symbol for does not equalexcel autocalculatehow to write vlookup formula in excelname picker for teacherscool graph designsexcel formula vlookuplibrary ucla hoursjob estimate template excelexcel vlookup multiple conditionstask assignment template excelvlookup arraydeloitte mba salaryhow to make a random number generator in excelexcel chart horizontal axislookup and vlookupthe goal eliyahusimple vlookup in excel 2010the vlookup functionhorizontal lookup excelvlookup won t workfuzzy search excelpowerpoint check mark symbolmicrosoft hup how many computersinverse normal distribution excelvlookup microsofthow to convert an excel document to pdfnested if and statements excelmicrosoft excel vlookup examplesvlookup 3 columnsnumbering in excelhow to construct a formula in excelvlookups excelmicrosoft excel column headingsifs formulaformat of excelhow to convert excel to pdf filestack graph in excelmicrosoft tick symbolexcel standard deviation chartucla salary scaletrue false formula in excelcreating a histogram on excelvba lookup tablelottery name generatorvlookup formula with if conditionexcel data analysis histogram bin rangevlookup xlsexcel indicesexcel numberformatexcel stack columnssyntax in excel definitionlookup value in excelremove duplicate entries excelwww myuclamost common formulas in excelformatting numbers in excelexcel duplicate formulaucla anderson mba admissionsdelete duplicate entries in excelhlookup and vlookup in excelfree trial of microsoft powerpoint 2010if isna matchmicrosoft excel power queryhow to find random numbers in excelusing vlookup to compare two listsexcel 2007 stacked bar chartirs underpayment penaltyturn off scientific notation in exceloffset match excel