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


spreadsheet modelling examplespaste from excel to accessvlookup errordecimal number generatorexcel formulas tutorialscolumn labels excelformula sheet excelhow to combine duplicate rows in excelcell reference excel definitioncountif formulashide excel formulasfilter unique records excelhow to make a bar chart in excel 20132 way vlookupvlookups excelucla ticket office universal studiosexcel find duplicates in two columnsexcel if function with multiple conditionspaste special shortcut keydelete duplicates on excelstatistical distributions in excelexcel formula equal to or greater thanexcel formula to find duplicates in a listcreating a stacked column chart in excelexcel sheet formulasstacked column graph excel 2010the goal by eliyahu m goldrattrange of cells in excel formulacpk graph in excelexcel count ifcomplex vlookupexcel vlookup referencenum in excelvllokup excelexcel macro samplesmaking a histogram in excelcheckmark charactersample financial models in excelexcel 2010 iferrorvba create graphhow to count duplicates in excelcompare two columns in excel and find matcheslookup function vbafind duplicates in excel sheetmicrosoft excel graph templatessample mean formula excelif cell contains text then excelucla scedule of classesexcel duplicate removerhow to use goal seek in excel 2013excel random formulamba recruitershow to put power in excel formularemove duplicates in a listfinding duplicate data in excelgauss chart excelexcel cell format customvlookup and hlookup examplesexcel unique values in columnwingdings codesexcel histogram graphbuilding financial models with microsoft excelmicrosoft word insert check markcode review checklist template xlsexcel vlookup true falseexample of vlookup formulaexcel find matching values in two columnsvlookup using datesvlookup similarwhat is vlookup in ms excelexcel countif greater than 0excel compare columns for differencespaste function in excelthe goal movie goldrattfinding duplicates excel
\n