How often do folks here use boolean logic with sum product to move information around? Wondering what are the common use cases for modelling/data analysis, or if it's worth getting familiar?

Anyone like the classic dive watches? Rolex, Omega etc. Ever use them diving? I’ve never really been into watches (tho I have an iWatch for running), but recently started to really appreciate them. If not practical, iconic.

How is SAP practice in LTI... Do we have ample implementation projects?

Will the learning be good and how about firm culture , onsite opportunities?

How do you deal with a boss that wants you to quit and is becoming increasingly more abusive. But you haven’t found a job yet and need this job financially.

What’s the hiring market like in Texas for a 4th year investment management associate? I’m interested in Austin but understand there may be more opportunities in Houston or Dallas. Graduated with honors and on law review at a T14, if that helps at all.

I’m looking for change management roles in the Middle East. Any recommendations for companies I should consider?

Need to recommend a hotel to my family who's visiting from the USA in a couple of weeks. They like to stay in local boutique type places and BnBs, not chains. Any suggestions?

Cons of moving 75% of my savings to an Intermediate US Treasury ETF (SCHR)? I wouldn’t mind losing 4-5% if the market rallies, but would rather put cash to work if the market keeps tanking

Have a 2/15 call on ghiv. Tanking today, drop it?

Uh this could get bad fast if this holds through open. Protect your downside if not already.

Hi guys, I need 11 like for DM

Let go from PwC Energy/Commodity Advisory after being there for many years. Looking for opportunities. Like to chat with firms.

Hello everyone!
Is anyone willing to connect on opennings for associates, preferably on strategy work in your offices?
Also if there is anyone working on ACN strategy & consulting, I found an openning a couple of days ago and would love to have a chat and hear more about your experience and type of projects.
TIA!

Can anyone provide a referral to Microsoft?

Any guys in LA?

How long does it take to prepare a job description? I left EY for a position in the industry and my firm ended up using EY Law.... anyway, it’s been 4.5 months since we kicked off the process and EY Law has been sitting on job description. Any thoughts?

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?

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)

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

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.

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.

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

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.

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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!

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

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

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 🙏

Would anyone be willing to teach me vlookup?

Still don't have xlookup. #fomo

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”

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭