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


example for vlookup in excelproductivity tracker excel templatemultiple vlookupsexcel template for inventorysimple if statement excelsimbol go greenexcel compare columns highlight differencesexcel vba rangesgraph chart in excelthe goal by eliyahu goldrattucla uidvlookup excel multiple sheetslookup tables in excelhow to insert a checkmarkcalculate tax in excelcode for checkmark in wordmatrix calculation exceloffset in excel 2007excel insert columnsexample of vlookup formulaexcel formula for tab nameexcel 2007 formulas listindirect excel formula examplesgaussian random number generatorhlookup excel tutorialexcel formula for whole columnvlookup with and functiontick symbol character mapexcel vloohow to remove duplicates in excel 2007vba create a new worksheetexcel multiple if statementnormal bell curve standard deviationfemba uclacountif valuewingdings checkedit array exceltrue or false formula in excelvlookup multiple instancesexcel logical teststab symbalaction tracker excel templateputting in excel formulasarray calculation excelexcel countif criteriacompare two lists in excel 2010conditional ranking in excelvlookup in excel 2007 formulavlookup namesexcel shadestick mark symbol in wordinsert a tick mark in wordexcel vlookup multiple criteriaquestions to ask in mba interviewexcel graph labelsexcel vba function rangeexcel dividing by zerotask tracking spreadsheetucla accounts payabletypes of formulas in excelrandom sampling excelhow to use hlookup formula in excelbins excelif iserror in excelvlookup arraytax excel spreadsheetexcel formula remove duplicatesexcel iferror blankexcel vba vlookup exampleexcel formula checkeruse of in excel cell referenceexcel color schemenormal distribution curve creator
\n