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 ...
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 >>
Excel Random Student Name Generator
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 unprepared Continue Reading >>
How to Build an Excel Model: Step by Step
Why INDEX MATCH is Better Than VLOOKUP
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 of switching ...
How to Learn 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 established ...