What is the What-If Analysis in Excel? Is it important for me to know?

Current student looking for advice. I interned at RBC Wealth Management last summer and currently have 2 offers for summer 2023 that require a decision next week: 1 for BASF (chemical manufacturing) and 1 for Peraton (defense technology); I am also waiting to hear back from SMBC (S&T), Point72, Lord Abbett, Boeing, and Shell. I hope to break into IB next summer, and I’m interested in the Natural Resources, Industrials, and Real Estate industry groups. Any advice on what to do? Thanks!

Best eye doctor in west La? Cigna if that matters

How long does it take for H1b transfer to get approved on premium processing? Anyone went through this recently?

In tcs for salesforce certification how to get the voucher for certification?

Morning! Being laid off sux, I been down this road 5x in my career it never bets easier.

Dust off contacts and make your rounds
* if you’re in a good position to take time off do some, seems we all need a mental break anyway

Does studying for Gmat/applying to business school count as a valid reason to take a sabbatical at D?

Which would you rather do, take the Friday off before a long weekend, or the Tuesday off immediately after the long weekend?

Can anyone pls guide me how to prepare for az204 certification?🙏🙏

How long does it take to prep for a McKinsey interview for BA role? I've been told 2 months but isn't that too much? I had a heads up that I will be receiving a call later this week to plan an interview, and I feel like I will have limited time to prep.

How do companies get categorized when it comes to CC companies (i.e. shopping, dining, travel, etc)? For example, I made a few payments to a travel company but Chase isn’t marking it as travel and therefore I’m receiving less points than I thought I would. Anyone have insight on this?

Anyone familiar with Covid Supplemental Paid Sick Leave in CA? Does having planned time off nullify a full time employee’s ability to use the C19 sick leave if they become sick just prior to the planned time off? (I’ve only been able to find references to eligibility being based off of hours work preceding C19 sick leave - nothing about planned time off)

Anyone feel frustrated at times with the super aggressive sales personalities we deal with? My AE is always pushing on every ask no matter how minuscule it is. My vp is super anal about anything we do. I understand these guys pull in huge commissions and bonuses that’s why they are so motivated. However what I personally feel is they just nag us until we do the job according to their spec. Just venting……anyone else feel the same?

Guys don’t be discouraged as tcs will definitely onboard you just keep patience , until and unless if u are fake

Gift ideas for my mid-50s dad? Looking to spend in the lower hundreds

Tips for fixing index match when it’s working for most lookups but some are returning NA despite being in the list?

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

Hey guys, did you ever encounter the following problem & know a solution:
Whenever I reference another tab in any given formula in my model, XLS first calculates everything as it should be. However directly afterwards (or sometimes only after saving) the formula vanishes and only the resulting value is left. Hence, all automation etc in the xls does not work.

Any ideas what's happening and how I can solve it without rebuilding the whole model?

Excel noob here. Can anyone help me write a formula where if a range (column) contains a particular value, then return a value in a different column of that same row into a cell?

Would you rather use Excel versus CRM to store data and manage records? If so, why?

why is index match superior to vlookup?

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

I have a date I need to match to an array of strings (that represents dates). Eg matching 6 nov 20 to (20201106, 20201107, etc. ). I can convert my date into this format using text(date,”yyyymmdd”) but then my lookup tried to match “20201106” with that list and the “ causes a mismatch. Any hints, and I would prefer not to change the array format?

Out of curiosity, what percent of your work/analyses are Excel based? And what other softwares do you use the most (Tableau, PowerBI, Alteryx, etc.)

My work has been 90% Excel based 10% Access/SQL based and friends at other firms seem to be using way more advanced programs.

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

This isn’t exactly an excel question, but is there a way to clear the “last modified by” history on an excel document in SharePoint? Accidentally opened a file i shouldn’t have.

How can I pull the text before a certain set of characters?