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?

What is the salary for senior manufacturing buyer in North Carolina?

Markets in red🔻 Good day to invest?
Current portfolio down by 7%
What is the ideal number of funds to invest in if monthly budget for SIP is 40K?

Hi All,

I have received an offer from Bank of America as Assistant Manager on 14Lpa fixed and TCG digital for 17.5Lpa (5% variable) for Data Engineering role. Kindly suggest which one shall I go with? Also how are appraisals/hikes and bonus in BOFA? Could someone please help?

How can you get a job as a photographer, do you need to bring in a portfolio of your work or do you just walk in...?

Question for New York 👩‍❤️‍💋‍👩. Is Henrietta Hudson 🏳️‍⚧️ friendly? 🏳️‍⚧️🙋🏻‍♀️here.

Newbie question. When you see watches on display in window shops can you actually just walk in and purchase them? E.g. I’ve heard before that you need to be approved to buy a Patek.

I know you can do it for brands like Omega, but wondering if you can also just walk in and buy a Audemars Piguet, Patek Philippe, A Lange Sohne, etc. without knowing the dealer beforehand.

I am looking for referrals for any sales operations/support roles. I have 1 year experience in sales and 2 years as a bank analyst. Any help is greatly appreciated!

TCS HR sent me salary Structure 2 Month back and said will be sharing offer letter Next week. Since then , They are sharing only last week Again came and took screen shot again and now not picking call. It's Been more than 3 Month and they say we are working on your offer letter.
Should I wait for them ?

any telltale signs of layoffs in tiger?

Absolutely battered from pulling 10 hours shifts every other day, what’s with all the crunch time? Is it like this for everyone else?

If there is a sought after Director for a practice being built up at PwC. Has there ever been a time that a director can go straight to partner if they have an external offer that is quite compelling ?

Basically that offer would be 1st year partner salary and build off that ? Or PwC likes to stick to it's process and only other option is down the road consider direct Admit partner?

Wedding Proposal stories? Need some ideas....

Hi fellow UI/UX bowlers,
I’m currently in a ux design program and am in the process of figuring out/writing my “elevator pitch” and wanted to see if anyone has found helpful ways of figuring this out

what are the learning platforms provided by cgi??

I just finished my Masters at UT Arlington. I’ve been working for this firm for almost 3 years in uptown Dallas. I technically don’t have a title, obviously because I’m not license. I mainly do a lot of renderings and postproduction work along with some digital graphics for a lot of projects. Is it too soon to ask for a pay raise? Or how do I come about that?

Hey Salesforce Professionals - how has the pandemic impacted your firm? What are you seeing with your customers? How are you helping your customers during these difficult times?

Im a campus hire with limited experience and engineering major. I have a basic cert in sap but im looking to learn more about new technologies/skills so im more likely to get opportunities and grow. What would you recommend?

So what's your plan if the candidate you're voting for doesn't win?

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")

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.

Anyone have any resources for improving your skills building valuation models for the purpose of CDDs in excel? I’m moving to a new firm and my old one often had our offshore team build out the majority of our valuation models. Now I’m going to be responsible and I want to prep before I onboard.

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

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.

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?

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

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

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

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

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

Dear auditors, please explain how you pick samples for substantative testing.

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

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?