What’re some good excel formulas to use in a case study to validate excel skills? Have sumifs, can’t really use index(match) here, have countif, then just traditional addition/subtraction

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

Conditional formatting, pivot tables, v lookups

That's a pretty broad question and could use more context on expertise level/type of case study. But if it's a basic analysis case and you're allowed to use excel, you'll usually be fine with pivots and your preferred lookup (xlookup or index match). Just hope that your data is clean and numerical, but probably good to pick up LEFT, LEN etc for cleaning up strings just in case

Don't over think it, make it easy for them to follow the calculation and output, as well as making sure it's correct.

Related Posts

Urgent!!
I currently have a offer letter- 15.5 CTC (fixed)( profile- security Researcher)
Cleared all interviews of another company and they are asking “expected ctc” . How much should I ask??( profile- threat researcher)
Current ctc - 8.5 lpa ( profile- risk & compliance)
Basically I am changing my profile.

like

Bummed an interview case study. I was given 15mins. Is it over?

like

Is Any one recently given interview in Cognizant (within 2 week)

like

Has anyone ever been ghosted by a recruiter after they send you on multiple interviews?? Multiple follow up emails and texts. Nothing! It’s so frustrating

like

Hi guys,
I havent discussed anything about sign-on bonus with the hr during interview.

My joining is on Jul-18.

Will they give sign-on bonus, if i ask now.

Actually what is the criteria they will consider cor sign-on bonus. I'm new to these things.. Kindly suggest.

like

Do thank you notes even help? I usually thank them at the end of the interview so it seems a bit too extra to send another email.

likesmart

Hi folks, what rank/ grade shall I expect for a 11+ exp. My interview is scheduled for next week.

I am already having an offer of 36 Lakh fixed from wells fargo.

I am a generalist/project manager.

like

Currently an account person at a creative agency interviewing for a brand marketing role at a tech company. What questions should i make sure to prepare for/have an answer to?

like
like

I am interviewing for an agency and they haven't extended any offers but want me to provide them with all sorts of documents. Is this sus or am I just overtly wary?

like

Recently had an interview for an accounting role. Haven’t got the real offer yet but I’ve received a recruiting questionnaire and a comp call invite. Is this the call to negotiate salary before extending an offer? I’m afraid if I negotiate they’ll rescind the potential offer since I haven’t got solid word from them yet...

like

Hi.. I am working in TCS as a BA (Third party payroll) , recently my team has started the process of bringing me on-board TCS permanently ?
Is there going to be an interview for the onboarding ??

Hi all,

What all is asked in data science interview?

Hi fishes, i am working as a .net developer role in Publicis sapient had 1.7 YOE with 8 LPA CTC and
I gave an interview for TCS on Nov 3rd 2022 but still no response, whether rejected or selected.
Filled TCS application with exp CTC: 9.5 LPA
Concerend about TCS can't give exp CTC Shall i move on by other company interviews or wait.
A bit scared of recission a head so need some secure job for 1 year 😇
Please help me and suggest fishes thanks in advance.

Hey folks,

Instead of quiet quitting, I decided just to quit my job! No backup role, only savings.
Toxic culture, poor work-life balance, terrible leadership, it was just a mess. But I can't say this in interviews.

Any advice on how I can talk about my experience positively as I look for new opportunities? The reality is it wasnt a good fit, so I chose my mental health and decided to bet on myself, but somehow, it seems this is not a good enough response.

likeuplifting

Hi everyone,

I recently gave interview for SAP labs india , cleared all the rounds and got the call from HR for salary discussion, everything was agreed and HR said I will be receiving proposal offer by the end of the day which I need to accept and after that they will be releasing offer letter , it's been almost a week since the call , HR is not picking up and I haven't recieved any mail yet . I am quite tensed and anxiety is creeping in . Can anyone help me with reason why it is taking time ?

like

Hello Fishes,
My brother is a b.com graduate(2020 passed out) and looking for a job.
The problem here is because Finance jobs requires exceptional skills and academics due to which he is not able to get shortlisted for most job interview screening, he is receiving interview calls from great companies but not able to convert them.
If anybody can help even with an Internship position at their firm that would be a great starter to his career.

PS: leave a like so that I can send Dms across✌

like

Hi Guys. I have a second round interview with the Director of Marketing and an IT Business Analyst. This is for a web designer position. Already answered all basic interview questions in the first round. What can I expect?

Last month I was interviewed at Nagarro. I got the offer but I rejected and did not join. Sent the mail to recruiter.

A week ago I received a gift pack courier from Nagarro. What to do? Return or Keep since they didn't ask to return. 😅😄

Nagarro

Hi - I am a career pivot from higher education into tech and have final round interviews for a DEI Coordinator role (which I'm super excited for). I am meeting with three people that I would be partnering with for the job and it was shared with me that these interviews will mainly be behavioral as well as questions on my technical skills. Does anyone have any resources to help me prepare for this? Anything is greatly appreciated!

like

More Posts

like

Hey All,

Please help guide me with below confusion:
My Tech Mahindra Hyderabad salary is 35 lakhs and my wife's salary is 10 lakhs.

I am getting an onsite offer for Sydney, Australia with AUD 95,000.

Will this amount be sufficient for a good lifestyle like we mantain in India?

My wife is an Android developer and how feasible will it be for her to get a job and what would be the pay like for her on dependent visa.

We both have around 9 years of experience

like

Any advice on networking to find a new role? I've worked in the same place for so long and I'm not sure how to get started.

like

How is Paysafe Group? I've been selected there in SD. Is it a good company to switch from ZS Associates?

Hi fishes,
I’m working for ZS as a contractor since 4 months , Associate level.
Received an offer from INFOSYS . Details below:
Designation: Senior Associate Consultant
Grade : 4A
YOE: 3.2
Current CTC: 10 lpa
Offered CTC : 14.5 (including 10% variable) + 1lakh joining bonus

Is it worth it? How are hikes and appraisals at Infosys, because i know it’s good at my current company . What should i do?

like

Long one - one of my best friends (10+ years) and I had a drink last week, I told her of my recent ADHD diagnosis and how we had noticed the generational trend (my mum & grandad as very similar symptoms wise and they acknowledge this, but not diagnosed). The friend mentioned her therapist has suggested she may had ADHD (inattentive type) - she then told me a few things like how she's absolutely neurotypical and she's never associated herself with neurodiversity etc, she made a ... Tbc

How does one get into underwriting in the western MA area? I have an associates degree in business and 5 years of insurance experience. I just can’t seem to find a company near me to apply for an underwriting entry level position. I’d rather not start in claims and work my way into underwriting but that’s my only thought process. Thanks in advance!

like

Is Discover project good in Capgemini.? I have been given a role of ADC software developer.? Please give me some inputs.

like

Relatively new, just curious - how often do you make mistakes, and how do you recover? I’m finding that I have a ton of anxious about making mistakes, and lately, a ton of anxiety in general. Does it

like

I started dating this guy some months before covid struck.. he was literally crazy about me. He even stayed in Hyderabad for months just so that we could meet once before he went on to stay with his family. After that it had been a real roller coaster. He pampered me a lot before and now he hardly talks. We both have switched to different companies (earlier were in the same) and now he works 6 days a week. Sleeps or Vists his relatives or works on Sundays. Sometimes I feel he no longer loves me.

like

Any female fish willing to give some advice?

like

By when can we get to know our hike percentage after manager shares rating?

like

If we go back into another shut down, what do you feel will happen in our industry with employment? Will jobs be even harder to get? Will more people be let go?

like

Are there UK firms hiring right now or more likely to give tier 2 visas? I'm a US citizen w/ 4 years experience at Deloitte, UK uni & hoping to stay (exempt from res labor market test)

BY or EY India which one to join? In terms of wlb growth job security.EY EY India Blue Yonder

Hi,
Is this group active from EXL side? Few queries are posted over 2 weeks but hardy even 1 is answered. Wondering if there is any other bowl for EXL. 😐

Anyone here from IBM software labs? Is it service based or Product based company? How's the work life balance, job security and yearly hike? Please help me.

like

Does anyone know the 5 digit code needed to link an accenture 401k with Mint?

like

I get so much satisfaction making more than my Partner. He thinks it's hot too.

like

Additional Posts in Consulting Exit Opportunities

like

i think i’ve hit my limit. i cried three times and nearly puked out of stress today. i don’t think consulting is for me. anyone have a referral for me for a non consulting role? please.

likefunnyhelpful

Disappointed being ghosted after completing a take home exercise that took ~10 hours 😥

like

How fast does Oliver Wyman get back to you for first round interviews?

like

Anyone working for a social impact consulting firm (e.g. Bridgespan)? Could you give us some info on your experience?

like

Anyone have experience with Disney? Specifically, their Developer Platform Engineering teams and Streaming Data Platform?

like

Is there any job out there (in the US) that pays ~$300k and only demands 50-60 hours per week? Asking for a friend.

like

Coming from consulting where you did cases to get in, do you all prep for case interviews or just assume you got it? Asking bc I did not do well on one recently but didn’t prep—super rusty

like

I had a recruiter phone screen two days ago. I just realized I completely forgot to send a thank you note afterwards. Is it still worth sending at this point ?

like

Should a resume include a summary section on the top?

like

For a balance of WLB and great total comp, where should I exit to? Product management or business strategy & ops at FAANG/big tech?

like

Wonder if people make exits into entities such as WHO, World Bank, IMF, etc. Anyone knows what the path is?

like

Anyone in need of someone with leadership, analytics, reporting, scrum master, and project manager skills? Almost 20 yrs experience in operations space with financial industry knowledge. Open to all exit opportunities. Need a new challenge. DM me if you’d like to discuss or refer me. Thanks!

like

Any views on StratOps in BFSI vs Tech? Have an offer from a large global FS company but I'm more inclined to Tech because I think the subject matter is more interesting and the people may be nicer + work / hours less intense. But, I just got rejected by my main tech exit opp today (final round), and I'm not keen on starting from scratch with the job search. Plus the FS Co may offer a stable, long term global career path. Would appreciate any perspectives here.

like

We all have stories of being ghosted by company after an interview. Does anyone want to share a story of ghosting an employer after a job offer has been made? Apparently this behavior is on the rise.

likesmart

Approached by recruiter from PwC last week for a new opening. I decided to go ahead and start the application process. Have a first call with the recruiter- what kind of questions should I expect?

How do US companies background check international experience in China?

likefunny

Recently had onsite with amazon and got rejected. Recruiter said I cannot apply for roles for one year. Any ideas how to apply for different roles and get considered for interview?

Anyone familiar with the Chief of Staff role? What YOE would it be most relevant for? Would it be considered a good exit for a strategy consultant aiming for senior management?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

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

Messaging rates may apply

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