How to run PowerPoint and Excel? I'm stuck with these for work?
Winapps is pretty good to run the Microsoft office suite. https://github.com/winapps-org/winapps
A office specific winapps fork : https://github.com/eylenburg/linoffice/
Do you not have a work-issued computer? I'm not being flippant. I don't need to install _anything_ on my home PC for work. It's actively discouraged.
Maybe in a VM.
Or try running via Wine.
You could also try LibreOffice or OnlyOffice and see if the documents are readable / writable.
Failing all that the web versions might work just fine.
Winboat should be able to run them: https://www.winboat.app/
As far as compatibility goes, OnlyOffice is fairly good at it, more geared towards MS-compatibility than LibreOffice, which is more of its own thing (and pretty good at that).
MS Office Online has been good with most of the things I need. Has that not been the experience for you?
Can you use the online versions? They are starting to become usable now.
That is what we are supposed to do at work.
No libre office suite will ever be on par with Microsoft proprietary options. It's a constant race of keeping up with features, using mostly unpaid volunteer developers.
I've used Linux for 25+ years and my reaction is always to do my best with the options I have, but in those cases when it's not enough I just say "I'm sorry but I can't edit this document" or "sorry but some of the formatting was lost when I saved this in libreoffice".
The thing is that I'm a senior Linux specialist so people accept my excuses because they generally need my work.