This article has me thinking about all the repetitive formulas I use. LAMBDA could save so much time, especially when working with similar datasets across multiple sheets. Do any of you have custom functions you use on the regular?

What does a good earned media strategy look like to you?

I need contacts who are into bank instrument and MT103 transfers within USA and Europe. If you are a good sender or receiver let me know.

6 $28 strike PTON calls expiring friday. Premiums crazy cheap, i think it goes up regardless of what we see. If cases surge its more incentive for home fitness, if not, could lift with the market

Pregnant with my second and I have no will to work. I use to be passionate about my work, but now I m forcing myself to complete the bare minimum tasks needed from me. Not taking any proactive assignments.

Has anyone else felt similar during pregnancy or postpartum?

Has anybody stopped paying Canadian CPA dues and let their membership lapse? I'm working in the US and I recently got my US CPA. I can't think of any good reason to keep paying these high annual dues, from what I can tell I'm not getting anything from being a Canadian CPA. Any advice?

Who’s the best sound designer in NY

I am interviewing @ Stripe for PM role and they have a written assignment. Do any of you insiders have any tips to share?? I have heard they use Basecamp's shaping method. Are there any examples of what they expect? Appreciate your help!

Looking for a producer for helping me to scope a branding (traditional+digital) and digital experience (mainly UI look and feel) project. Will need help with creating timelines as well. Would appreciate hearing from people with experience on these areas.

Bowl etiquette questions for all you early joiners of the Bitcoin bowl (options in thread). Would love feedback.

I JUST LANDED A PHONE INTERVIEW WITH GOOGLE!!! can I get some google phone interview tips, advice, etc.? (Forever grateful) 🙏🏾

Tip for anyone taking the CAIA exam, get UpperMark. Was using willey and was abt 1/2 complete and borrowed a friends test bank … night and day much harder and honestly was more like what I expected

Hi folks,
Need a small help. Can anyone please tell what is the C1 level in Capgemini and what is the median salary package for the post?

Hey fam! I’m looking for mentors high and low and trying to find good platforms for mentor matching. (e.g. I used to be a part of NYC’s Women Who Create until I moved abroad) Anything good you know of? Or, perhaps, if you’re interested in mentoring/being mentored, say hey below.

Anyone stuck in an unhappy marriage? How do you deal with loneliness of this profession and complicated family life

How much difference does have a LinkedIn profile pic have vs not having it?

Is it difficult landing an in-house position as only a second year corporate associate in big law? I know some people who went in-house straight out of law school and some who had no transactional background but went in-house after just a year of practice. Not having that same luck on my end.

Hello everyone,

I would like to know that how long it will take to generate the offer letter on workday portal?

Hello! I’d like to share an experience and hopefully receive guidance.

I spent two years as an executive, and while I was providing what I believe was impactful work, and receiving praises across the board, I got fired from one day to the other without any explanation.

After a few weeks, some managers (who were under me) shared that there had been a while campaign raised against me for a couple of months by others VPs and shareholders. 1/2

I am going to speak with a recruiter at Houlihan Lokey TMT in LA. I would like to know more about the group and its culture. Would love to connect and network🙏

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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

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

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?

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.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Would anyone be willing to teach me vlookup?

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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.

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?

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

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

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?

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