IF Statements

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 >>
When writing a series of VLOOKUP formulas, one of the annoying things is having to see the "#N/A" error after Excel has determined a lookup value is not available.  While we don't want to show any values when they are truly unavailable, from a visual design perspective, it's sometimes better just to show a blank space ... Continue Reading >>

Related pages

financial forecasting models excelvlookup function helpexcel convert functionhlookup explainedusing vlookup in vbathe goal goldratt movieconsulting boutiqueshow to use vlookup step by stephow to draw a normal distribution in excelsyntax in excelhow to set up excel formulasmba resume tipsif and vlookup combinedconvert excel spreadsheet to pdfhow to make column chart in excel 2010vlookup with choose functioncalendar timeline template excelinsert histogram excelusing countif function in excelvlookup and functionexcel spreadsheet modelingformula for vlookuprandom number generator excel 2010shortcut keys excelvlookup xlsexcel logical statementsstacked barchartthe goal a process of ongoing improvement cliff notesrandom names generatorcompare to columns in excelvlookup won t workexcel formula syntax cheat sheetvlookup in pivot tabletick character mapmyucla webmailhighlight column excelexcel formula for taxresource calendar template excelcoding macros in excelhow to divide by 1000 in excelexcel formulas vlookup example pdfcopy vlookup formula to other cellsexcel rows functionexcel shortcut delete rowcool excel chartsforecast calculation in excelvlook up excelduplicate cells excelcountif greater thandelete duplicate rows in excel 2010v lookup examplehow to fix a value in excel formulahow to use the transpose functionexcel vlookup formulas with examplesrandom formula generatorvlookup practicesymbol microsoft excelexcel std deviationcpk formula in excelgpa curvevlookup multiple instanceshow to create a countif formula in excelexcel formula countifskinross gym uclaexcel replace commandhow to set up formulas in exceltick for microsoft wordwhere is the tick symbol in wordnested vlookupscpk graph in excelhow to use excellmicrosoft excel formulas tutorialinsert tick in wordhow to build a bar graph in excel