I was interviewing with a private equity focus consulting firm but failed the mode test. They asked all kinds of matching functions. What functions do I need to know in order to excel?

Hey Fishes, What is the salary band range for a DevOps Engineer with 2 years of experience?

Hows wlb and projects of HCL Singapore?

Just recently got into consulting after 5 years in industry as an Electrical Engineer but looking for firms that do more energy and infrastructure modernization work. Any firms really known for this?

Can we extend the joining date in sap labs because relieving date and joining date is overlapping on 22nd August 2022

How long would you say it takes to adjust to a new job?

I’ve just been invited to speak on a panel (industry event). I’ve never done this before. What’s the best way to prepare? All advice welcome!

If there were a tele-coaching platform that connected you to coaches to navigate the work environment (eg, managing up/down, dealing with client pressures, professional development), would you use it?

The service providers would all be former lawyers or have extensive experience working with lawyers.

I have mostly digital and earned work in my portfolio, but recently worked on a product-forward TVC. Not the most groundbreaking, but feel like TVC experience would help round out my book. Worth adding?

Recently received 30k and wondering what to do with it. Not yet a homeowner but also not sure if we’re ready to buy anyways. Have a young baby. Any advice on how to figure out best use?

How do you start waking up early? Always been a night owl and sleep around 1. Wake up at 8/8:30 right before work starts.
I need to start waking up early to get into workout /yoga and meditation routine. I tried today and kept snoozing my alarm for 2 hours.
Weekend is way worse when I sleep around 3 wake up around 10/11

Best self-help books on the market? I've been consistently unhappy lately. Something needs to change.

Typical prices for wedding photography in a high cost of living city? (San Francisco) 2 photographers, 8 hours, no travel. Much appreciated! ❤️

45 M Bay Area . Divorced any female 🐠 in Bay Area here?

Hello, Looking for Senior Consultant/ Lead advisory role. Having 6+ experience in Information security. Certification in CISA, CISM and AWS CCP

Anyone here given Wissen first round java interview? Suggest some tips and questions. LOOKS LIKE TOUGH ASSESSMENT ON VIDEO CALL. YEO 3+

One of my friend is looking for cyber security profile. He's having 5 years of experience in network security domain. He's currently working in one IT company. Please let me know any opportunity for him.

I have 2 to 3 weeks to prep for a case interview. Never did one before. What can/should I do prep over next 2 weeks considering I only have weekends to prep?

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)

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

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

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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?

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.

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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)

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?

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

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

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

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.