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

Hi Can anyone give me brief idea about Hirevue interview. What type of questions ask, Is it easy to crack or it simple HR question based or include python sql questions also. Anyone have any idea please help.

like

I had a interview in Mindtree on 5th Jun 2021 and on 7th June they told me that i have been selected and will soon roll out the offer and after that i got "Your Selection Process" email from mindtree careers and after that i have received any communication from then and today when i checked the status of my application its changed to "Parked". Can someone explain what does that mean? I have tried calling and sent an email to HR multiple times but got no response. Can someone suggest what should

like

Has anyone created interview tiers by roles? For example - entry level roles should only take 1-2 interviews, mid level management to VP’s 3-4 and executives 5? If so, can you please share to see if we a reasonable amount? If not, what are your thoughts about the breakdown mentioned above?

like

I am a recent undergrad graduate (engineering), have been working in consulting (ZS) for a couple of months, but would like to try my luck at MBB, specifically BCG. If I get a referral, how likely is it that I will get an interview? (Given that I have been in consulting for a couple of months and that I am not a student anymore that can recruit through campus)

like

Hi Fishes, Few FAQs as they can help all. I am expecting some EPAMer will respond. 1) Does EPAM Anywhere reimburse internet charges additionally? 2) How tough are client interviews? 3) I heard first month you get full salary. How's that possible if a person will be on bench? 4)Do you get laptop from project client? 5)How true is relocation buzz? 6)Can you brief about appraisal/promotion assessment? What's the process? How tough is it? Thanks

like

Is there any place like portal or something to track interview status for TCS

like

Hi all, I have interview today with Deloitte today. Provide some tips on how to prepare and what will be first round? Will it be technical or general questions fro screening process??

like

How do I know it’s time to get out? I’ve been applying to jobs, but is it okay if I don’t have anything lined up before quitting? For context, I recently had to move and now I’m commuting. My boss originally supported my decision to work from home 2 days a week but backed out the week of. Driving for a job w no benefits, very low pay, and I’m not *allowed* to take vacation before my wedding.

like

Hi fishes.. i took interview in LTI for SAP SD and cleared first round.. HR called and informed that i have L2 round.. what they will ask in L2 round.. how to clear L2 round.. in first round they asked full basic concepts and configuration and now don't know what is the expectations in L2 round... Can anyone tell me what is the expectations and how to clear it...

Does anyone know how to go about providing a writing sample to a potential new employer while going through the application process, without letting on to my current team that I am applying for a new job? I understand I would need permission to use a redacted memorandum or document I’ve written during my time a PwC, but to ask for permission to use one of my writings as a sample would basically admit that I’m applying to another job. What is the appropriate thing to do in this situation ?

I have my first round of an interview with Deloitte! I’m super stoked but they want me to answer some questions before I chat with the recruiter. All of them are easy and I’m comfy answering them but one is where my preferred location is- I selected that I’m not willing to relocate in my application and am wondering how to say that again without disqualifying myself! HELP!

like

Hi! Is anyone down to case? I have MBB interviews coming up soon and want to get some practice in. I’ve interned at MBB and Tier 2 before so I have fairly decent experience with casing. Thanks!

likesmart
like

For those who work/interviewed with Facebook (Meta) did you have another interview after your virtual on-site loop? Recruiter initially said next step after loop was an offer if selected, now she’s telling me they loved me but want to deep dive into my response to the case study, so one more case interview. Is this strange?

like

I am an office coordinator at Memorial Sloan Kettering Cancer Center and want to break into the field of research. MSK has research coordinator roles, however when I initially applied after graduating, I didn’t get any interviews. I have minimal experience with research from undergrad. I’m not sure if it is possible to switch roles within MSK. I also want to go back to school for an MPH. Anyone have any experience with this or any tips?

like

Hi Friends, I am working as SA2 in PwC IAC, ITAC SAP Audit. I have completed 2 years in my current role. I am expecting Manager role in the next month appraisal. But in last month I got market correction and my package become 17lakhs per annum. I attended two interviews and I am being offered 19lakh per annum as Senior Solution Advisor in Deloitte and 19.5 lakh per annum as Manager in Protiviti. Please advice me on how to take decision whether to move or stay back in PwC. Thanks in Advance.

Hello all, happy weekend. For an upcoming Engagement Manager RRK interview at GCP, wanted to ask if anyone who is there in Google or has any experience with the interview process can share some insights / Tips. Many thanks in advance. Google

Hi fishes, how to prepare for Faang and other product based companies as I tried last three months but could not crack even a single product based company's interview. what should be the approach and resources to work on, suggest I m planning to learn n try in next 2 yrs time. My experience 5.8 tech :java, ms, aws.

like

What is the apprpriate dress code for a Zoom interview?

like

Starting interview process with home depot, canada for Sr SAP ABAP developer role. Any experience, guidance or tips to share on how to prepare folks?

like

Additional Posts

what's your firm policy on expensing dinner?

like

Hi Karen, we learned that Laundry Service fired client Poppa John's bec. John Shattner used the N-word in a meeting w. the agency. This resulted in mass layoffs. How have you dealt w/ ethical dilemmas

likeupliftingsmart

If you asked a recruiter for an update on your offer status and they say they will have by Friday of next week (which happens to be today) would you follow up with an email today or on Monday?

Quit corporate life for good

like

Anyone has successfully been accepted for the Canada Federal Skilled Worker? Is the working requirement to be on the same occupation (same NOC code) in the last 3 years or can I claim that I have +3 yrs exp but sitting in different NOC?

like

I’m curious how other small and midsized firms are structured. Board of directors or executive leadership group? What types of officers and what do they do? Practice group leaders? A firm administrator? Firm development or marketing role? board size in proportion to number of partners etc. ?? We are about 25 attorneys but growing

like
like
like

Hello all! I need help! So I started working at a firm in NYC and live in NJ about 2 hours away from the office. I just started few months ago and been working from home. Continued below.

like

What are your annual billable hour expectations?

likehelpful

Considering a role with CVS Health at the Sr. Advisor level. Does anyone have any insight into compensation at this level? I’m expecting an offer soon and would like to know for negotiations.

like

After spending 2 years at a BigLaw firm (which were preceded by 7 years at a midsize firm and 4 years at small firms) I am considering a move to an in-house role at a late stage start-up. Is it time to make such a move considering how long I have been working at law firms or too soon to leave my BigLaw firm, as I have only been working there for 2 years? And if I were to leave, how would I explain such a move to my current employer?

like

F 🐠 (or men who use it): Did Secret Clinical Strength stop working for anyone? No so much in sweat but odor 😬 If so, what did you switch too? I would love to try something more natural but they don’t work well for me. Plus I get really bad reactions to baking soda, which many of the more natural ones have. So bad I had to see a doctor last time. PLEASE HELP

like

Wondering what Slalom Consultants are making here on Fishbowl. Care to share?

like

Career options after Product Marketing Management?

funny

What is the most legendary way you’ve ever seen someone quit or get fired?

like

What comp should I expect for Google S&O Lead in London? 7 YOE, top MBA, 1 year at MBB

likefunny

Hi Can anyone give me brief idea about Hirevue interview. What type of questions ask, Is it easy to crack or it simple HR question based or include python sql questions also. Anyone have any idea please help.

like

I’ve talked with some Asian friends who are also in big 4 and we all agree that we don’t know to talk or bs like Americans. Who’s with me?

like

I had a interview in Mindtree on 5th Jun 2021 and on 7th June they told me that i have been selected and will soon roll out the offer and after that i got "Your Selection Process" email from mindtree careers and after that i have received any communication from then and today when i checked the status of my application its changed to "Parked". Can someone explain what does that mean? I have tried calling and sent an email to HR multiple times but got no response. Can someone suggest what should

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