INDEX – MATCH : VLOOKUP’s powerful brother

Now that you’ve mastered Vlookups (here) – and you probably got the job (woohoo!) – I thought it might be a good time to introduce Vlookup’s more advanced, powerful, and flexible brother: INDEX/MATCH.

While Vlookup is more popular, INDEX/MATCH is kind of like Vlookup’s older, wiser brother who’s in college – maybe he’s not as popular but he’s way more powerful.

In this post I’ll go over how to use INDEX/MATCH and a really cool application. (The example is similar to one of the first spreadsheets I created. It gets a lot of “oohs and ahs”. It’s pretty magical (but easy to create!)).

Soooo .. what is it?  Continue reading

Pivot Tables – the last piece of the interview puzzle

Happy New Year! I hope it was a great holiday filled with family, cookies, and lots of love. Hopefully Santa brought you everything you were hoping for. I thought I would start the year off by giving the gift of Pivot Tables! (Maybe not quite as great as the shiny, new Tesla wrapped with a gigantic, red bow that Santa left in your driveway  -but I’m sure it was a close second on your wish list).

It’s been a little while since my first post when I promised to teach the three components of Excel (VLookups, Macros, and Pivot Tables) that would set you apart in an interview. (Sometime before those great food and cookie coma’s of December). So let’s finish off the trifecta and get the job.

What are Pivot Tables? Continue reading

Magical Macros

Remember when I promised to introduce you to the wonderful, magical world of macros?

I told you that if you really want to impress your interviewer, you should drop 3 key terms: Vlookups, Pivot Tables, and Macros. So you just explained Vlookups to your interviewer -they were pretty impressed! Then they heard the word “Macros” and their eyes widened like you just placed a 10 pound turkey in front of them while juggling fire. Obviously they’re going to ask you about it. I want you to be able to not only name drop, but be able to back that up with knowledge of how it works and how you can use it in your job to kick butt.

I hope you’re prepared for your relationship with Excel (and probably life too) to change forever … because this is it! I would like to introduce you to The Magical World of Macros… Continue reading

I just graduated! – The real world of VLOOKUPS

So you just graduated from college? Congratulations! If you’re like me, I hope you had a fun summer off! So now you decided it’s time to get serious. Time to start looking for your first real job. Scary stuff.

When I first started on my job search I had the most successful person I know (my millionaire uncle) look over my resume. I was looking for a job in a similar field (finance / accounting) but on the opposite coast. He told me right away, key words to use on your resume that will instantly get you recognized and out of that dreaded stack of college grads is *drum roll* EXCEL! He instructed me to learn three things right off the bat: VLOOKUPS, Pivot Tables, and Macros. He said “those are really easy to learn – do a quick google search – drop those in your resume or phone interview and you’ll stand out immediately”. Those words were like some foreign language to me at the time. Looking back, I wish I had an easy tutorial (like this one *nudge* *nudge* *wink* *wink* get the hint?) to tell me all I needed to know. If you haven’t guessed already, I’ll be covering the basics of VLOOKUPS in this blog post. (Part two will be macros – which is my personal favorite and current addiction – I’m an excel geek).

1. What is a VLOOKUP? Continue reading