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

create an excel macrodelete duplicate rows in exceleasy vlookup instructionstick yes symbolcolumn graphs in excelduplicate formula in excelusing brackets in excelhow to delete numbers in excelpowerpoint 2010 free trialvlookup across multiple worksheetstest normality excelhow to build an excel macrohow to make if statements in excelhow to make a column graphhow to show total on stacked bar chartcreate a histogram in excel 2013excel inventory trackerexcel if isna vlookupformula excel sheetrange lookup excelbell curve excel templateexcel lookup cell addresshow to use iferror function in excel 2010formula of vlookupdeduping in excelshortcut in excelhlookup and vlookup in excel 2007 with examplematching two lists in exceltask tracking excel templateexcel vlookup example downloadhow to do countif in excelbuilding macros in excelhow to lock formula in excelhow to find duplicate values in excelcalculate cpk in excelremoving duplicates from excelvba vlookupmicrosoft word 2010 free trial downloadhow to calculate using excel formulaexcel create random numbersvlookup conditional formattingmicrosoft excel vlookup examplevlookup in exelexcel formula if a cell containsvlookup excel tutorialucla turnitincheck tick symbolpowerpoint check mark symbolif na vlookupadobe acrobat convert pdf to excelexcel templates calendarhow do you do a checkmark in excelvlookup excel 2010 step by stephow to change axis labels in excel 2010remove duplicate lines in excelif is errorucla gymhow to filter duplicate values in excelexcel vlookupvlookup across workbooksvlookupfunctionwhat are vlookups in excelvba excel match functionexcel probability distribution functionexcell lookupexcel formulas 2007 with examplesincome tax calculator xlsvlookup examples in excel 2007building excel macroswhat is hlookup in excelvba generate random numberinsert tick in wordcompare two pivot tablesmultiple if formula in excelexcel plot bell curvehow to write if statements in excelexcel random samplingvlookup matching two columns