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


what does vlookup stand forprofessional excel graphsdefinition of vlookup in excel 2007what is the purpose of vlookup function in excelcheck tick symbolexcel logical statementsshortcut key for filter in excel 2010excel shortcut pdfexcel remove gridlinesfind duplicates in excel sheetbin range histogram excelmba in uclathe goal a process of ongoing improvement movietick character mapexcel chart stylesexcel lookupsexcel function randinsert tick box into excelharvard business school case methodexcel vlookup function exampleexcel duplicate deleteexcel formulas vlookup multiple entriesvlookup microsoftshortcuts keys for excelucla wooden center classesexcel replace duplicates with blankstick symbol to copyidentify duplicate records in excelcountif function in excel with multiple criteriadownload free trial microsoft office 2010how to add axis titles in excelexcel function stdevexcel project calendar templatehow to delete duplicate information in excelgoals template excelwhat is hlookup in excelmyuclaexcel identify duplicates in two columnsw4 templatetick yes symbolcountif functions in excelgenerating random numbers in exceloffset match functionucla anderson housingwebmail.ucla.edumacro formula excelhot to use vlookuptask tracker spreadsheetwhat is the formula for vlookup in excelvlookup exact matchbox graph excelcheck excel for duplicatesh lookup in excelexcel formula isna vlookupvlookup formula to compare two columnsexcel macro random number generatormyucla webmailexcel fuzzy matchtax calculation templateconvert excel file to pdfexcel syntax cheat sheetmicrosoft word insert check markgoal seek function excel 2013excel count formulaspivot table count unique valuesadding error bars in excel 2010step by step vlookup in excelexcel formula unique countsimple vlookup in excel 2010exel shortcutshow to create a vlookup in excel 2007excel compare 2 lists for duplicatesvlookup rowdata table excel sensitivity analysisucla clothing store westwoodvlookup across multiple columns
\n