Anyone have any insight into the Project Management team at Leo? Cool people and/or work?

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?

What do R&D strategy focused solutions entail? Is the focus more on the efficacy of clinical trials?

I recently joined an agency after spending years at small non-agency design studios. Was hired in part for my non-agency perspective. Now I’m being thrown into new biz pitches (more below)

I think I’m potentially about to be fired this week in retaliation from my boss...what should I do?

Can you practice for leetcode without knowing how to code?

So… are any NJ/NYC people planning a meet up?! 👀

I've been working at my company just over a year and am still waiting on my 1 year review where a raise was to be discussed (other EA got raise at 1 year review and most raises happen at yearly reviews). However, company have just changed their policy to only review salaries in Jan (change came in after my year mark). I'm having a lot of trouble pinning my manager down for my annual review to even discuss my performance, let alone the raise. Feeling the undervalued (and now underpaid):

Recruiter for big tech company reached out on LinkedIn about a role. I asked about ballpark compensation numbers and they said they’re only comfortable sharing on a live call. Replied that I often receive LinkedIn offers for roles of paycuts around 30-50% so I want to make sure we’re in the same rough range. Recruiter again said she would only share via live call. Is this a red flag?

I’ve been in my current position (Bookkeeper) for 4 years now. I’m highly interested in taking the PHR, and I’m wondering if I would qualify for the 4 year HR professional job requirement to be eligible to test for the certificate. I work for a small business, therefore I do all the on boarding paperwork/payroll. Any advice is appreciated.

Last week joined in hcl. I got better opportunity in other company.If I abscand in hcl.does it any problem?still I have not assigned to any project , iam in Bench now?

I have 2.5 years of experience in Managed Services Operations. I am currently pursuing MBA - Distance Degree. I want to switch to Management Domain. I am really looking for referrals. Please suggest

Are there any books or other resources that mid levels/seniors/counsel/partners on here have found helpful for the project management / managing junior attorney aspects of your job?

I am not finding a lot of stuff written for lawyers specifically , but there is a lot directed at “managers” in business generally that I imagine could be applicable.

Hi sharks,
How to book cab for Capgemini return to office. Any app or portal?

#HomeOfficeSetup

Guys, Suggest a good external web cam for the office meetings?

only buy VIX if you think the market plumbing systems are clogged.

Otherwise your sinuses will become increasingly VIX allocated over time.

Maybe that's ok.

What’s the tea on TDH Chicago?

If the wife is the chief creative officer and the husband is a creative director within the same company, isn’t that a conflict of interest? Asking for ogilvy.

Leo loses Allstate to Droga. I know this was a long time coming, but it’s yet another big loss for Chicago.

Any insights on Laughlin Constable? Looks like they’re hiring in the creative department 👀

Anyone have any good contacts at ARC? I’ve been trying to get in with no response ( account management)

Thoughts on Mindshare Chicago?

Who’s the HOP @ Havas Chicago?

What’s strategy like at Digitas? Any scoop?

What does tronc (formerly Chicago Tribune Publishing) do, exactly? What’s the role of an ad copywriter there? They are vague on both the job posting and their website—but I’m also getting desperate.

Chicago media agency people - what’s your company’s current RTO policy?

I’ll start:

Spark - 2 days a week mandatory in office this year, 3 days mandatory in office next year.

What’s the scoop on DDB Chicago??!

How’s VMLY&R for Kraft Heinz?

Looking for insights about Symmetri. Anyone know about it from the inside? Seems like a nice, small agency, but would love more info, thanks!

Does anyone know who is running production out of Kohler up in WI?

Who is working on Walgreens pitch?

Ogilvy + WundermanThompson?
McGarry?
DDB? Energy BBDO?

Saw FCB is hiring. How is it there? Down to grab/coffee or a drink with anyone (preferably creatives) that works there! DM me.

Hi all!

Apologies in advance if this is the incorrect space for this - but my agency - Spark Foundry - is hiring at multiple levels within the analytics team. If you’re interested, private message me. A lot of growth here!

Does anybody know anything about working at Ulta’s HQ? Do people like it?

Any HR contact for FCB Chicago? Saw an Associate Producer position that I’m interested in applying to. Thanks in advance