Select a report, click Export button at the top right corner of the report. Click "Report to Excel compatible format". By default, it will be exported to a text file. However you can open it using Excel by right-clicking the exported file and select Open With... Hope that's help.
Following Kerbeross's starting direction, I prefer to select "Copy to Clipboard' for the report, then switch to Excel and therein Paste the copy. Seems to save steps and lets me put the report anywhere I want in an existing Excel worksheet.