How to Remove Duplicate Values in Excel

Five Ways to Find and Remove Duplicate Values in Excel For people who work with large data sets in Excel, or databases for that matter, one of the most common error checking tasks is the removal of duplicates values.  Some people refer to this process as de-duping.  The main reason this is necessary in data sets ... Continue Reading >>

How to Use INDEX MATCH MATCH

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 >>

Key Takeaways from the Goal: A Process of Ongoing Improvement

The Goal: A Process of Ongoing Improvement, by Eliyahu M. Goldratt, is a book pretty much every business school student is required to read.  Below are the key takeaways from this book: Accounting vs. Operational Measures Accounting cost figures misleading for operations purposes Productivity per machine is meaningless; Continue Reading >>

108 Tips for New MBA Students

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 >>

18 Tips for UCLA Anderson Students

After compiling a long list of recommendations for MBA students in general, I wanted to pay service to my own alma mater by creating a list specific to UCLA Anderson.  UCLA is an amazing campus, but as business school students, we often feel disconnected from it and rarely understand the full range of benefits available ... Continue Reading >>

6 Recruiting Tips for MBA Students

For most MBA students, the recruiting process is the single most grueling experience of their entire MBA careers.  Academics are still important, and your enhanced social life will be fun, but whether or not you consider your MBA a success will depend mostly on how well you do in recruiting. Recruiting is typically a difficult journey Continue Reading >>

15 Interviewing Tips for MBA Students

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 >>

MBA Interview Preparation Checklist

If the fact that I run an Excel blog wasn’t a dead giveaway, I clearly have somewhat of an obsessive compulsive nature.  I try my best to channel this into positive behavior and an interview preparation checklist was one of the outputs.  Having a checklist of items and knowing that I was as prepared as ... Continue Reading >>