How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Do people think working remotely will remove some gender bias in the work place? Or impact people’s perceptions of women colleagues?

How do you recommend finding recruiters who specialize in a particular geographic area? (Tampa Bay specifically)

Hi! Any art directors or creative directors open to giving some feedback via DM on my portfolio? I have mostly in-house experience, and could use guidance on what I might do to get in with agency work and more branding.

What are the main factors folks are considering as they make a decision? Solely ranking, money, just curious! Got into two T20 that are very different but see myself at both.

I’m thinking about moving up to a high school English position from 8th grade English. Mainly I’m looking for a change. Any thoughts on the differences I’d be facing?

I have high school children of my own, but disciplining high schoolers has always intimidated me for some reason. I have excellent classroom management, but I feel like high schoolers are a little smarter ab getting around rules and less worried about consequences.

I’m told by an hs tchr that the grading load is ab the same.

Many people say our services are terrible. Without first hand seeing the ppl do our services (unlike consulting) Is there anyone that can give more insight into how our services actually level up and compete against the big 4? Is it just me or does Optiv need to be more like the big4 and change it’s model around to be more like a big4 consulting firm?

Currently at BNY Mellon with 10 YOE, specifically in Corporate Trust working CLO/CDO’s (first job out of college). I’ve moved around within the bank a few times but I’m just not happy here nor am I where I want to be in terms of comp . I want to pivot into something else but I have no clue what skills I could transfer elsewhere as what we do is so niche. They sucked me in when they said it would be a FA role but we don’t do any modeling, forecasting, etc.. Any advice/suggest/rec’s much apprecia

Citiustech guys having icici bank salary account.

Is your salary credited???

Do you see an increase in ER visits during the holidays? If so why? What is the weirdest story that you are willing to share?

Does anyone know what a fair salary is for a digital production artist in SF with between 3 and 5 years of experience? Appreciate any input

I’m tired of being mocked for being fat.. I feel helpless and like crap.. 😭

What HealthTech companies would you recommend to people looking to move out of consulting and have 5+ years of experience? Preferably those that can file for work authorization

Are you comfortable going to a restaurant with outdoor dining? Why or why not?

Is there any medical fitness certificate needed before joining Capgemini or any such recent rules?

Hi Fishes, Welcome to the data engineering Hive. Since we are growing it will be great if we can start with a brief introduction with this this thread. Mine is as follows

Company :- Harman international
YOE :- 6
tech :- AWS, Spark, Hadoop, airflow , Kafka , python , informatica, oracle, plsql ,sql

Which firms are offering to sponsor MBAs for top performers these days? I know my firm doesn't, MBB and Deloitte S&O does, and I've heard rumors of Huron doing it.

Who am I missing?

Hi guys,
Got offer my Tiger analytics for the role of data engineer. How good company is tiger and team member are supportive or not?
What is wlb and does they fire employee as this is my first switch.

Anyone want to grab a drink?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

How do I compare two sheets to make sure they are identical?

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

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

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.

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.

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.

Would anyone be willing to teach me vlookup?

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)

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?

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

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)

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!

How long did it take you to become good at excel? Like fast?