I've been asked to make a testing issue tracker. The challenge is that there's a many-to-many relationship between test cases & issues (i.e. a case would be impacted by multiple issues, & an issue can impact multiple cases).

I was planning to solve this with Excel's Power Pivot tool so I could put multiple tables into a single data model, but my company's on MacBooks (and won't allow Basecamp Windows OS) and Mac's Excel doesn't have this.

How can I solve? I'm open to any tools, not just Excel.

Any recommendations for learning Mulesoft? I used it a bit a few years ago, but I don't remember much. How much has it changed since being bought by SF?

Looking for a Legal Recruiter or Recruiting Firm. Young Associate with Healthcare/Health Law Experience.

I'm currently in a consulting manager role internal to a well regarded pharma company. However, i have been contacted about a role at IQVIA for a new pure strategy internal group that they are standing up. It would be a 55% salary boost with director title and completely remote. Should I consider it? The salary increase and location flexibility are alluring.

What is the appetite for tax policies consultancy in North America?

Got offer and accepted but other firm that I applied ask for additional interview. Please advisd how to tell them "no" nicely ?

I need a referral for devops engineer role. 3.5 yoe
1 month remaining of notice period.
Location preference is delhi ncr.
Not getting calls these days

Did you use admissions consultants? Who was it and was he/she worth it? Advice on selecting one?

What should be the Salary ask be for Sr. Consultant @ EY India Tech Risk practise?
Relevant YOE - 5 years.

Switching to PWC. Is this a good move? 30% hike. Currently in tech consulting(big4) to Risk Consulting- DnA (PWC). Yoe-3yrs Cctc-10lpa Pwc EY KPMG Deloitte PwC How is risk consulting in Pwc

Could you please confirm if there is cab facility for Shollinganallur office,since I will have to WFO for 3 days in a week


Also,if cab is available,can you please share the charges for the same.

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

Does your firm regularly adjust rates? I read an article suggesting it should happen annually. Curious how regularly firms adjust attorney rates.

AITA? If my SO of 1 year wants to get a dog, do I get an opinion? We don’t live together

Can someone tell me what AI consultants are earning at Deloitte? I am interviewing for the same and wish to know a range?

Hi folks,


I have been assigned to one client project.... During a client interview they have asked qns in my relevant technology but after getting into the project they put me in different tech... Which I have never worked at before...
That project is short term and they are asking to complete the development within 2 weeks and I am the only one resource... I told my tech skills to my pm... He said no other resources is available to replace you.... What should I do now....

Any A&M folks here? Wondering how benefits / 401k compare to Big 4

Any referal for 2 year, security engineer in global logic??

Would like some opinions about how likely it is to make product analytics self serve by PMs? Anybody have success here? Or is it hopeless to think that product managers can pull their own data, look at their own dashboards, and do basic data tasks themselves?

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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)

How do you fix microsoft excel cannot paste data error?

Still don't have xlookup. #fomo

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?

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)

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

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

Would anyone be willing to teach me vlookup?

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

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

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

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

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?