Where can I learn more about mastering pivot tables?

EYP and Strategy& fishes, what sort of work do you do in the Life Sciences space (specifically Big Pharma)? And what sort of exits into industry have you seen your former colleagues make?

If someone is getting promoted in @cognizant. They are sending a token of appreciation via delivery to home address. So what are we receiving in it. Just curiosity...

This has probably been asked many times in this bowl - what’s the best hotel rewards program? I have the Chase Sapphire Preferred card and I’m a Southwest RR member. I travel maybe 25-30% of the time

Going solo to Denver next weekend for a couple of days. Planning to stay downtown, any hotel recommendations? Also any suggestions for things to do? I am not much into hiking but planning to do a hiking trip. I saw a bunch on hiking experiences on Airbnb, so will most likely do one of those, but would appreciate any suggestions. Thanks!

Happy new year everyone👍🏼

Any idea, on this error " DM privileges has been temporarily revoked " . Not able to see message box. How many days it will be turned back to normal. Anyone faced or facing the same issue ?

Is it wise to choose a company having 2 months notice period giving 3.5 lacs less than other company having 3 months notice period.
Tech sap abap
Yoe 5.5 years

Looking for SAP ewm jobs in non-service based companies....any refferals ?

Hello,
I am about to finish my notice period working as a SOC L1, yeo 2 please help me with how much I should ask for salary in next company, ctc 4.26 total year of exp 4

Hey Sharks,

How's T-Systems india ICT pune for Data science?
How much to expect for Senior Consultant 2 -Data science?

Total experience 9 yrs.
Data science 4 years + 5 years in Data analysis.

Can anyone please help me with the Salary for 4 years experienced MEAN stack developer?

Anyone here living in Windsor, ON and working in Detroit ? I’m curious about your experiences, especially if on a TN visa. TIA

Has Anyone moved to KPMG UK as an IT Audit Analyst (E Grade Role)? How is the work life balance ?

@kpmglondon @kpmguk

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?

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 😭

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.

Would anyone be willing to teach me vlookup?

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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

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

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

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

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

Any book recommendations on excel modeling for real world business applications?

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.

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?

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

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!