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

Looking for advice on prioritizing money over career growth. I am 29 on a big team making $120K. The day-to-day is cool, but I don’t see much career growth. I have interviewed for other jobs but can’t find anything that pays as well. Should I just stay where I am for the money?

like

If I was told that upper management was really interested in interviewing and that they would be reaching out soon - when should I reach out? They told me Monday morning and I haven’t heard back since

I want to get out of ID so badly. I don’t mind the work but the hours are just killing me. I just started at a new firm less than 6 months ago and I am already desperate to get out. It is not the firm or the people. I just hate the high billables. I have been applying to other jobs but I think I may need a recruiter for help. Any recommendation for a great recruiter in NYC?

like

Best way to prepare for A&M interview / case studies for the PEPI CFO Advisory group? Heard case would be about the three F/S, which I understand from accounting perspective but wondering if I need to know anything specific. Thank you!

like

Anyone working or know about the company ‘TietoEvry’. A friend of mine got an interview call and wanted to know about company culture and pay range etc.

like

Anybody got their TB test done at Delhi, Max Medicenter Lajpat Nagar? What all documents did you get after completing the test?

Did anyone else not have an observer in the HBS interview this year? I was really thrown by that.

like

Can some body give knowledge about L2 round for wipro, java domain 7 years of experience.

like

Guys if you don't feel jealous then can anyone share the definition of coding questions which are being asked for reactjs developer assessment exam in these days ??

funny

How’s the axtria compensation? The HR reached out saying we can’t pay more than 30% in hike but I wouldn’t agree on that. Just wanted to know if they’ll repent after interviews or is it a hard and fast rule?

like

What's the hiring process like for a littler case smart attorney? Is it easier to get a case smart position compared to an associate position? Not that I want to be an associate there, but just trying to see if I have a solid chance.

like

Has anyone bought/ done the HRCI Certificate in Diversity and Inclusion in HR Management? I already have my PHR, but I’m looking to gain more knowledge/skills and beef up my resume. Is it worth doing? The course is $239 and you get 12 Recert credits with it.

like

I already got a job offer in Singapore and had submitted all the docs required to HR. My question would be how long is the EP's processing time? And what are the chances to have my EP application rejected? I have 4 years of experience at my current firm, is that too little?
Tyia

like

Can you share the resources or sites like leetcode to help prepare for interviews for 11 yoe experienced ui developer?

My brother recently graduated high school and wants to work for a year or two before he starts his undergrad. What sort of jobs should he be looking for that could help his resume in the future? He eventually wants to pursue engineering

like

Interviewing for an SE position and have my final demo in a few weeks. Any trailhead modules I should check out to get more prepared/confident? Thank you in advance!

Workday I’m a QA Automation Analyst with 2 yoe. I gave my tech interview for Workday and cleared it on Tuesday. I’m currently holding an offer of 15.1 from a bank. How much can I ask from workday?
Tech stack. - Selenium,Java,Jenkins,Salesforce automation.

like

First gen immigrant getting case of impostor syndrome/nerves with upcoming BCG interview. Any folks want to share advice that might help? Would really appreciate it; thanks :)

like

Hi, I’m interviewing for Laboratory supervisor positions at ARUP in the Salt Lake City, UT area. I have less than 2 years supervisor experience and I would like to negotiate if I get any offers. What are other people experiences/ salaries in same positions? Thanks!

like

I’m thinking of applying for a sales role at Salesforce, but there are so many roles that meet my experience. I don’t want to apply for a bunch of positions, and no one is replying to me for a conversation on LinkedIn. Would anyone here be willing to give me some advice/guidance?

like

More Posts

My vet told me my dog is pretending to throw up so I can give him extra attention… I can’t believe he trained me to give him attention 😂😂😂😂😂

funnylike
like

Hello everyone! I don't know if this is the place to ask, but I'm looking for a referral at The Trevor Project. If anyone would be willing to help, I'd greatly appreciate it!

like

Hi everyone! I suck at doing board meeting minutes! Any tips on being successful at them? I’m using the recorded meeting to take the minutes.

like

Hi, I got an offer from Axtria for senior manager role, what amount should I quote there, I am having 13 years of experience in data architecture.
My current is 25 L/a

like
like

How is the job security at Delta Air Lines ?
Do they layoff frequently?

HR had mentioned there were no layoffs at tech during the pandemic.

like

Is it mandatory to pass Barclays GSC test after completing people screening and joining after 2 weeks? I got the email now.

like

Has anyone ever gone out to the W Hotel on Capitol Hill? Is it like a bar/club? Do you recommend it?

like

Does anyone know how to join a sports league in the Arlington or dc area? I’m a amateur so I don’t know if that would be looked down upon

like

FIS is giving retention bonus to particular employees. Fortunately I'm selected. They are giving 1.5 lakh and requested me to stay for next one year 😂

like

Thoughts about Digitas Health?

like

Heyy Fishers,

I am looking for an opportunity in the Consulting Field and keeping an open mind as I am too keen to work on projects and solve problems.

I have 8 months experience in strategic and risk role in banking and want to expand my domain knowledge of other industries

If anyone can refer me it would be greatful!!

like

Hey Fishes.
EY GDS is looking for candidates with 5+ experience in OT/CS (SCADA/ADMS/OMS/DERMS/AMI
If any one interested I can refer
Please ping me separately @

like

Can anyone refer to positions in marketing, business development, or project management job opportunities?.

like

Hello people of San Diego! Would love to hear how y’all are affording to live here comfortably. Please state your company, position, TC, YOE, and do you have a side hustle? I’ll start - I’m an advisor in Wealth Management with TC of $70k, 3 YOE and no side hustle. Among other things, rent just jumped from $2500 to $3700 for 2 bedroom and areas were looking at. I’d like to “make it” here but if it means switching career to make money I’d like to get an idea to make the right job change.

like

I don't understand how come QAs with 6-8 YOE are getting 40+ package. Are those fishbowl discussions real?

like

While accepting offer in Wipro my friend directly clicked accept and submitted after reading all the pages. But didn't fill the signature and date column in all sheet since text was not enabled. At bottom of every page in offer letter it shows as signed by user name ,user email address & date when she signed. Could anyone please confirm if this is fine or not ? Do we need to fill signature and date also above because she couldn't do anything now. Is this offer letter valid now?

Post Photo
like

For the past few months of interviewing have made it to the final round with a few firms, and the feedback is similar, ‘I’m a great candidate, but it’s not the right time’ Is this code for something? Am I missing something?

like

Additional Posts in Finance

What is the value in professional certifications? ACCA, CFA, CIPD, etc.

like

I am currently finishing up CFP course work. Does anyone have tips or tricks for studying for the actual exam? I am particularly concerned about the investment planning section. I have 12 plus years in the industry and CRPC. I do planning literally everyday but a test is a test and this is the module I have had the most trouble with.

like

When your analyst pings you with a text at 2am about the model they're working on: "Done!"

like

I am investing as a beginner. What is a good company to start a brokerage account with ? Fidelity, Ameri E Trade, ML? I’m looking to put my money in index funds.

like

Best self-help books on the market? I've been consistently unhappy lately. Something needs to change.

like

MD: "Why the fuck does he have to stay home and watch the kids? If your wife works at a nonprofit, you definitely make more than her."

like

My boss’ boss wants to catch up on how things are going; I changed groups 6M ago for a more fast-paced environment but have only partially gotten the transaction/networking exp I wanted - any advice?

like

When you build an excel model that is so fire you want to show it off...but it's private af

like

Ezoo this weekend any youngins??

like

I'm thinking about starting something, but I want to be well versed in entrepreneurship before I do. Any recommended resources (websites, podcasts, books, etc.)? Thanks!

like

Does anyone have any insights on the Certificate Investment Performance Measurement (CIPM)?

like

Analysts who continuously complain are the bain of my existence. Shape up or shape out.

like

Most expensive expensed dinner?

like

Khaleesi is coming to Westeros!!!

like

What's a controversial opinion you have?
Just state it as you think and don't insult anyone.

like

fishbowl has invited me for there ambassador program, anyone else gets this as well?👶🏻

like

Roth vs Traditional 401k, thoughts?

like

What's your favorite industry to work a deal and why?

like

Trap, trap money Jamie
JP got me in my feelings
Gotta close deals wit it

like

When traveling does anyone else struggle to get motivated to use the gym and eat healthy? How do you over come this?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
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

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

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

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal