Chances are, LibreOffice is more than sufficient for the layperson. Even if the feature disparity was that of GIMP and Photoshop, 99% of the professional features would be left unused by the average person.
Saving CSV files. In Excel you have to do a bunch of tricks to get quotes around certain fields in the exported CSV (I end up using a custom field format to force quotes, then doing a find and replace in a text editor, as Excel likes to save "Text" as """Text"""), whereas in LibreOffice Calc there's an option to 'Quote all text cells' when exporting the CSV, which is much simpler.
Also importing CSV files works much better. I don't know how many times I had to suggest friends or customers to use openoffice for that, it was just easier than finding the right way to do it in Office.