I'm surprised nobody mentioned Pages on a Mac. It's a style sheet-based tool, where the styles are quite easy to work with. I've been using it for years now and it does almost everything I need it to do. I realize there are people who absolutely need every little feature in Word, but for things like letters, technical reports, briefs or software documentation Pages works just fine, and produces nicely-formatted docum…
So if I use LaTeX and it gives me the results I want and I don't find myself spending inordinate amounts of time tweaking things, does that make me an intermediate user? I guess I had better stop learning.
These tools play well with git and make it easy to automate an analysis. I am a strong believer in literate programming - embedding the code in the documentation where feasible. There are case where it is not (long Monte Carlo simulations) but I can at least pull in the results and have the source code that generated them in version control and the report automatically uses the latest version.
Microsoft kept changing VBA and each release would break things. We had third party tools that had locked VBA modules and ours just wouldn't permit processing data in these workbooks.
I can extract all the data with R and am much happier. The Open Source community seems to better support their products than Microsoft. Go figure...