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

Naive Question: McKinsey interview is coming. What should i wear? Suit and Ties? No Ties ok?

like

Deloitte 🐠: had a final round interview today, recruiter said will call "within a few days" to let me know decision. Any general consensus on how long?

like

I turned down a second round in-person interview for an internal audit staff position paying 15k more than my current position because, a) I want to stay and be senior for a year, b) ... cont

like

I have interviews scheduled with other Big 4s and Slalom. How difficult is it to switch firms for folks on H1B ?

like

Interviewed with AlixPartners, finished up two weeks ago, sent 2 emails asking for update, no response - do I assume non-offer?

like

Prepping for business process transformation/tech program management role interview. Any tips? Role is in financial services.

like

For those who have lateraled to MBB or a Tier-2 firm (ATK/S&/OW/LEK/etc) - how did you find time to prep for case interviews if you’re staffed on an intense project?

like

Anyone have a DUI prior to applying for a job at big4? Curious how the firms view one on a background check, particularly one that’s old (almost 10 years).

like

How can I increase my chances of getting a Google interview after submitting the application? I know a few people who work there but anyone have specific advice on what to say to them? Or other advice

like

Just got my 11-month old daughter a passport and of course applied for Global Entry. I think it's hilarious that US Customs needs to "interview" kid that can't say anything more than "mama" or "dada".

likefunny

Traveling to LA for second interview at a creative shop & they asked that I complete and present a strategy assignment to showcase my “thinking”.. what do you think is more important....(cont)

like

Received the rejection email from M and didn’t even get a chance to interview 😂

likefunny

A recruiter reached out to me for an in-house position I really want. Is it actually beneficial to go through him vs. just applying on LinkedIn?

like

How is the work life balance at Cherry Bekaert as a whole and/or in Atlanta? I saw job openings and I’m thinking of applying to either their ITax or Transfer Pricing group.

like

Curious to know, usually how many people are candidates competing against when you make it to the final interview stage at an agency, specifically for something like an AD position

like

PwC recruiter just canceled my interview saying they're looking only for people with at least 2 and half years of h1b left. I have one year left to get extension for another three years.

like

Anyone moved from audit to EY FAAS? Could you share the interview experience? Will have a call with HR and I am a bit nervous.

like

Is it bad form to tell my freelance boss that I need to leave early for a full time job interview?

like

After several months of messaging people on LinkedIn and applying to thousands of jobs, I finally got my dream job in the travel industry as a social media coordinator!!!

likeuplifting

Any Customer Success Managers with a recent H1B transfer? What job code did your employer apply H1B? Any RFE s? I am interviewing for this role in Healthcare tech space..just curious Thanks!

like

Additional Posts

Bbdjdndjdjgsjdjcbbdbxndbdbcghsbxhdbdbbxbbdbdbbdbdhxhdbbdbxjdbxbhebsbxb dbdbdbd Bebe the. Dbdbdbd sehsbevshdvhdbdbdbdbdd dbhsbvdbdvdvdbvduchhcbd dbhsbvdbdvdvdbvduchhcbd and I have love you so too but I

like

Comment on this to test rereply notif

Correct font and company!

like

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

like

What are some good companies to work for in Dallas?

Do you see this post? 12:59am

Top top post!

like

Where is a new build???

like

test on 1.1.5!

like

Testing for sound!

Post for likes

like

Testing at 9am EST

like

But once again not posting

like

Still not seeing location in the post window when turning it off.

Post with company

like

Deloitte CyberSecurity - do you have a local office culture where on Fridays you are expected to be in the office?

like

Why does the ORD-EWR flight have an unusually large populous of unusually bored/sad/indifferent Indian men

like

What is your hypothesis on how our work environment got so vicious? From a human psychology perspective it’s interesting

like

Barry’s Bootcamp...beat the sh&: out of me 🤕

like

I live abroad and every time I come home to the US I'm astonished at how worn/crumbling the infrastructure looks. I love it here - and it's home - but the sidewalks, airports, etc are just pathetic

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.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal