Excel 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

how grading on a curve worksvlookup sample filevlookup in another sheetharvard format case studyexcel comparing cellsvlookup with numbersexcel value lookupwhat is a nested if statementhow to perform a vlookuphighlight duplicates in excel 2007excel formula for countiftab symbalprobability distribution graph excelvlookup funtionexcel macro sheetsgoldratt the goalexcel stacked bar graphexample of vlookup in excelinventory tracker excelmultiple if statements excel 2010zeros in a croreclustered column chart excel 2013excel countif not workinghbs case studiesexcel lookupsexcel formula sheethow to set up a lookup table in excelwingding tickrandom name picker excelvlookup arraywhat is a nested ifnormal distribution graph makervlookup if statementexcel 2013 indirect functiondelete duplicates on excelreplace command excelvlookup excel function examplesduplicate cell excelhow to randomly select in excelstacked columns in excelthe goal sparknotesmultiple if formula in excelside by side bar chart excelexcel custom formula3d stacked bar chartexcel histogram bin range2 if statements in excelexcel shortkeysnormal probability plot excel 2010most popular excel formulasexcel vlookup multiplez score graph generatorhow to remove duplicate cells in excel 2010how to create vlookup in excel 2007format for excelcountif excelldivide numbers in excelvba excel samplefind duplicate rows in excel 2007adding title to excel chartstack graph in excelexcel trim not workinghow to get tick mark in excelblank function excelexcel formula to highlight duplicatesisna excel 2010excel index array formulahow to transpose data in excel 2007excel auto multiplyjohn isnabasic excel macro examplesmicrosoft access 2010 60 day free trialbill jelen powerpivotvlookup example excel