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

eliminate duplicates in excel 2010how to vlookup in exceleliyahu goldratt booksexcel vlookup multiple columnsvlookup left to rightlogic formula in excelshortcut key to create pivot table in excelusing lookup function in excelarray formula in excel 2013removing duplicates in excel 2010my ucla portalw 4 withholding calculator 2015excel remove gridlineshow to create a bell curve chartcountif examplesmba for dummiesexcel vba tabconsulting boutique firmsexcel identify duplicates in two columnsexcel randomizationmicrosoft excel offset functionexamples of if statements in excelcol_index_num vlookupformula for vlookup in excel 2007how to find duplicate values in excel 2010boundaries circle chartexcel formula unique valuesmba refresher coursegoldratt goalcountif excellvlookup hlookup pivot table pdfwhat is vlook up in excelhow do i insert a tick in word 2010making graph excelstacked bar chart in excelexcel finance templatereverse vlookup in excelcheck mark symbol microsoft wordpivot tables vlookupsmulti column vlookupmatching data in two columns in excelsyntax of nested ifexcel combine formulasexcel frequency histogramrandom formula generatorhow to remove duplicates in excelvlookup indirectcell count formula excelexcel filter out duplicatesexcel match 2 columnsmyiclaexcel macro sheetucla ackerman post officeexcel 2010 conditional formatting multiple conditionsvlookup and hlookup tutorialexcel password templategoal eliyahu goldrattscenario modelling excelmicrosoft excel adding columnslearn vlookup in excel 2013how to make tick mark in excelhbs caseslogon.ucla.eduexcel paste special shortcutinventory spreadsheet exceloffset match functionmacro remove duplicatesvlookup function excel 2013vlookup formula in excel with examplenested if and statements in excel 2010mba syllabus harvardfreeze formula excelvlookup in excel 2007 formulaexcel formula percentage formatshort cut excelrandom number generator in vbashort cut in excel