Does anybody know if power query can slow down a workbook? I know it can slow it down while it is refreshing. But can it affect it while it is latent? The query I have is fairly complex compared to my other queries. I've considered possibly adding some of these steps in to the source SQL, but I haven't necessarily identified a need to do that...yet ..lol The workbook size is just over 500 kb (don't remember if it was Kb or kb though haha...the size is small)

Hi, does anyone know when an employee becomes eligible for maternity/paternity leave at either Gilead, BMS, or Merck? For NVS, it’s day 1 of employment but not sure if that’s common within the industry.

In one month is my mid term review.. Should I let my mentor know I'm applying for mba this year now or should I wait till after the review session? I'm afraid mentioning going to b school would hurt my "fast promotion". What's your guy's experience? :)

In my offer letter, nothing is mentioned about variable pay, but the recruiter had mentioned to me about 0-12% variable. Am I missing anything. Do they have any variable component in the salary or not.

Hi fishes!

I am seeing too many post about awards like rising star, Kudos, etc. People keep telling there managers recommended them for these awards.
My manager doesn't interact much with us. I consider myself as some one who has worked hard for project and other intiatives. Should I ask my manager to consider me and if yes how should I initiate it.
Part of MC team.

Thank you.

Looking to open a taxable brokerage after maxing out Roth and 401k. It’s more so for a house down payment in 5-7 years. Can someone please provide insights on ETFs vs mutual funds?

Hey new members,
If you have joined recently, please be active by posting your views or questions so that we can grow this bowl

What do most people invest in for their Roth IRA portfolio? I’ve heard target funds and ETF’s..which one is better?

I have resigned from EY GDS on the e-exit portal a few days back. What are the next steps that I need to do.
Also, when will I get a mail to submit my assets and for any other formalities.

Just got an offer for a Cyber manager role in Deloitte based out of Toronto. Transferring from US as M2. HR setup time to talk salary expectations. Any feedback on salary range for cyber Ms in Toronto?

Hi folks ,
Can anyone let me know of all projects in AC Blr follow 2-11 timing ? I have got an offer from them.

Any advice for a first time manager ?
Context: after ~10y in technical then marketing role, taking over a team of analysts, first management position.
Tips, readings, stories, … are welcome 😁

Which city would you recommend for single men in late 20s trying to find good opportunities in career & dating? Leaning more towards to NYC but not planning to live in Manhattan due to the high rent so I am not sure that would be okay. Also don't want to drive that much.

Hi can someone refer me for data management roles?

I was recently offered a Zoom interview. The school had 10 interview slots for me to choose from. Three were one day this week and the rest are next week. I chose the first time slot available. Should I have waited until one of the last slots so I was fresher on their mind when choosing a candidate? I am just sitting here stressing out until I here something. Also, do interviewers still appreciate a hand written thank you for the interview?

Mac or HP or Dell: I prefer Mac notebooks. However it seems there might be limitations with the use of Skype or other applications based on materials I have seen. What do you all recommend is the best laptop for working at Deloitte?

Hi Fishes,

What is Difference between SAP Labs and SAP India Pvt Ltd.

For SAP Consultant which will be best suited organization?

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

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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.

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

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

How do you fix microsoft excel cannot paste data error?

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.

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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

Still don't have xlookup. #fomo

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’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...