Unpopular opinion: VLOOKUP is overrated—once you try XLOOKUP, there’s no going back!

Senior Risk Consultant + CPA at big 4 (4 YOE) looking to break into IB with no Deals experience. Would appreciate any tips, tricks and resources for interview prep and beyond. I have an interview coming up with an MM bank in their Real Estate group. TIA

I can really use some direction. My background, I've worked 2 years in strategy and am currently coming off an exhausting year 2 in investment banking. I didn't particularly enjoy either role and am not interested in moving over to the buy-side or some monotonous FP&A role. Everybody says there's exit-ops aplenty, but I find myself with less options and even more picky than I did as an ambitious T2 undergrad student. Where do I go from here?

Question for more experienced bankers, when did you start to feel comptent at your job? For example, I am 5 months in and am still making small mistakes and getting corrected, feeling like I’m putting in the work and time but still miss things, thoughts on normal progression?

Anyone here know of a good 🏳️‍🌈 therapist?

Anyone here from Accenture Operations?
What is the avg hike % in Base Pay?
What is the avg Variable Pay out %?
Level 9 & 8.

Tiger Analytics has started firing their new joineers(freshers) as they don't have adequate projects. I don't know where the freshers will go as they haven't done any project as such.

This is just pathetic from organization. They are just firing people owing to failing a test of certification, for which other company gives 3 trials but they are giving only one try with negative markings

NYC based Managing Director, salary range?

Any big law associates high risk for COVID nervous about going back to the office even after you’re vaccinated? I just don’t see how a firm can require 100% of people to vaccinate so nervous about the people I’d be around

Working as a Senior Quality Lead (5.2) at PSL with 13.5 YOE , Is 17.4LPA a decent CTC or am I being underpaid as compared to others at same grade / similar Service Based companies?

I have a new employee that started last Monday, unfortunately it’s not going to work out. Long story, but we’re fairly certain the individual is using Meth and appears to have started/restarted fairly recently. I work with physicians, so it’s a consensus. We have to terminate employment, but what ethical obligation do we have? Two young children at home and no spouse. This is weighing heavily on us.

Hi,

Working as Business Analyst in VMware with 16.5LPA and having 7.6 YOE.

Am I getting under payed

Please suggest

Hi everyone!! Got an offer from Healthplix, Bangalore based start up. Any thoughts on this?

Is it mandatory for all TCS employees to WFO from November or any exemptions will be considered?

Best influencer search tools or strategies for sourcing?

I saw this townhouse in a prime location in my city for $350k (cheap for the area). The floors are all messed up though but the buyer said they’ll either lower the house price or give a credit for closing cost. There’s also a lot of nicks here and there (some locks missing from door, dents, scratches, stains, and some things are loose). But overall, the house’s architecture and design is so beautiful. Would it be worth it to get it and fix it up? Or find a newer house with less maintenance?

Which demat accounts can a Citi employee hold ?
Is only Kotak securities allowed ? Are there any exceptions ?

My joining date in axtria was 11th july.. but i got a mail today that it has been extended to 8th august. My notice period is going to end on 7th july. Is there anyone whose joining got extended?

Anyone felt their Wharton TBD went poorly (or average)? Hope I am not the only one who felt that way.

Koi batayega ye sensex ko kya ho rha hai? Paisa dalne k liye wait kar rha tha socha aur neeche jayega..aur upar ja rha hai.

How do I compare two sheets to make sure they are identical?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Best websites to get more of a handle on Excel as a beginner-intermediate?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

What are your top Excel ninja tricks? Ones that few people know...

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).