I have a spreadsheet that has location, number of hourly people and then number of salary at each location. How can I create a pivot table that will tell me sum of salary and sum of hourly by location. TIA!

I’m having the hardest time finding a new job. I have 12 years of HR experience, a masters in HR, SHRM certification, and all I keep getting are rejection emails. I’ve never experienced this difficult of a time searching for new opportunities. Is this normal once you hit a certain level in your career or is it just me?

Thoughts on Stitch Fix - would you work there? Or is it just another DTC company that won’t last?

Recently found out a hiring manager was bragging to a bunch of people at the company about getting me to accept an offer for a must cheaper rate than he expected. He was let go soon after. Justice? Not sure..

Anyone been to crew club in DC?

Moving into a new role to support marketing efforts of two smaller divisions under our brand umbrella. When I asked my boss what the job description was to create year end goals they told me to write one. . . Where do I start?

What would you do?
My company contracts a web developer, we have a set amount of hours for the quarter and pay over if more work is needed.
He never gets anything done. Doesn’t answer emails half the time. The one thing he’s done was take out a blurb that threatened our eligibility for patent renewal.
We have another company taking over in January, but I still have some pretty important dev needs until then and I can’t get him to do a thing. I truly try to give him all he needs.

I travel a lot and have about 50k IG followers with high engagement. How do I contact companies and see if they want me to make a sponsored post?

30 F looking to chat with someone. A bit buzzed and lonely, but not really single, so just looking for a friend. I’m a good listener.

Where do professionals 30+ meet people these days besides dating apps?!

Just bought my first Tiffany product! Wrap Bead Bracelet in Silver with Pearls and a Diamond.

Does TCS employees get any special discount in Croma stores?

Any thoughts of investing in gold or gold related instruments?

I'm planning to do my PGDM in Canada
Which College/Universities should I consider to get recruited into top consulting firms (Also the preferred courses) ?

I am an Oracle apps technical guy(9+ yrs exp)
Got 3 offers which one i should choose please suggest.
Current CTC in IBM - 11Lpa
New offers as below
Cognizant - 18.7LPA (18Fixed +0. 7 variable)
TCS + 19.5LPA (including fixed , variable and retention bonus)

Wipro - 20LPa ( including fixed and variable)

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!

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

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

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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

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”

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

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.

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

Would anyone be willing to teach me vlookup?

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 symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.