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

if statements excellsyntax excel definitionwhen to use vlookupmicrosoft office publisher free trial download 2010excel randomizerconvert pdf to excel adobehow to use vlookup in excel to compare two columnsexcel logic formulaslearn formulas in excelvlookup named rangemost complicated excel formulaifs function excel 2010what is meant by vlookuppopular excel formulaspricing model template in excelsumproduct and vlookupmatch function in vbaexcel 2007 hlookuphow to do vlookuprandom surnamesexcel generate unique random numberswhat is excel vlookupcount array excelticks in excelexcel 2007 formulas tutorialhow do i insert a checkmark in excelcreate a macro in excelconditional formatting excel 2010 entire rowexcel vlookups and pivot tablesvlookup matchhomework agenda templategenerate lottery numbers in excelcountif greater thanexcel functions lookupvlookup in tablefree excel bell curve template downloadinventory sample in exceldelete duplicates in excel columnlookup in vbazs associates india careersdelete duplicate rows in excel 2010excel formulas countifalexa popularityprobability calculation in excelexcel insert symbolexcel formula inputdistribution graph excellock excel formulahlookupduplication in excelbill jelen powerpivotformat data labels excelhow to perform calculations in excelvlookup refnormal distribution curve excel templatemost complex excel spreadsheetrumus vlookup excelexcel formulas cheat sheetexcel costing templatexl sheet formulavba random numberrandom number list generator excelstd deviation excelhloookupvlookup help for dummieslookup command in excelexcel statistical distribution graphinvalid cell reference errorhlookup function in excel with exampledifferent types of excel spreadsheetshighlight duplicates in excelindirect with vlookupexcel formula is not blank