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

I applied to Mck, although I thought I didn’t do well I got the offer. I have had other people say similar. Has the bar for getting the offer lowered? McKinsey & Company

like

Has anyone had any experience interviewing with IBM as a consultant for FIS.

like

I am trying to volunteer more and have an interview next weekend for Big Brother Big Sister. Do I need to prep?

like

Start Applying around guys/gala. Seems like there’s a lot of job openings at every company. In my past couple years of applying I’ve never seen this many job openings. Should be a good time to make moves. ✊🏾

like

Having my skills and confirming interview on Monday. Any advice? Tia! Manager role in Federal Grown and Innovation

like

Should I keep applying or give up? I graduated from a mediocre law school 10 years ago (cum laude) and have a tax llm from a good school but mediocre grades(3.1) . I am licensed. I work in public accounting and am at one of the large firms. I do tax controversy, writing, research, international. I applied for tax law firm job over the years - rejected. I interviewed with a small firm today - it's an intellectual step down - I can't do that. Big law still an option or stop disappointing myself?

like

Currently interviewing for McK operations. Any advice from people who have been through the interview process? Should I expect ops related cases? Or the usual general cases?

like

I have 6.5 Years of work experience - all relevant, expecting a positive interview result for the role of Information Security Assesor - What should I be expecting in terms of per annual package ?

Strategy& what is the interview structure/style? What should I expect for my upcoming interview and is there a difference for e.g US and Canada?

Wondering everyone’s take on password-protecting your UX portfolios? I have some case studies from a previous B2B startup I worked at. Although the work isn’t under an NDA, I’m wondering if it’d appear more professional if there were a password. Alternatively, any advice on how much detail to show on a case study in situations like this?

like

Can Nagarro really decide candidature by 15min Technical interview? Is it just formality before rejecting?

like

Hi all, anyone gave the codility test for microsoft interview? Please let me know what all things will be there in test? I am working as a tester - automation tester. Does this test will be more of a testing related or coding related? Microsoft

I have an interview tomorrow for a PM/FinTech role. I have a construction background new to project management. I have my BSBA, PMP, and CSM. Any pointers?

like

Best case interview prep for PE OPS role?

likeupliftingsmart

Hi Fishes, I have received an offer from Barclays for AVP position. But the role discussed during interview was for Tech Delivery Manager whereas the offer letter mentions it as Tech Delivery Lead. Can you guys please suggest if it is the same role or should I request recruiter to get the role updated? Moreover it would be great if any of you can shed some light on the prospects/challenges of this role based on your experiences. Barclays Barclays global service center

like

I have cleared Technical Round in Cognizant and I have also given HR round (telephonic). Just now i recieved a mail from talent acquisition team having subject "Invitation for Live Interview with Cognizant ". I am not sure what kind of interview it is. Can anybody help me?

like

Hi fishes, I have an interview comming up with Cisco for the role of salesforce developer. Cisco being a product company, I am assuming what would be the general patter for the tech roundswould be different from other service based MNC . The interviewer is from US and on checking his profile, it doesn't look like he is from salesforce background. This would be my dream job, can you guys help me understand what areas I should concentrate in this situation. Is there Anybody with prior experience ?

like

Have a case interview for an industry position. Does anyone have recommended resources for preparation?

A Business Analyst with 2+ years of experience. Looking for job opportunities abroad in consulting industry. Skills include data research, analysis, visualization, writing PoVs, primary research (interview &surveys), market analysis etc. Open to Canada, Australia, UK, Switz and flexible with other places too. Please let me know if anyone can refer me! Would like to help you out in someway too :)

like

First time applying to a graduate program - how much do you write in the essay section? Like 3 paragraphs? 3 pages? Applying for the Georgia Tech Online Master’s in Cybersecurity. Tips and advice are greatly appreciated!

like

Additional Posts

This is looking great!

Hhjjndjjffjjddjdh dndbbdndjjdjdndnnf dndbdhjxjdjd djdjhdjdjdjhdjndndndjdjdjdjjcncndjdjnd dhdjhdjdjdjhddhhd ghhhhhhh ghbbbbb fghhhhhhbh cvhhhhhhbhbb ghhbb. Hjnxnxndbd vsbdbddbbxbdbbd dbdhdhdjjxndnbdhdh

like

Post with company

like

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

like

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

Post for push testing

like

Bhh d hhjjj dudjejr the jejune rhjejej. Jdjdjdn dhejejjdne dhejejjdne hehehehehje rhjejej he hehehehehje rhjejej

like

Post for comments

like

Fellow MBB, how does referral work at your firm? I heard EM and above at McK can refer people.

like

Any idea what EY bonuses and raises will look like this year? Director in EYP TS&E if that matters.

like

So what are you getting your significant other for Christmas??

like

Any recommendations on which company to use for pet insurance for a gold retriever puppy?

like

As a mentor or educator, what’s the best gift you ever received and were touched by?

likefunny

Hello fishes, looking for Help in finding the next brokerage platform I should start.. criteria includes 1. investing in crypto and stocks, leveraged funds 2. After hours trading 3. East to track basis/gains for crypto 4. Free crypto or shares for joining

likefunny

Business leaders of tomorrow are going to accept cryptocurrency so ya might want to get with the program and ape into one of these shitcoins.

likefunny

Haven’t done any work yet this morning. Can’t get myself to get started. Anyone else?

likefunny

Hi everyone, I'm starting the EH selection process at Oliver Wyman. I was offered by HR two options: start the process as AS (with alignment to a practice), or as a SC. As a SC, the idea is to figure out the practice I would like to get aligned to and be (hopefully) promoted to AS after 1y. In my current position I have seen a wide variety of projets and we're not asked to specialised ourselves yet. I also understood switching practice isn't that easy. Any advice on these options?

like

How is work life balance at PwC advisory? I have an offer and debating leaving Accenture TDP.

like

For those who are just average or below in terms of career progress by 30 (let’s say senior consultant or new managers, how do you not feel like a failure? Friends are about to make partner soon and I’m just barely hitting SC

likefunny

Is there any way to get investment banking like experience without the investment banking part?

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