The Report Jobs page contains the future jobs schedule. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/manage-report-jobs-page.html#GUID-A6612A75-111C-4707-AC77-4742CE8A7C73

Is it necessary to use an excel template for this? Could you use an rtf instead?

You might be able to accomplish this using an XSLT file. https://docs.oracle.com/middleware/bi12214/bip/BIPRD/GUID-F926959D-B7A5-41DE-8388-2951666A38EE.htm#BIPRD2843

Office 365 is not certified with 11.1.1.9. Please refer to the certification matrix.

Please refer to the following KM: BI Publisher and Office 356 Certificatin (Doc ID 2329036.1)

Please refer to the user's guide for how to set up datasources for Oracle BI Publisher; https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/set-data-sources.html#GUID-13359663-9030-4E6F-B5CC-2D63E43E456F