I love Excel but man… when a file takes forever to open, I start questioning all my life choices. Has anyone figured out a good way to keep files lean when they get huge?

Hello fishes, what should be the right salary range for 9.5 yoe in development. Technology is Python and Java. Amazon Newco Larsen & Toubro Infotech IBM Tech Mahindra

Any one in HPE? I recently got an offer (~60lpa, 13 YOE) the variable pay/RSU etc seems to be on the lower side compared to the industry. No joining bonus too. Any one who can offer insights on feasible payranges/ yearly hike trends etc?

Hi DI folks, how were the hikes last year??

Barack is in the Waldorf Astoria!

What are the chances of getting a lower offer because you're POC applying at a fairly large law firm? Not big law or anything but still. Friend and I both got offers, came out of the same school and have very similar internship experience. He's white and I'm not, his offer is significantly higher. How low is low enough to walk away?

Anyone interested in joining my newly launched angel investment network? It’s entirely free and takes less than a minute to sign up. Comment below and I will DM you! Thanks!

How often does your organization give raises?

I’m (early30s) about 8 months into a relationship with a 40m. Things are wonderful in every aspect, but he is absolutely atrocious with his finances. I felt it becoming an issue about two months ago. He forgets about auto payments and just generally doesn’t care. I sat down with him and looked at everything and even after talking it out he still continues to stress and it’s now causing me stress. I had a final discussion with him today about it and he went on abt how love isn’t enough for me…

Still shaking my head at the CDC's corrected guidance on hydroxychloroquine. When will they get it together??

As everybody tells u will get more offers during the last one month of notice.

My scenario is i have decent offer but i dont like to join there because of location issue and im looking for jobs in new tech where i have less exp.

Considering this even though if i have less knowlege and if i perform a decent interview process will i get offers at the last moment?Is the offers during the late notice is given based on as he can join early even his performance is average during interview. Pls share

I haven’t been feeling confident in my work and it’s stressing me the fuck out. How do you deal with this?

Hi guys, i working in a project from last 5 months and didn't like the project and team.
Can i ask for a project change??? Is there any minimum time i need to spend as per thoughtwork policy?

Is Gilt a good place to buy a pre-owned vintage Rolex ($3-5K range)?

Have zero data experience. Best way to start self learning?

To all my data engineering friends out there, do you all feel like trash sometimes? Like people dont understand shit about what you do, and clients just want to see some bs ml model/pretty but useless dashboards?

Hey , i want to know the transport facility in cognizant Gurgaon as i am not getting proper information from HR for Day shift role. Can someone please help. Its an urgent request.

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 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!

Any book recommendations on excel modeling for real world business applications?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to