I have a case/ excel interview with a revenue Cycle team soon. What is the best way to prepare for it?

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

For my company: formatting, basic column calculations, IF statements, v lookup, and maybe an index match. I’m an Excel case grader

like

Sumifs are probably good to learn too. Complete it like you would be ok sending it to a client (e.g. correct data and formatted to look nice)

like

No problem!

This is great the only things I don’t think I’m familiar with are index matches, and if statements. I’ll see what I can find on YouTube on them. Thank you!!

like

Pivots and vlookup

like

Mind sharing what firm?

like

Guidehouse

like

Related Posts

Trump’s interview with a TV station in Grand Rapids Michigan. Meanwhile, in the real world - 130k news cases and 1600 deaths in 48hrs.

Therapeutics he is likely referring to would cost Americans millions of dollars, and there is little evidence that they would be effective against COVID.

Post Photo
likefunny

How to prepare for a real estate investiny case study / memo interview? Apparently the case is light on financial modeling. Thanks!!

like

Is it possible to leave as a B4 audit senior to a senior financial analyst at a fortune 100 company? If so are there any specific things to highlight on a resume to stand out?

like
like

Brand Strategy VP-SVP- Aspiring SVP Our client, a Manhattan pharmaceutical digital advertising agency is looking for a VP or SVP Brand Strategy... Experience working on a brand w. multiple indications in oncology space (ideally) & actively working on approx. $7 mil. revenue.
1st. interviews will be internal/work remote
Candidate will be asked to present to the agency, then to client. The salary range is $165 to $210++ negotiable Contact us for job description.
Stay Safe
Nicole

like

Have second phone screen with hiring manager. Any advice on what to expect or tips?

like

Tips for sussing out how demanding an in-house role will be during the interview process? I’m a hard worker and motivated but if I’m taking a large pay cut to go in house I want to try to be sure I’m getting an equivalent increase in work-life balance, and stories of in-house often being just as much of a grind as biglaw scare me.

like

Hello,

I just completed an initial phone interview with HR from 
HSBC

It's for the Corporate Banking Manager - ISB - Commercial Banking associate position. What are the next steps of the interview? Is there any behavior or technical assessments? What are the possible salary ranges? Thank you HSBC HSBC

On June 21, I had an interview with two managers to become an HR Coordinator. Everything went smoothly, and I got good feedback, so I moved on to the management round of interviews. The recruiter initially stated that I would go through two rounds; however, between June 22-June 23, there were really five rounds, and I am still awaiting the scheduling of one more interview, even though it is now July. I'm becoming frustrated at this point. I’m still actively interviewing with other companies.

like

I’m looking to change careers from CMA to Project coordinating/program managing. Any recommendations on how to increase my interview intake and/or how much I should be asking for?
Anything helps!! I appreciate it.

like
like

If you are working with a recruiter, what is a reasonable amount of time to wait after the recruiter applies to a position(s) for you before you start to question things? I know this depends on firm response time - just curious how long I should be waiting before I ask what’s up.

like

Credit Suisse (Pune) usually takes how many rounds of interview?

How are they paying for a 11+ yrs experienced candidate ?Can I expect 40 LPA? .
CTC is 23 LPA
How will be the interview rounds

like

Hi fishes,
How much time does HR takes to get back after L2 technomanagerial round in Coforge??.
Also what package can I expect for 2.6 yrs of exp for the role of Technical Analyst?

like

Hi Fishes, Can someone tell me how much time will IBM take to release the offer letter after all the discussion? I've cleared all the rounds of interviews and done with the salary discussion.

Anyone have experience interviewing for corporate finance positions at a bank? Have a 1st round interview and wondering if they do cases or pull up excel models and have you break it down, etc.

like

Hi Fishes,

I have given my interview in HCL and cleared 1 TP, 1 hcl manager & Client TP and Client Manager rounds .
In initial screening HR told the generic statement of 30-40% and I have given my ask as 50% minimum. After clearing the rounds I heard from the project team that Client has given great feedback and wanted to take me in .
What is the % I can ask in HR Discussion and will they reject in HR if I ask more now .
I have 9.5 years total experience and role is Storage Architect.
Thanks

like

Hi Fishes, I have seven years of pre-sales experience in market risk analytics and investment management products. I am now looking to get into finance product management space and have an interview lined up for ESG Product Manager. Can someone please guide me on how to prepare and crack this? It's a dream come true role for me.

Any advice for preparing for KPMG Tech - Deal Execution - Integration and Separation competency/ technical interview. Thanks

like

More Posts

Can anyone help me with job referral
YOE:3
Skill:storage developer,python,c,Linux
Need a referral for switch

like

Any tips for the McKinsey Problem Solving game?

like

Can a non-US citizen lawyer practice cannabis/marijuana law? Is it advisable considering the non-US citizen lawyer would have to prove good moral character when he wants to become a US citizen?

I struggle to maintain an active voice in my research papers. Is Grammarly the best option for picking up passive voice and offering corrections?

like

Has anyone made the switch from agency to editorial? how did you do it?

like

Welcome to the Criminal Defense Attorneys Bowl. We hope you will ask question, share your stories about things happening in your practices, current events, cutting edge cases, and practice tips.

Any advice for healthier eating, or eating in general, when dealing with a particularly stressful time? I struggle with inflammatory stomach issues as it is, and the stress has been piling up and making it much worse lately - I’m either nauseous or have no appetite (or both). Decided to take the time to make one of my favourite (healthy and vegetarian) meals tonight and it was just not appealing at all 🥲 I don’t think I’ve had a proper meal in a week and I feel terrible.

like

What’s the ranking of big 4 consulting firms for mba placement?

like

♥️ 𝑺𝑨𝑷 𝑺𝒖𝒄𝒄𝒆𝒔𝒔𝑭𝒂𝒄𝒕𝒐𝒓𝒔!

#SAP #HXM

Post Photo
like

How easy is it to sublet or Airbnb your nyc apartment?

like

I found out a colleague who is the same rank/group/office as me has a 15k higher salary... Isn't that pretty ridiculous?

like

I was interviewed for a major tech player in the hospitality industry, had 2 interviews which for the first one the recruiter was late, and didn't confirm the interview while I emaild her to make sure I do have an interview. When she attended she said that there was no point of responding my email as we are meeting anyway. Later on I had 2nd interview with the hiring manager. After 45 minutes she said they will let me know...

2 months later and I am still waiting...

like

Hi All, does Clarivate Analytics is a BPO/KPO/ Product based Or service based company?

Is contributing to an HSA better than a taxable brokerage in CA?
(where HSA contributions and gains are not protected from state tax)

Or only superior if I avoid taxes in HSA via Treasury notes/IBonds?

like

Is anyone interested in taking over the lease for a top floor 3 bed 2 bath, 1500 SQ ft apartment in a newly built complex in Plaza Midwood? The lease runs through Sept 2023. It's one of the nicest complexes in the city, has close proximity to Uptown, and has excellent amenities (e.g. CrossFit style gym, two pools, dog park, on site complimentary cafe, etc.). My unit has an ideal layout for work from home and a huge patio.

Edit: $3,196/mo including valet trash pickup ($35) and pest control ($4)

like

Thoughts on Bay Area biotech TC? 7 YOE. What's currently market for base, bonus and equity?

like

Hie fishes
I recently joined nagarro
I am under one project code but not assigned to any project
Is that means I am in bench or project
Is that count for bench period

like

Offers in Finance Transformation with Deloitte VS PI- Finance with EY, SC level, almost the same pay n benefits. Thoughts on which one to pursue? Thanks 🙏

like

43 YO, is Botox my only hope for eye wrinkles and is it too late to try Botox?
Is there better makeup/concealer I could be using?
I already have a pretty extensive skin care routine with retinol and other anti-aging compounds. Have recently started taking collagen.

Post Photo
likehelpful

Additional Posts in Healthcare Consultants

Currently on an F-1 visa & wondering if any of the firms are hiring foreign students. In the last 6 months, during interviews, I’ve been told I can’t be moved to the next step cuz of my visa status.

What do strategy positions within health systems do? e.g. director of strategy...I work in HC strategy now and am curious how similar the roles/responsibilities are.

like

Is anyone aware of any healthcare / healthcare consulting companies based in the Bristol area (UK)? Thanks

Guidehouse 🐠 on the healthcare team: What is the salary range for a Senior Associate? Ive looked online and it seems it can range anywhere from base $ 97,000 - 107? Any insights? Thanks

Best consulting companies for Healthcare related projects ?

Anyone know how to connect with someone on EY's Smart Health team?

(Heads up, I can't tell who "reacts" to the post, so I welcome any advice in the comments.)

like

Anyone from Merck how strict are you on YOE requirements?

like

Consultants/brokers, when you seek to buy a license for a healthcare analytics platform, what do you look for most? Which companies do you trust most and which do you trust least based on experience? I am new to the industry and trying to wrap my head around everything.

like

Anyone from McKinsey’s Healthcare practice that would be willing to chat? Not looking for a referral per say, just interested in the work that goes on in the provider space. Many thanks in advance.

likehelpful

Is lead position in Cigna/Evernorth equivalent to Sr. Mgr? How is the Hierarchy looks like from this position onwards ? Cigna Evernorth

like

I am new to Deloitte. My background is in agile transformation and product management within provider settings. I have found tech projects, but none within healthcare. Any advice for finding these?

likehelpful

What types of projects does Strategy&’s PLS do?

like

Does anyone have insight into how strong BCG’s healthcare practice is? Thinking more payer/provider than life sciences or med tech

like

We’re considering adding wearables tracking to pull in health metrics for a wellness app. Let’s say we plan on doing iOS only and one approach is only doing apple health integration, while another is to use a 3rd party aggregator like Validic or Humanapi to integrate once and get access to Fitbit, Oura, WearOS, and tons of other wearables. Which route would you suggest?

Working at Cerner Corporation for a little over a year in the Integrated Tech Consulting organization. Realized how underpaid I am vs. others (even new hires), and am looking for an exit opportunity. Any advice or companies that are hiring right now?

like

Over 12 years of experience in Healthcare vía administration, any ideas or suggestions to transitioning over to becoming a consultant?

like

When interviewing - is there a way to respectfully decline a take home case study that doesn't automatically result in disqualification from the candidate pool?

like

Has anyone had experience with/heard of people moving from consulting to work in public health? I’m not sure how my consulting skills would be viewed. (2 years in consulting, public health undergrad)

like

Anybody here earn an MBA with healthcare focus? Looking to apply in a few years and want to speak to you about your experience :)

Hi everyone! Health tech consultant with 2.5+ years of experience … Looking to connect with any one who’s company is hiring implementation or strategic consultants in this field… ready to leave current company after not feeling heard and/or valued for months now. Looking to increase salary and *hopefully* find unlimited PTO wherever I go

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