OK one of you hackers/geniuses knows this….how do you unprotect a sheet if you don’t know the password?

How does everyone explain their jobs to their in-laws? I need an explain it like I'm five explanation on my role and fintech in general for my family gatherings

What a typical % base bump from M to SM at Big 4 FS consulting?

Anyone go to product from data science? Any thoughts on your transition?

Hi there!
For any legal tech buddies out there, started a bowl! Surprised to see one didn't exist!

Please spread, join and interact. Happy Monday! 😁

How is the current market for moving to another consulting firm? Currently at a T3 and was thinking about trying for MBB or T2 next year

Would it be hard to get a exp associate role in advisory at a B4 as someone with about 10 months in audit at EY, 7 months experience in corporate accounting at a F300 and CPA? Hated my time at the F300 but had thought the grass would be greener in industry. I’m starting a financial analyst position at a major hospital system in my area soon and want to stick with that for a couple years before making a transition but was curious if I just don’t have the right experience for a role in advisory.

How much do professional, high-earning (300k+) people put down as down payment for their first home / condo in Manhattan? 20% seems pretty high given the median prices, but looks like thats standard

Buying a Cathay Pacific Economy flight, am AA Platinum, can I use AA miles to upgrade my CX flight?

All my investment is in real estate - 1 primary and 2 rental. Total 3.7 M value and 1.7 mortgage pending. About 400k in cash. I’ve 0 RRSP. Is my investment strategy terrible?

Is there any requirement for Senior Software Engineer?
I am looking for a job change.

Fishes , list down the good and bads of BNY mellon chennai

Can anyone please refer me for the role of SAP ABAP developer.
Yoe - 6.3

What industries is the CFE certification used for? How does it compare to CPA in the length of the material and difficulty? Do most firms pay for It?

What was the most memorable pro bono project you've worked on?

Before taking resignation they were saying will get letter in 2 days max, now Delay in offer letter even after more than month from the day I took my resignation back.

Any suggestions will be much appreciated.

How often do you respond to emails from law students who want to learn about your firm/practice area? I get like a dozen requests right around OCI every year. Frankly I’m tired of speaking to them and answering the same boring questions, especially if I know they have a low GPA and no chance of summering at my firm, but I do feel bad saying no/ignoring them

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

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

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

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

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

Would anyone be willing to teach me vlookup?

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

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

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.

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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 ninja tricks? Ones that few people know...

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 🙏