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 vba range rowexcel lookup exampleexcel indirect referenceexcel index match formula exampleexcel macro open excel filecreate a vlookup formulams excel hlookupapplication.vlookuphomework assignment sheet templateackerman uclaworking at zs associatesexcel simulation examplesexcel formulas greater thanisna excel 2010excel macro lookuphow to apply countif formula in excelwriting vlookup formulas in excelexcel ctrl hwingdings boxhow to find duplicate records in a tablehow to count formula in excellookup in vbaexcel deduplicationexcel vba range functionpseudonym generatorexcel stdev ifexcel functions vlookupharvard business school case studies solutionszs consulting salaryexcel macro builderexcel concatenate formathow to delete repeated cells in excelexcel histogram tutorialcalendar chart excellabel chart excelexcel 2010 match functioncountif on excelms excel syntaxisna meaningexcel vloopupnormal distribution curve excelwingding checkmarkexcel random data generatorremove duplicates rows in excelbell curve in excelllookup function excel 2010checkmarks in excelthe goal movie goldrattvlookup hlookup combinationexcel combine tablesdistribution curve in excelhow to create stacked bar chart in excel 2010accounts payable uclastacked bar chart excel 2010auto format excel 2010hlookup formula with exampleucla portal loginpowerquery for exceloffset function excelnormal curve graph generatorbrackets in excelrandom number generator in excelindex and match multiple criteriause of in excel cell referenceexcel ranges in formulashlookup exceladobe converter pdf to excelnested if functions in excel 2010graph chart excelexcel match vbausing countif function in exceluseful excel shortcutsbps percentagededupe in excelnested if condition in excelmatch function excelnested if statement in excel 2010the default format that excel applies to numbers is theexcel vba histogramvlookup function with exampleremove gridlines excela cell as it applies to excel 2010