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 >>

My 2016 Goals

by Matthew Kuo on December 28, 2015

in Blogging

2015 was a tough year for me.  And that's without even considering what happened to the Seahawks at the beginning of the year.  My career has stalled.  My health has gotten worse.  And overall, I'm still a bit unclear about several things in my future.  In 2016 I'll be turning 32 years old.  Wow.  I'm ... Continue Reading >>
As we get close to the end of the year, one of the things I always make sure to check before January is my overall tax liability.  From a financial perspective, my preference is to owe the government a little bit of money.  If at the end of the year, the government owes me a ... 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 >>
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 >>
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 >>
When I started, I never really gave much thought to Excel's broader web community, which I was implicitly joining.  At the time, I was really just posting Excel tips and tricks because I thought they were interesting and would be useful to fellow MBA students.  While my engagement and capacity to contribute to ... Continue Reading >>
The IFERROR formula was designed to solve a common aesthetic problem that most of us have encountered when using Excel - when we know that there are errors in our data, but we'd prefer not to see Excel's standard error message notation.  Error messages usually consist of all caps lettering that is preceded with the "#" ... Continue Reading >>
Learning the VLOOKUP formula is, for most people, the first step taken towards becoming an advanced Excel user.  For me, this milestone actually occurred in 2004 during an internship at Microsoft in the company's Commercial Operations Division.  One of the senior analysts showed me the ropes by teaching me the formula.  While Continue Reading >>
OFFSET MATCH MATCH is the final lookup combination I'll cover among the lookup formula options you have available to you in Excel.  Of all the different lookup options you have to do a two-way lookup, INDEX MATCH MATCH is still probably your best bet and the approach I would generally recommend.  However, OFFSET MATCH MATCH ... Continue Reading >>

Related pages

issue tracking excel templatedelete rows in excelhow to use vlookup to compare two columnsloop in excel formulairs w4 calculatorwhy do we use vlookup in excelexcel vba templateexcel formula for taxexcel isnumber searchexcel chart label data pointsvlookup with an if statementvba excel numberformata tick in excelconsulting names generatorexcel 2010 line chartexcel insert checkmarkcreating a vlookup tablenested if excel formulavlookup isnahow we use vlookup in exceluse excel to find duplicatesbruinbill accountvlookup excel 2010 examplevlookup exampleexcel exclamation pointdraw line graph in excelhow to lock random numbers in excelin excel shortcut keysshortcut keys for excelms excel formulas with examplesexcel vba randexcel conditional statementsms excel remove duplicate rowsdelete duplicates in column excelline graphs in excelconditional formatting excel 2010 compare two columnsrandom number generator excel no repeatslookup function in excel 2010excel 2003 lookupsites with most trafficcommon excel formulas cheat sheethow to insert tick mark in excel 2007excel 2010 identify duplicatesvlookup formula in excel 2007 with examplewhen to use stacked bar chartstacked bar chart excel 2013create random numbers in excelhow to highlight duplicates in excelucla myuclainsert tick in word documenthlookup ifwriting excel macropaste special values shortcutexcel bracket templatecheapest microsoft officeexcel planner templaterandom name picker excelfind duplicates in excel sheetexcel formula tipsdownload free trial microsoft office 2010excel histogram tutorialhow to conditional format in excel 2013excel p&ldownload free trial of microsoft office 2010symbol of tick mark in wordexcel match commandbell shaped curve in excela cell as it applies to excel 2010formula to compare two columns in excelpdf file converter to excelstandard deviation histogram excelhow to learn excel shortcutsin excel vlookupexcel vba remove duplicatesvba remove duplicatesexcel unique random number generatorrelative cell reference excel definitionsample data sets for excel2 way vlookuphistogram charts