Excel Templates

In 2012, back when I was in business school, I created a spreadsheet-based task tracker to manage my various commitments.  Because I'm somewhat of a visual design nerd, I leveraged Excel as my platform of choice because of all the detailed conditional formatting options available. It's now been more than 4 years since I created Continue Reading >>
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 >>
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 >>
While cold calling is practice that most students dread, from a teacher’s perspective, it’s an effective way to encourage students to prepare for and participate in class. We’ve all been on the wrong side of this situation at least once in our lives, coming to class completely unprepared.  And the natural thing to do when Continue Reading >>
The key to preparing for behavioral interview questions is to ensure that you have proper coverage for all of the core behavioral question types.  To put it another way, you want to make sure that you have a story that applies to every question your interviewer might ask.  What you really want to avoid is ... 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 >>
Free Excel Template Download When I started as an MBA student at UCLA Anderson, I was surprised and eventually overwhelmed by the number of responsibilities I had to manage.  Multi-tasking was something I had always considered a skill of mine, but I soon realized that I couldn’t track all of my tasks just by memory. For this ... Continue Reading >>

Related pages

plot distribution excelexcel logical testshow to use the transpose functionhow to create a vlookup in excel 2007formula used in microsoft excelvlookup excel syntaxhow to delete lines on exceltwo if statements in one cell excelexcel vba cell formulaexcel functions tutorialtick symbol ms wordgauss curve excelhbr case solutionshlookup vs vlookupexcel line graph tutorialmy ucla portalmicrosoft excel multiple if statementslookup xlsmultiple columns in excelshort cuts in excelexcel probability formulasnested if and functionsexcel count if valuehlook uphow to do goal seek in excel 2010symbol microsoft excelusing vlookup functionvlookup and hlookup formulaexcel index match multiple matcheseliminate duplicates in excelucla ackerman bookstorecreate an excel macroinsert tick mark in exceldifference between filtering and sortingms excel offsetucla student parking permithow to graph a distribution in excelexcel vba vlookupplotting standard deviation in excelexcel drag formulaformatting numbers in excelpay stub excel templatehorizontal lookup in excelucla femba admissionsexcel vlookup offsetexcel rounding large numbersmacro to remove duplicatesdelete duplicate entries excelvlookup returns 0 instead of valueexcel 2007 stacked bar chartvlookup instructionshow to write formulas in excelstack chart in excelcount identical cells in excelmost common excel functionsdelete duplicate values excelucla schedule of classesexcel duplicates removevlookup 2010 for dummiesms excel vlookup functionhow to do a vlookup functionwebmail.kinross.comhow to get rid of duplicates in exceleasy excel formulasthe goal by eliyahu goldrattmaking excel graphsbell curve generator excelexcel how to vlookupexcel spreadsheet for inventoryvlookup 2 columnsexcel insert row formulaexcel delete double entriesvertical line excel chartif cell is not blank excelfree trial of microsoft access 2013searchable excel databaselookups in excelindexing in excelexcel short cutsexcel if statement with vlookupexcel generate random passwordexcel formula replacezs associates india salaryexcel vlookup multiple sheetshistogram excel bin range