What new Excel trick did you learn this week? Please share with the bowl! 🌟

Any recs for undershirt brands? Looking for beige deep Vs, so that the shirt doesn’t show

What is annual hike % at Acuity?

Data Scientist at HP vs Data Science Analysis Manager at Cisco (IC), which one is a better position in terms of role and future prospects in Data Science. Years of experience is 6

Hey folks,

I am having approx 9 years of experience in sales and key account management. Now I want to upscale my skills to grow financially and vertically in my career and want to learn new things which can help me in this.
Having sound knowledge of IT things. which course or area of learning i have to target which compliment my previous experience also.

I have in mind like Marketing strategy and analytics, Customer success in cloud.

Request Your suggestions on this.

I am struggling to spend the time to study for the PHR. I have everything I need, but I feel exhausted from the work week every weekend. I’m looking to take it in August.. help? What do I do?

Can someone share the salary range offered for SAP BRIM Consultant?

YoE 6

Hi Fishes,

I have 2 offers in hand

1. PPD, part of thermofisher scientific - 14 LPA + 2L JB
Permanent WFH

2. TSYS - 17 LPA+ 1L JB Hybrid WFO

YOE: 3+ years

Which company would be better considering the upcoming recession?

How you came into the company will define your path. That’s why you’ll never be successful switching departments.

Best place to book an Airbnb in South Florida or West Palm beach area?

Recently received 30k and wondering what to do with it. Not yet a homeowner but also not sure if we’re ready to buy anyways. Have a young baby. Any advice on how to figure out best use?

Waiting to hear from Novartis on a job I interviewed for 2 weeks ago. They emailed me a Conflict of Interest Form to sign last week, which got me thinking an offer was coming but I'm still waiting. Thoughts on whether this form means anything? I daydream about quitting my current toxic job :/

How's magic finser company? It's culture, wlb and growth opportunities?

Clients are pain in the ass out here

At what point are you too specialized to lateral to internal audit? (PA, consulting, or industry roles) Currently have 2 years of external audit experience and 2 years of forensics: I always thought of internal audit as a decent exit but I’m beginning to get worried about getting too specialized to make that move one day

Getting a lower title than what I interviewed for but the salary matches what I asked for. Would you go?

Does PwC have any free access to learning sites such as Udacity, Coursera or Udemy to complete courses with certificate? I know EY has free access to many courses on Udemy!

Currently preparing for a final round case interview at the director level for a CVS Health graduate summer internship. Any tips or things I should look out for/emphasize? First time making a final round. Thanks in advance.

Hi Fishes,

How much hike relaince jio gives to employees every year?

How many dress shirts and trousers do you recommend I should have? New to this and need advice. Sorry if repost.

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.

Would anyone be willing to teach me vlookup?

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”

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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.

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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.

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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.

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

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