I use SUM(FILTER()) instead of SUMIFS, AMA

How about the scope/ demand of mobile application testing.

How much do CSOs in big ad agencies make?

Has any one went from reinsurance back to insurance? The money is great and all but the W/L balance isn’t. Has anyone else felt the same?

Hi Fishes, need 15 likes on this post to activate DM feature. Please show some love. Thanks in advance 😀

Hey, how often do we get hikes in EXL? And average hike?

Hello Everyone. I just wanted to ask what's the salary of a 4.5 years experience developer in Siemens technology and services. I just want to if i am underpaid or not.please help me out

What’s an ideal compensation for a director and MD for technology at a Hedge Fund of around 10-15 BN AUM?

What are some of the things to keep in mind when leasing a new car? What are some add-on that can be negotiated on?

Is it possible to negotiate a counter offer after accepting an offer? A timeline of one day is given to accept the offer from the company.

any examples of great CPG work? trying to get inspired past the excessive product beauty shots

Has anyone made the transition from non-profit and small firm practice to federal government, big law, in-house? I’m a special education parent attorney at a small firm and I’ve spent my legal career in the education and juvenile areas of the law working for 2 non-profits before ending up at the firm. However, I’m just exhausted, unmotivated, and and looking for a change. At this point (6.5 yrs of practice), is that type of transition even possible or am I stuck due to the practice area?

How’s McCann Health doing these days? Culture/businesses/client?

Hi All, What's your view about SAP SDC work culture and benefits. I have another offer from Airbus. Which one will be good for career.

Could anyone please suggest what are some good product based companies that hire for oracle applications/ ERP roles? Any suggestions would be really helpful.

Exec consisting Slalom for more creative work and more diverse and inclusive culture. Any insight into partner and above admissions/roles/past experiences. Based east coast but not looking for local

Anyone seriously wanna start a hedgefund with me ? I can assure a 30% cagr with my quant

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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

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?

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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 .

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

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!

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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.