{ "media_type": "text", "post_content": "Good online courses for PIVOT tables and V Look Up? I haven’t touched these since an Excel class in college and the recruiter is saying I should brush up for an Excel test given in the interview process.", "post_id": "61e9a6f975de940027735ea9", "reply_count": 15, "vote_count": 4, "bowl_id": "553769a790f5eebe1d2a0f92", "bowl_name": "Finance", "feed_type": "crowd" }

Good online courses for PIVOT tables and V Look Up? I haven’t touched these since an Excel class in college and the recruiter is saying I should brush up for an Excel test given in the interview process.

like
Posting as :
works at
You are currently posting as works at

Don’t use vlookup, use index(match()) instead. But yeah, youtube and just practice with some dummy data sets

like

Xlookup is the way to go

like

Look on YouTube, there are tons of videos on excel there, and you'll probably discover things you've never heard of if you find one of those excel tutorial channels.

like

Definitely need to this - thank you!

jon excel campus on youtube is great

like

What else do they offer?

You can also do a structured course on Udemy if something more formal is your style.

like

CFI has a free excel crash course

like

Following

Look on youtube or Google. Practice several times with your own data until you can do it without thinking too much. This is a foundational skill in many roles, they will want you to do relatively quickly if they are testing for it

YouTube is definitely your best friend

Related Posts

How great is it to go back to college campus for the start of Fall interviews... this time as an interviewer! 😀 This is going to be fun.

like

Where are you applying for business school?

like

Favorite interview questions or case studies you've been asked or have asked others?

Best excuses for missing work for an interview?

like

What should I ask for in my exit interview?

like

What do you guys do when interviewing for a new job on a Friday? Tell the team you have an appointment or just hope they don't notice you're offline for 6 hours?

like

Any Capco consultants here? Any info about it would be greatly appreciated. Got called for an interview but don't know much about them

like

On my way to interview with EY- what to expect? Haven't done this for 5 yrs

like

How would one score an interview at McKinsey from a bit four firm? Background: regulatory experience

like

Do you wear your wedding/engagement rings to interviews? (Rings have connotations for both genders...)

like

Applying for India Business visa is a very frustrating process....😖😖

like

A client just interviewed me for a good hour. First time I meet a potential client over the phone before even being confirmed for the project. This job is going to kill me one day

like

Realizing you have zero skills and no experience when applying for other jobs... Are there any jobs out there in PowerPoint design?!

like

How would I go about applying to other consulting firms? I'd imagine randomly applying online won't end up successful

like

Deloitte and EY, what are your benefits like? I currently get 5 weeks PTO and 100% match up to 6% 401K. I want to start applying elsewhere since I'm underpaid but base salary isn't everything

like

I hate the fact that I have to sit there until 1:30 am doing nothing just because my senior was procrastinating all day long. 6 hours spent applying for a new job! #priorities

like

We all came into this industry having no idea what we would end up doing. Remember yourself during interviews. The old you. Not the current you that can pack a travel bag in 5 minutes.

like

Deloitte Advisory: What type of work do associates in the Business Risk program do? Are salaries typically higher than audit? Thinking about applying!

like

I'm applying to MBAs, any thoughts on Tepper (Carnegie Mellon)?

like

My firm uses webex for online interviews, but sometimes clients can't connect because it requires a software install. What do other firms use, and does it require software?

like

Additional Posts

Ahh it is posting but into middle of feed as opposed to top.

like

Make sure your hard work is protected. File or register with the U.S. Patent and Trademark Office or U.S. Copyright Office before it's too late. Complete our easy questionnaire and we'll help you quickly submit your application. Use your INNOVATOR code for 10% OFF.*

Post to test

like

Fhhbbbbjjnnnnnnsn dnnsndjjjd dhjhdjjdjdjdjnd dhjhdjjdjdjdjnd djjfjdjjdndndnnfnd dhjhdjjdjdjdjnd dhjhdjjdjdjdjnd djjfjdjjdndndnnfnd djjfjdjjdndndnnfnd now djjfjdjjdndndnnfnd do. D dndnnfndnnsdhjdjdjdjnd

like

Post without company

like

Post with company

like

new test post

like

Hi everyone! :)

like

Accenture on comp and bonuses.... “BOHICA BITCH!”

like

I love when the client argues during a status meeting they reviewed more work then reflected but they use descriptive phases like "a whole bunch" or "like at least 10 or 15"....no bitch you didn't.

like

When you email a deck to the client and someone forgot to take off a former client’s name in the template footer. #askingforit #catchmeifyoucan

like

has anybody taken the GRE instead of the GMAT for an MBA program? recently I've been looking into this more because I'm less confident in my math skills

like
like

What do you find to be the hardest thing about consulting?

likeuplifting

Consulting has been such a grind... how to make the most out of it? Not always easy to see why it’s worth it

like

Someone in the country is going to say something amazingly stupid and hateful comment regarding Orlando. Let diversity and peace prevail.

like

Do you think I'll be able to use ubers and taxis as travel for all future client travel ? Don't want to get into it, but have some license issues and don't want to be driving.

Awkward moment when your PM tells you to be full-time on his project... but told the client you were a part-time resource. Escalate? 😬

like

Any 🐠 have technology job connections/referral hook ups in Raleigh NC? Ideally Red Hat, Cisco, IBM or similar. Thanks in advance!!!

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

{ "isSet": true, "allowed": true }

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy.

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal