Does anyone have a link to an Excel Assessment test?

Has anyone ever been to the Alo Restaurant? I have never been there myself but I was wondering if this would be a good setting to propose?

Do you count internships towards your years of experience? I did 20 months all together interning but not sure if that moves my needle from mid to senior when job hunting.

This time last year, I was making 70k without bonus potential. Tomorrow, I am putting in my notice and I will be making 110k with potential bonuses. Remember to take care of you.

Trying to find a video example of where a person stays in the same place in the frame but a new scene is revealed by a wipe or mask. So it’s the same person but their wardrobe and set will change around them. TIA

Lawyers who began full-time work during or shortly before the pandemic...how connected do you feel to your workplace? Have you found mentors? What would you like to see change or improve as we move forward in hybrid and/or fully remote environments?

Does EY pays semi-monthly or bi-weekly?

Does anyone have any experience with General Motor’s HireVue process?

So I finished my 3rd interview with a company and the TA specialist said they loved me but can’t meet me at my bottom line salary, however, I said I can negotiate and she said she’s going to speak with the decision makers and see if they’re okay with that. What does this mean? This is for a marketing specialist role. I’m asking for $70K bottom line

36mm Rolex explorer on a 7.5 inch wrist? Thoughts?

Are Kuroni Tokyo Chronograph watches any good / worth the price? Any owners here?

Favorite editor(s) in Chi?

Deloitte scatterplots: Whats the point of rpm & check ins if you get great feedback with no improvements and end up JUST above (4,4)? Looks like most people are better than that. I feel like shit.

Reasons why a company is delaying / not scheduling your interview after they said you receive an invite shortly?

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

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

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?

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)

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?

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!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

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!

Would anyone be willing to teach me vlookup?

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

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.

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

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?

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?