I have a row in the pivot table, say Part description, and Sum of Spend as a value. I sorted this value from largest to smallest. Then I added another row, Part number. The sorting went away, and now the Sum of Spend is not sorting back from largest to smallest. Any recommendations?

I am actively working as a mechanical engineer in the refrigeration industry. However, I have worked and studied in the spare parts and battery department in the automotive sector for close to ten years, my technical and practical knowledge is more than my age

This season is pretty crappy from a story perspective. Right?

Who was at the ADCC? Thoughts on the NABs stunt?

Does anyone has an idea of the salary for PM 3 at Adobe ?

Has anyone prepared a study plan? And when is everyone planning to appear for the exam?

Does anyone already have e gmat subscription and is willing to share? Need for 2 months exact.

What's the purpose of this group?

How long does it take to hear from Astrazenca after HR round?
Its been 10 days since I had salary discussion(HR just asked me about my salary expectation... nothing more than that)
I have submitted pre hire documents as well

Sent a mail to HR, No response from them.

How are you guys managing with the Sapience tool?

I got an offer from Mindtree as a Support Engineer in the US and was asked to fill out a profile through an excel sheet. Has anyone else experienced this? I don't feel comfortable sending my personal info over email in an excel sheet

What do you think about business operations managers? Is that a respected position? A good position (in terms of potential)?

Are spg and spg points eventually going to get phased out due to merger?

Am I the only one who finds statements like, "I'm a democrat/republican" detrimental? Using these words as nouns instead of adjectives illustrates why America's so divided. It would be better to say, "I usually vote for Democrats/Republican candidates. We are not who we vote for

Are there firms in LA that are known to have good work cultures? Thinking about moving to LA from NY.

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)

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.

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

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.

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

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.

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Still don't have xlookup. #fomo

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.

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

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.

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

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?

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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”

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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.

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

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 😭