Distribution Analysis

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 >>
Whether you're building a model or trying to simulate a scenario within your analysis, at some point in your Excel career, you're going to need to use a randomized set of data.  If you need to create a purely random set of numbers, with no specific constraints or parameters, you can just use the RAND ... 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

transpose formula in excel 2010select distinct excelremove na from vlookupcreating excel macrosmba fresher interview questionsbuild a histogramhow to use sumproduct in excel 2010what is a vlookup in excelrandom name picker classroomwhat is vlookup function in excelexcell vlookupoffset in excel macroexcel frequency histogramexcel lookup stringexcel indirect referencehow to find duplicates in multiple excel sheetssample excel macro codecontrol chart template excelchart excel templatetick character in excelzs associates vaultvlookup definationexamples of checklists in excelcopy vlookup formula to other cells3 axis graph excel 2010brackets on excelformat axis in excellearn vlookup in excel 2007how to simulate in excelexcel count ifsadding columns excelvlook up functionscenario builder excelbell chart in excelmba ucla rankingworks cited converternormal curve graph generatorexcel list of values from another sheetxls macro tutorialhow to make bar chart in excel 2007match formula in excelhow to use true or false formula in excelhow to create bell curve in excelhow to calculate bin width3d histogram excelexcel pivot tutorialvlookup example to compare two columnsh look upwww transportation ucla eduvlookup 2010 for dummiesexcel filter shortcut keydoing formulas in excelhow to insert tick mark in wordcheap ucla apparelformat data labels excelms excel random number generatorhlookupslist of random numbers in excelinventory excel sheet2 if statements in excelrandom number selector excelremove duplicates in exceltask scheduler excel templatehow do i insert a checkmark in excelhow to filter duplicates in excel 2007writing vlookup formulas in excelvlookup conditional formattingdelete duplicate lines in excelhow to find duplicate records in a tablevlookup function in vbadelete duplicates from excel