Why is the date format never what I need it to be? 😫

Mental health issues in our profession are finally being recognized. While mental health issues are not unique to lawyers, the profession and it's client service mantra present unique challenges.

If you’re reading this, go drink some water!

27 years M from suburbs Chicago looking to date

Brand new single post divorce. Was with ex almost 18 years and never dated as an adult. What the hell am I in for? 35f.

Any single men want to chat? 30/f

Got a 30% salary bump, via an offer for Senior Consultant S&O from Deloitte. Currently underpaid at EY Advisory. I'm MBA and this year is my promotion year at EY for Manager. What to do? Get demoted and move to D? Or counter at EY? Even if EY matches my salary, and promote me to Manager, I will be an EY Manager with a Deloitte SC salary, and probably won't be able to go to D in the future. What do you think? I have built up a good relationship with my Partner and SMs at EY though.

Hi guys, can someone please help me understand what does "Senior Consultant in HR Band 4" mean?

How do we get others to join Fishbowl? There are currently only 15 of us from the company and we have about 2000 employees now.

Anyone familiar with working for Kiavi/LendingHome? My experience is in private equity and structured products, I’ve been wanting to leave that and enter real estate for a while. They’re a self-proclaimed FinTech organization and I’m not at all familiar with that kind of structure for a company.

Does Oracle provide free fusion certification course to their employees?

Better for tech: Harvard MBA/MS joint degree or GSB MBA only

Anyone know of any non clinical PA positions or options?

Random partner asked a litigation-related question to a partner I frequently work with (i’m a transactional associate). My partner cc’d me and said for me to briefly look. Asked the library. They got me a great case. Sent it back. Now the random partner is asking for more cases in another circuit.

I haven’t done caselaw research since 1L and this isn’t even my practice… wtf do I do (I am fully utilized in my normal work and have a few deals closing soon…)

Were you drug tested as part of your federal district court clerkship background check?

Anybody else quiet quitting just until Christmas bonus time?

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?

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!

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Still don't have xlookup. #fomo

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?

Would anyone be willing to teach me vlookup?

How do you fix microsoft excel cannot paste data error?

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

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.

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)

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

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

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 change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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.