How to Streamline the Excel Error Checking Process: Excel’s Inspect Workbook Feature

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

The Eight Most Impactful Excel Shortcuts That You Should Master

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

How to Write an Excel Criteria Statement That Links to a Specific Cell

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

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

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

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

15 Resume Tips for MBA Students

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

8 Test Taking Tips for MBA Students

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