Does anyone else find it frustrating when co-workers find out that you’re good at Excel, they feel the need to ask you how to do EVERYTHING, how to data sort, how to use basic functions and try to pawn off work to you because “your proficient in Excel so you’ll get the job done faster??”
I didn’t mind helping at first, I’ve started telling them to start googling it or saying “I’m not sure how to use SUMIF 🙃”

3/31 Thread (General):

what is NP in Axtria?

Are there any good 30s spots that are montage-y? My CD keeps wanting to do multiple scenes and I don’t think I’ve ever seen it done well for a 30.

Hi Folks, help me understand - is payment merchant services and barclays card 2 different accounts or same?

Who here is down in crypto and is in dire need of some moon action? Mind sharing how much?

Had a off week/made a bunch of mistakes. Know the creatives are annoyed. Feel like months of dedication & great work went down the drain so quickly. Feeling defeated. Our job really sucks sometimes.

Anyone sell CDP’s?

Hello folks,
I am looking for referral
role : Salesforce developer
YOe : 1 yr 10 months

How much JPMC pay for an 14 years experience in automation testing? And how is the WLB ?

I wanted to ask a genuine question. Is it harder to actively pursue your dreams in LA today versus 30-40 years ago? If so, why do you think this is?And I’m talking pursuing your dreams with very little finances and no deep connections. No sort of nepotism. Lmk what you all think. Also feel free to share your path to LA stories.

What are the top companies you would like to move to? Assume the role / team fits with you perfectly and the comp doubles what your currently making.

I am currently looking for a mentor and not sure the best way to approach finding one. Any advice?

Any open scientist positions in Florida ? TIA

Just had a partner pull every matter we were working on together. I feel like any day is going to be the day they kick me out the door.

Should I feel affended when I get put on freelance jobs because they need a "female art director" specifically?

My company is receiving backlash for…let’s say a poor decision that has gone viral in my city. For 3 days, almost everyone who has called customer support is just looking to insult and yell at us. This isn’t our fault :/

Hey - does anyone have any good recruitment process templates or websites they recommend that are free? I need it for prompting key stakeholders for tasks/approvals and next steps. I’ve been using a google sheet doc w/ comments but I was hoping to find something automated or more comprehensive

Currently in the offer stage at BAH. Has anyone had luck negotiating a higher salary to decline medical benefits? What is everyone seeing for sign-on bonuses for Associate/SA level positions? Booz Allen Hamilton

How do you make defined name ranges stay the same when the source is changed in power query? I’ve been really struggling.


I have a model with many defined name ranges in it that are referenced throughout. Each named range is set to be 250 rows long that way it works as long as the data set has less than 250 responses. However, when I switch the data source in PQ, it inexplicably shortens all my named ranges by around 4-6 rows (for example, one that was $B$3:$B$252 becomes $B$3:$B$246). Help?

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

Has anyone had any success here with recording a macro to set up a pivot table? For context, I am just looking to run a pivot and then run the macro and have it show the pivot table completed with the right fields in columns, rows, and values and then also formatted how I want. I tried to just record doing the setup of the macro, but I got an error message when trying to rerun.

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

I have an idea- unsure about the execution...

I have an Excel worksheet which has a table of items, i.e., a stock count of items available.

Is there a way to link this table to Microsoft forms/sharepoint whereby someone can request an 'x' amount of stock from this summary table and whatever the requestor asks for, once approved, is automatically deducted from the table of figures and the corresponding items

I appreciate that there is a lot of automation in the above. Would welcome any advice

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

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

Looking to expand my Excel skills by learning Power Query/Power Pivot & VBA & then expand my learning towards certain programming languages (not Excel related).

I currently have access to LinkedIn Learning, but curious about Udemy and Coursera. I know about the differences between them, but content-wise, anyone have a better experience with one over the other out of three? Other recommendations?

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

Can anyone provide a reference to how to efficiently create and link an excel spreadsheet into a ppt (and make it dynamic). Thanks in advance!

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

Does EY’s version of excel have Xlookup? I don’t see it

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.

So i have a list of companies in a list (column A), and a “Y” next to them (column B) if i want to include them in my dataset.
Is there any way i can make a variable list, ie below the full dataset, of just the companies with “Y”, and it being dynamic?
Can post a screenshot tomorrow if useful to explain

Is there a way to wrap your header text within access database?

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?