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 want to get my masters in HR, but I also want to get my phr.. is it better to get one over the other? Or should I do both. Are there any masters hr program someone can recommend?

Hello friends, been offline for a while and trying to get a sense what the vibe in the NY market is at the moment? Hiring freezes and everyone is afraid of an approaching recession?

If you are leaving your firm and putting in your two weeks notice, what should be on your checklist to make sure your transition is the smoothest, both for you and for the firm you’re leaving?

Hi fishes,

As i have recently joined EY GDS as Consultant, Can someone let me know of an estimated hike %age the company awards?

I know it depends on the service line and the individual, just wanted to know an average amount

Job opportunity (mgr title, 4-6 yr exp needed) in Internal Audit (w/ data analytics exposure) at one of the largest private companies in Chicago. I interviewed with them (director and vp) till last round and decided to pursue a different opportunity. Great and caring people who seems to support what you wanna do at this position. Since it’s private there is a lot of room to create and build from the best practice. lmk if you are interested or know someone needs help. Thanks!

I’m trying to make the jump from legal services to corporate IP. I’ve only been in practice for 2 years and I have 0 experience in corporate. Do I have a chance?

Hi folks,
Could you please help me with fresher job vacancies in finance related sector within pune. Shift - Day shift
Thanks in advance!
Currently I am working at WNS as a associate and have 2 months of notice period.

Hi All, After HR Discussion its around more than 10 days i have not received any offer letter and HR is not replying on mail too.

Did anyone faced same issue.

Need 11 likes to start DM please

Dear all, I am joining MS next week, any idea when can i expect onboarding team emails and other joining formalities emails.

Paid team currently complaining about which vendors didn’t send them holiday gifts this year 🙄

Is it common for a form to not let you see the RFE they are filing on your behalf?

H! DM me if any male fish are interesting in connecting. Also here’s the age old ice breaker ASL : 31,f,New York (:
Ideally from the New York area

***Urgent *** Where to join?

2 days left to join.
IBM - 17 lpa
Capgemini - 23 lpa
Tech - Oracle apps/fusion technical Yoe - 10 years.

I heard, there are projects shortage @IBM in Oracle Apps currently. (As my colleagues are on the bench for 2+ months in IBM after joining)

Please suggest IBM Capgemini Accenture Tata Consultancy

Best websites to get more of a handle on Excel as a beginner-intermediate?

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

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!

Still don't have xlookup. #fomo

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)

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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.

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

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?

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

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?

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 🙏

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

What are your top Excel ninja tricks? Ones that few people know...

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.