1. Open the report you wish to send out on a schedule
2. Change any date fields to a dynamic date to match what you want to send the report out for
3. Choose the schedule, and click recurring if you want it to happen more than once.
4. For a report you want sent out in Excel format (Data Only) choose that at the top of the screen as the format 
5. Click the email button at the top. You will see the dialog below.  Fill out the necessary information for subject, email address, and body of the email if needed. Click OK after everything is finished.  Here is where you may also have to select Excel-Data Only for the attachment type
6. Once this is done, you can check the system monitor, under scheduled tasks to see that the report is now scheduled.