What's the simplest Excel solution that someone has come to you for?

Hi all,
I'm a Software Engineer with 14 months of work experience. I want to move on to Product Management as my current job doesn't align with my long term career aspirations. I'm pretty confident in the tech aspects of my job and am undergoing a course in Business Foundations.
Any suggestions on what career steps I should take?

Anyone else here have terrible utilization because their deals die and a code never opens? /can’t find another code to book hours? I’m sitting on over 200 billable hours at this point

Any Salesforce developer working with Deloitte India here ?

Please DM me

I applied for a job at Visa and was contacted the same day. A few days later I had a 30-minute screening interview with the hiring manager. I knew I was very early in the process since the job had only been posted for a few days. It's been 3 weeks and I haven't heard back, even after reaching out to the recruiter. Have I been ghosted or is there still hope? Does anyone at Visa have insights? Looks like there are a ton of jobs posted so maybe they are just backed up?

Currently an analyst-level consultant working with a client that has an investment banking division. Since I have access to internal systems, could I reach out to bankers for networking from within using those systems? Or would that be too aggressive? lol

I joined Tiger Analytics 1 month back as Analytics Consultant but still have not been allocated to any project. How long does it generally take to get allocated ?

When you recruiters say at the end of a 15 min call.
“I will get back to you by the end of this week” does that really mean “your not right for this position”? Because this whole thing is a waste of time. I’ve did these calls with 3 recruiters and is yet to hear back from someone. Today would be the 4th recruiter that I’ve spoken to. Does this practice annoy you guys just as much as it does us? My dream career is to be a technical recruiter but this whole thing is discouraging.

Can a person on H1B in US work in Canada as WFH? Any work authorization needed?

Will basically continue working for US employer but wondering if possible to spend long amounts of time in Canada. (Have tourist visa)

Planning on leaving after this busy season. Finding it hard to have motivation, while also having to work more hours than ever before. Advice?

Does biglaw give out swag bags to lateral hires working remotely?

Looking for a referral to Bain Capital and other firms.
Interested in a sustainability/ESG role.
Have extensive industry experience including with an ESG ratings provider and working with portfolio companies on assessing ESG risks and building reporting pathways with respect to multiple disclosure frameworks.

Does anyone know how much base compensation is at a tech company that’s more video game related? Product counsel interview coming up at a company called MacroHard if you catch my drift cough cough. 4 YOE, big law.

Does anyone know if sites like Forbes or Inc. are accepting freelance article submissions right now?

Does anyone in the forum run a distillery business? I am looking to start a bourbon business. Would consider buying an existing business. Would you contract distill or build your own?

Favorite classic or modern whiskey cocktail, and why? Need to practice and want to impress

I got an offer from Infosys. My manager says they will retain me by providing the same offer what I got in Infosys, i have put my resignation and my manager is calling me on weekly basis and saying that he is talking with senior leadership. Will TCS retain me? Suggestions please. I heard TCS has stopped allocating funds for retaintion is that true?

Still don't have xlookup. #fomo

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

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

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)

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.

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

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

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.

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?

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

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

Would anyone be willing to teach me vlookup?

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?

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 easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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.

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!