processes

Checking for errors in your Excel files is always a pain.  It's generally a very manual process that takes a lot of time, with a certain level of ambiguity regarding your return on investment - you could spend hours checking for issues in your Excel file, find nothing wrong, and your only tangible benefit is ... Continue Reading >>
If you've ever gone online to research improving your Excel skills, you've undoubtedly come across a post or two listing all of Excel's keyboard shortcuts.  In the latest version of Excel, Microsoft has made it easier than ever to learn shortcuts, by assigning shortcuts to nearly every function and making the discovery of the input Continue Reading >>
I generally give Excel a lot of credit for being an intuitive and easy to learn tool.  However, writing criteria statements that link to cells is probably one of the most un-intuitive aspects of formula writing in Excel.  This is a very common mistake that occurs and therefore, should always be error-checked whenever you are ... Continue Reading >>
If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>
It’s been two months since I graduated from business school, and I still have one month before I start my new full time job.  During this pre-employment period, I have not used my alarm clock once.  I play a lot of tennis, binge watch television shows, and even took a two week trip to Europe.  ... Continue Reading >>
You can network with tons of people, have the most amazing resume, and even write a world class cover letter, but at the end of the day all of those factors are just precursors to an interview.  Once you step into the interview room, all of that prior recruiting investment for your dream job will ... Continue Reading >>
Your resume is probably the most important document you will create during your two years in business school.  When I started my MBA, I actually thought my resume was in great shape.  But my initial review with a career counselor proved otherwise and made evident the time I needed to spend on this process. During fall ... Continue Reading >>
The idea of taking an exam is something that most people dread, and for some, it prevents them from applying to business school altogether.  However, if you’ve already been admitted to an MBA program and plan on recruiting for a field where grades matter, such as consulting or investment banking, then test taking is a ... Continue Reading >>
Attached is the notesheet I created from my Regression Analysis final.  It's a bit messy, as I had extra space and filled it in with additional formulas.  However, I felt this version was worth posting because of the insights around multivariate regression. Download as PDF 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 >>
\n