If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>
My two years of business school have officially come to an end, and while I’m very happy with the end result, there are definitely a few things I wish I would have planned better.  Many students choose to walk into their MBA programs like a chicken with its head cut off; they expect to make ... Continue Reading >>

My Pre-Employment Goals

by Matthew Kuo on August 2, 2013

in MBA

One of the benefits of my post MBA full-time job offer is being able to delay my start date until three months after graduation.  Unlike most of my peers who are entering consulting for the first time, I know first-hand how stressful the lifestyle is and therefore wanted to delay my return to the workforce ... Continue Reading >>
The attached model is used as the baseline example for my How to Build an Excel Model series of posts.  It has been designed to illustrate the key principles and concepts behind effective model building.  If you plan to download the file, please read the series of posts here to gain further context: How to Build ... Continue Reading >>
The following post is the third in a series of posts about Excel Model Building.  To review the previous posts on this topic, please click through the links below: Click here for Part 1 of this post, How to Build an Excel Model: Key Principles Click here for Part 2 of this post, How to Build an ... Continue Reading >>
One of the most important aspects of model building is the way you setup the tabs in your Excel workbook.  Every tab you create should have a specific purpose within your model; otherwise, the tab should be deleted.  By having a clear understanding of the different tabs and their respective functions, you’ll build an efficient Continue Reading >>
When it comes to building Excel models, there really are no widely accepted guidelines that Excel users follow.  Because of this, Excel model building is more of an art than a science.  Every single model you encounter tends to have its own nuances and quirks.  Even if they come from the same user, as no ... Continue Reading >>

Related pages

how to make a stacked bar chartexcel horizontal lookuptick in excelturn off scientific notation in excelhow do i get a checkmark in wordcomplex vlookuppivot tables excel tutorialduplicate remover excelexact bin lookuphow to understand excel formulasstring compare in excelexcel lookup not workingvlookup formula examplevlookup excel 2010 exampleexcel stacked columninsert tick symbol in excelnested count ifsearch duplicate in excelcreate a macro excelexcel convert horizontal to verticalexcel 2007 lookup functionexcel formulas with examplesnested if and statements in excel 2010excel tables tutorialcreating histograms in excelmycareer ucla andersonbell curve in excelhow to build excel macrosexample macro exceladvanced excel array formulasexcel shortcuts and formulas pdfexcel macro lookupprimo pdf software downloadexcel formulas vlookup multiple entrieshow to keep track of inventory in excelcheckmark for wordexcel 2010 compare two listsvlookup function in excel with examplecreating histogram excelwingding checkmarkhow to get rid of duplicates in excelstatistical bell curve standard deviationhow to combine 2 columns in excel 2010how to create a frequency histogram in excelexcel formula arraystatistical bell curve standard deviationreverse lookup excelalways running sparknoteshow to remove conditional formatting in excelremove duplicate excel 2010excel delete duplicate rowsinsert tick markinsert checkmarkexcel linked cellsh look up in excelvba delete duplicateslookup table in excelexcel countif valueexcel count occuranceshow to create a bell curve in excel 2007lookup formula in excel 2007excel color schemesexcel formula definitionsrandomiser namesexcel create macrowriting excel macronested if formulasremoving duplicates excellookup from pivot tableexcel formulas trickscountif excel formulablank excel formulapaste special shortcut exceluse excel to find duplicatesexcel histogram binlaptops for mba studentsvlookup namesv look up formulahow do i count cells in excel