Excel, not true. I mean libreoffice calc just works for a lot but not for easy basic graphs. And it does not do the job better at graphically ebabling users to do data analysis
Python and matplotlib aren't hard... Plus you get pandas, numpy, and so on. Alternatively, R studio does such stuff ootb, as far as I remember
Idk, excel always seemed unnecessarily limiting and complicated to me compared to proper programming languages. Although that may be because I was taught cpp before this crap.
The (libre) office suite is geared towards business and school stuff, they are far from perfect but does 90% of what people need.
Word/LibreOffice Writer
Have their uses, just keep the document below like 50 pages.
LaTeX is great for academic papers and when you need the document to look crisp!
And you are right about Markdown it's great for many documents.
Excel/Calc
Spreadsheets are great for data entry and some calculations especially financial stuff. You can't do that as easily inside a source file.
PowerPoint, you are probably right about beamer?
Access
Utter garbage "database" maybe if you need something to keep your record collection? If you know the basics of relational databases and a bit of SQL any proper DB is soo much better.
So, regarding md & beamer: I'm kinda into that "less is more" mindset when it comes to every day -ish writing. Like yeah, you can spend a few hrs formatting the info a certain way, but if that's not a typography thingy - who's really going to care how the stuff is aligned or whether it's divided into 100500 columns?
Md has just enough features to structure the text, and when you need to share, you just compile the doc into PDF which is at least supposed to look the same everywhere. Basically the same for beamer, although you can shove animations in there (right, cause why tf shouldn't PDF support animations after all)
Beamer has a very high steep learning curve, especially when you just want a few slides to show preliminary results. In PowerPoint you literally drag the image, resize, and that's it.
Also I feel that beamer pushes the user towards the "bullet point" presentation, which sometimes can be very boring.
For documents, I love latex, but I actually prefer LibreOffice or onlyoffice when it comes to presentations.
Crossover is proprietary so one can’t say for sure, but as they are one of the main Wine contributors I would assume they at least get some things early