I’m a big fan of Power Query for cleaning up messy datasets—removing duplicates, splitting columns, and even combining multiple files in a folder with just a few clicks.
What’s the most complex cleanup you’ve tackled with Power Query?

Anyone working at a PE firm as a data scientist? Got a recruiter who reached out to me and looking to talk to others to get a lay of the land.

Does anyone know if insight has kicked off?

For those who are established, what steps did you take to ensure consistent growth? One thing that has always deterred me is how often businesses fail. I'm looking for an exit opportunity and have been considering building my own thing for a while. Thanks!!

How much as per current market,we can get for 8 yeo in to .net full stack development .net with angular.
Cctc 15.3 + 2.3 so 17.6
I wanted to know how much fixed i can get ?

Any Property Management recs in Seattle area? :(

Hi everyone, best project to be a product owner in Nagarro? Please reach out 1-o-1 if required. I have recently joined as a PO , APC with a hope of doing good legit work.

Any help is extremely appreciated 🙏🏻

Haha it's a mix of product management, project management, product development, consulting work, technical stuff, analytical stuff. Literally anything the project needs to succeed haha

Anyone experienced cognitive symptoms or brain fog associated with Covid?

Anyone have a friend or family member suffer from liver damage / failure? Not sure how or what to do to help someone with the problem.

As an IT infrastructure i have been tagged un cognizant internal project to support the cognizant owned datacenters VMs and infrastructure.

Can anyone please tell me how is that project in terms of Career growth and learning??

Anyone who plays badminton or squash casually here?

Reading cafes near Lakeview/Lincoln park? I have a light work day tomorrow…

Got an offer from a startup for 19.5LPA.
Its base is 15L, and I'll be getting 124800 in-hand.

I have 3.5 yoe in typescript/react/NEXTjs fullstack. Out of which only 10 months are on a full time role, rest of time was freelancing.
I am also an open source contributor for some NEXTjs related tooling.

Is this a good offer?

Which company to join 10Years Experience , Netcracker or TCS??CTC is all fixed in Netcracker and 3Lkh more.

Have you quit your job after getting a verbal offer but before receiving a written offer?

how do we get out?! i’ve been doing office work in a grocery store for too long… this was supposed to help me transition out of hospitality but it feels like i’m going to be stuck in a grocery store for the rest of my career
i guess i just need to voice my frustrations. it’s not that i hate my job or the field, i don’t. i’m just feeling extremely overwhelmed and discouraged i think. does anyone really, truly enjoy what they do in retail/hospitality?? needing some positivity

Dressing guidelines for Barclays please. Joining in couple of days and physical joining.

Looking out for job change. I have an overall experience of 7.5 yrs in market research, consulting and advisory services.. Preferred location will be Pune and Mumbai..Please let me know in case of any relevant openings.

Thanks

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.

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?

How do you fix microsoft excel cannot paste data error?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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?

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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

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

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

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

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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.

Would anyone be willing to teach me vlookup?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?