What’s the best way to compare lots of data with time stamps? I.e. you’re trying to evaluate the time different steps in a process take for multiple line items (10000 rows)

Current approach I’m doing is to subtract the times (in hh.mm.ss) from each other to get the duration of each step. Not sure if there’s an excel time stamp function that would make this easier. It’s not working well for times that were late PM and bleed into early next day AM.

Deloitte US just announced layoffs. Any other B4 started layoffs too ?

Any senior Mechanical design Engineer openings pls

Anyone know what a salary from a mid level creative should be or pushed for?

What website can you use to play simple games over zoom (Chinese checkers, chess, checkers)?

Hi,
I am working as Data Analyst. Now, I seen my interest towards Data Engineering.

Please help me to decide, Should I go with
Azure Data Engineer
Or
with Big Data Technology like Spark, Kafka, Hadoop, Sqoop, Airflow.

Suggest me some good course to start.

Thanks 😊

Hi all,
Can someone guide me on how should a person start learning for transition into a data engineering role at a beginner level. Currently I have known Python and SQL in my job. Not able to figure how to go forward?
Any advice would be great!!

Any recommendations on designer card wallet other than Gucci? Looking to buy one for my sister. I already have the Gucci leather card wallet and my sis is not a fan of Gucci. TIA!

What are the best websites you’ve used when applying for a new job? Any that are specific to saas/tech sales or ones that have yielded good response rates?

Some say perfect love doesn't exists.... but let me tell you that's because they never experienced it 🥰

Hey Fishes , Need your experts comment's here, May I know why Merck KGaA, life sciences banglore give offer letter on Sigma Adlrich letter head although all communication and email domains shows merck group.

Is anything wrong with tech Mahindra hiring after submission of documents and salary discussion they want to have again technical round..if they want to reject why they do it in early stage.almost 3 week of search time wasted.

How long due you need to be at an employer to be eligible for the family leave plan that is available for all Massachusetts employees as part of the Paid Family Medical Leave program ? I believe the PFML is applicable 2021 onwards

About to finish my first year. I’m a specialist. Only going to hit 65% of my hours (took a 4 week vacation cause of wedding/hm).

I never say no to work and i have fantastic reviews, and the head of my practice (with whom I work a lot for) has great things to say about me.

I’ve been fully utilized starting ~June, but first few months were slow. Am i fine?!

Anyone here who made the exit from Big 4/MBB consulting to a VC? If so, I’d love to hear about how the experience is so far. (Not to mention the WLB and comp!) I’m considering a career change but have no one in my network I can go to for insights. Thx! 🙏🏾

Best thrift store in DC area? Please don't mention the one in Falls Church. It's horrible.

That feeling when you’ve swiped your unlimited monthly metro card and it ends up being a busy month where you use public transit almost every day 😀

I am a traditional reservist so I never really used military benefits before, but could use advice here.

I am currently renting and my lease is not up until October 2021, however I found a good deal on a home and scheduled to close in June 2021.

My landlord will not work with me to end the lease early, so it looks like I will have to double up on rent and mortgage through the summer.

If I went on active duty orders, can I use those orders to break my lease early without penalty?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Any book recommendations on excel modeling for real world business applications?

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.

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.

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

Question for those of us that dabble across data science and not just excel. I want to get some good training on SQL. Anybody know the best certification program that has the best cache in the market?

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

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

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.

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

What would you consider "Advanced" or "Expert" level Excel usage?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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!

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!

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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