Daily Quordle 161
6️⃣4️⃣
7️⃣5️⃣
quordle.com
⬜⬜⬜🟨🟩 ⬜⬜🟨⬜⬜
⬜⬜⬜⬜⬜ ⬜⬜⬜🟨⬜
🟨🟨⬜⬜⬜ 🟩⬜⬜⬜🟩
🟨⬜⬜⬜⬜ 🟩🟩🟩🟩🟩
🟨🟨⬜⬜🟨 ⬛⬛⬛⬛⬛
🟩🟩🟩🟩🟩 ⬛⬛⬛⬛⬛

🟨⬜🟨⬜⬜ ⬜🟨⬜⬜🟨
⬜⬜🟨⬜⬜ ⬜⬜⬜⬜⬜
🟨⬜⬜⬜⬜ ⬜🟩⬜⬜⬜
🟨🟨⬜⬜⬜ ⬜⬜⬜⬜⬜
⬜⬜⬜⬜⬜ 🟩🟩🟩🟩🟩
⬜⬜🟩⬜⬜ ⬛⬛⬛⬛⬛
🟩🟩🟩🟩🟩 ⬛⬛⬛⬛⬛

Any insight on Crowell & Moring (specifically the LA office)?

Looking for new opportunities.

Life changes have made it difficult to stay where I am right now (physically) and the uncertainty of the future is making me look for remote options specifically.

If anyone knows of anything, or have any suggestions, I'd really appreciate it.

Hello,

How is SAP practice in PWC. What kind of projects we can expect to work.
Also will it be support or implementation projects.
What are the work hours usually? Can we finish the work in the mornings and attend only calls in the evening to match the timezone? How flexible is it?

Thanks in advance.

We previously redid our bathrooms without a permit. We are now selling the house. Can we just say we are selling it as is or will we need to get everything permitted? Market seems to be slowing down a bit, but it still seems like people are waiving contingencies.

To those who are (or were) in-house: What aspect of the job do you dislike?

I’m an account supervisor at a healthcare communications firm making 90K. Is this typical? Im up for review in 2023 and want to know what salary expectations are like for the next level of account director

Went into the office today. The choice to come in was mine as the office is open but there’s no mandate.

Gotta admit, it was nice to have fast wifi, a crap ton of LaCroix I can drink (and take home), and just get out of my home office for a change.

Will I do this often? Doubt it. Is it a nice option to have should my wifi go out again? Yes it is.

Does anyone have suggestions for a talented DP who’s looking to get repped but having a hard time getting responses?

Thoughts on OpenSpace?

Does anyone live in Philly and work in New York? How’s the commute? How many days a week do you go into office? Do you take Amtrak? Or some other form of transportation?

Hi folks - anyone here know if EYP has a dedicated Sustainability / ESG consulting practice?

Is it just me or the ice cream truck music is the most annoying thing ever?
Trying to be on work meetings from my nyc apartment with this constant noise every afternoon...

Guys , Any possibility that LTI will not release offer letter after hr discussion. Seen many post saying they are waiting for the offer letter even few days left for LWD. Appreciate help on this. Larsen & Toubro Infotech Larsen & Toubro

PSA: Weil is telling potential clerk hires that clerks do not make good associates and routinely disappoint.

I like to pursue in the data science field. I have business Analyst experience but to switch to data science field could you guide me on what should I learn? Where should I start?

Thinking of switching to Bearing Point. What their reputation like in Middle East? Who are their top clients? What’s WLB like?

Hello Fishes,

Joining GDS as Analyst 3 from recently promoted to a consultant at Deloitte India. (Exactly same level of designation)
Tried to negotiate with HR about the designation to be upgraded to Ass. Consultant but they denied.
Feeling a bit weird moving in to analyst position. Please guide me.

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

I want to do a vlookup on 2 tabs, but identifier is slightly different in some cases (I.e. an space after or a dash in between 2 words that is not in one of the tabs). What’s the best solution?

Any macro experts that can help changing this 3 generation family tree generator to a 6 generation one (template link provided in comment below)? Provided by Microsoft but I have no idea how to edit this macro to allow more generations, and this is the easiest to generate template I've seen unfortunately

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yesterday I opened it and it’s just all hidden instead of grouped. Any ideas how to fix?

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

I’m having a recurring problem of my data sets being too large and the number of calculations I need to do being too many (workbooks become so sluggish that more time is spent waiting than cleansing/analyzing).
What’s the switch I need to make to accomplish my analysis without the lag? I’m already using .xlsb, manual calcs, single source of data, no volatile formulas, etc.

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

Is there an easy way to see a +/- 10% on all of my variables in a model? Is the easiest way just using a formula and creating separate columns to visualize it

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.

Is there any big advantage of using gsheets over excel?

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA