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 >>
The vast majority of Excel users have never used VLOOKUP's range lookup feature.  Most Excel users familiar with the VLOOKUP formula are just conditioned to know that, when they get to the range lookup option portion of the VLOOKUP syntax, they should just put in the word "FALSE" because they want an exact match.  This ... Continue Reading >>
Writing a Nested IF Statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced.  The first time I used this technique was during my new employee training, right before I became a business analyst in management consulting.  The overall concept of writing a Nested IF is ... Continue Reading >>
Excel's MATCH formula is an extremely useful yet underutilized function within Excel's toolkit of formulas.  The reason people underestimate its value is because the MATCH formula's primary objective is fuzzy and ambiguous.  Without the proper context, its usefulness and potential applications are not obvious. The MATCH 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

turnitin uclarandom number generator in excel 2010excel courses los angelesexcel fuzzy logicdecision tree analysis excelexcel vlookups and pivot tablesucla accounts payableindex and match function in excelhow to construct histogram in excelucla course listinginsert numbers in exceladvanced excel formattingwingdings character codesbell curve in excelexcel 2007 lookupif statements in excellarray formula examplestacked bar chart total labelhow to apply formula in excel for entire columnhow to use the vlookup function in excelvlookup in excel definitionexcel cell reference functionusing macros in excelexcel lookup multiple columnsstandard curve in excelhow to draw a histogram on excelhow to create an histogram in excelwhat if statements in excel 2010contextures excelexcel countif greater thanlookup on excelinventory template for excelexcel duplicate formulasheet formula excelexcel line chart tutorialcorporate tax liability calculatorhow to highlight a column in excelsample excel macro codelookup across multiple sheetsproper formula in excelexcel format decimal placeshow to shade in excelexcel generate random passwordhow to create a forecast in excelusing brackets in excelvlookup and hlookup in excel 2010sample excel file inventoryexcel formula criteriahlookup explainedhow to label a cell in excelfilter formula in excelexcel formula hlookupexcel if statement with two conditionsexcel graph in cellmicrosoft office 2014 free trialfree trial microsoft office 2010 downloadh lookup excelexcel logical testscareer path deloitte consultingucla anderson deanucla scedule of classesvlookup example in excelmuuclaexcel lotto number generatorif function excel 2010 multiple conditionshow vlookup works in excellottery random number generator excelexcel lookupcountif not equal100 stacked column chartwhere is advanced filter in excel 2010how to compare two excel spreadsheets for duplicatesnested if condition in excelexcel vba averagevlookup with multiple valuesexcel dedupemicrosoft excel find duplicateshow to use vlookup and hlookup together