modeling

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 >>
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 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 >>
When deciding between which vertical lookup formula to use, the majority of Excel experts agree that INDEX MATCH is a better formula than VLOOKUP.  However, many people still resort to using VLOOKUP because it’s a simpler formula.  One major driver of this problem is that most people still don’t fully understand the benefits Continue Reading >>

How to Learn Excel

by Matthew Kuo on January 16, 2013

in Excel

The majority of people who are really good at Microsoft Excel will tell you that they gained their knowledge simply through experience.  When I was a management consulting analyst, I’d frequently be given tasks that I thought were impossible with a spreadsheet; the process of coming up with an Excel solution was what really Continue Reading >>

Related pages


rounding numbers chartexcel duplicate valuesvlookup date rangecpk excel templatehistogram using excelmeaning of isnaexcel iferror vlookupconvert xl to pdfvlookup example 2010highlight duplicate entries in excelucla salary scaleifs excel formulaassumption mbabin range excel histogramrange lookup in excelfree trial of microsoft powerpoint 2010if statements in excel 2010multiple if condition in excelhow to do cumulative sum in excelisna matchrandom usernames generatorexamples of formulas in excelexcel custom format thousandsvlookup another sheethow to draw a bell curvevslookup excelif iserror vlookupvlookup in excel examplesdelete column excelifs exceldownloading microsoft excel 2007 for freecustom excel formulamaking graph excelexcel match deutschputting in excel formulashow to use hlookup in excel 2007 with exampleplot bell curve excelhow to paste horizontal to vertical in excelucla anderson alumni directoryhow to insert tick in excelvlookup between two valuesquestions to ask during mba interviewrandom order generator excelhow to combine 2 columns in excel 2010how to do formulas on excelcheck tick symbolmicrosoft excel tick symbolhow to do a checkmark in excel 2010tutorial for excel spreadsheetsinsert symbol in powerpointsumproduct vlookuphousing construction cost variables excelhistogram analysis excelchandoo vlookupexcel vloopupvlookup rowscount if rangeclass tools randomiseroffset match excelhow to eliminate duplicates in excel 2010counting duplicate values in excelhow to use hlookupexcel 2007 hlookupvlookup practice problemsexample excel formulasdelete duplicates in column excellearn excel formulas and functionshorizontal stacked bar chartvlookup in excel 2007 with example in excelinventory sheet excelexcel function stdevexcel stacked bar chartsspreadsheet lookupcountif excellhistogram binning
\n