Having some trouble with vlookups and pivot tables. I haven't used them in a few years and I'm very rusty, but seems like most companies want that experience now. Help with this is much appreciated. Thanks in advance.

Science & Democracy... Thoughts?

What's the point of all this research if nobody ever reads it?

What’s a “science fact” that gets shared around that is very much not true?

Any tips on where to buy cotton that’s not from Xinjiang? It seems like all cotton comes from there ?

Have bad allergies and need to wear 100% cotton.

Hello All, my joining date needs to be extended by 5 days in JPMC and HR said in call that no revised offer letter based on new joining date will be issued and new joining date confirmation will be somewhat communicated prior to 3 days of onboarding.
However he mentioned he will reply back with a confirmation email on top of the email which I have sent requesting for revised joining date.
Do you see any risk of offer cancellation/revocation here?

How long does Oracle take to conduct second round of interview ? Is it communicated if we are rejected after first round ?

Does anyone have any experience working with FeverUp? I have a interview with them this week and I would love to hear about life within the company.

obligatory post: how will COVID impact human capital? The types of work we do, factors in making a healthy organization, etc.

What's the new age scene like in Austin? Coming from Portland and I'm missing my fellow mystics.

Any veterans here still serving in the Reserve? Drill Hall is a new bowl here.

Hi Folks,

I wanted to know about the work life balance at Bain and Company in the global people analytics department?
And what yearly appraisals one can expect?

Thanks

How is S&P Global?.
Pros and cons
Employee benefits and Culture

Thanks in Advance! 😊S&P Global

Hi Fishes,

Anyone from Commodities and Global Markets team? I have an offer from the same would like to know how is the Work like balance and overall team?

Any leads will be helpful.
Thanks in advance

Hi, Can you please help me with Goldman Sachs interview questions

Hi All,

I joined HCL in july 2021 & completed one year in july 2022. Currently I am serving notice period and my last working day is December 7th. I resigned in September month
So when I will get my variable pay of last year as my performance cycle is still not closed.

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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

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 🙏

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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)?

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Would anyone be willing to teach me vlookup?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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.

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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!

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.