How do we create reports for Microsoft Excel ?

As standard sample reports are created in your folder 'My Documents/Schedule it 7/Reports' which you can modify, or copy and edit, to create your own.

Reports saved as CSV files can be automatically opened by Microsoft Excel (or any other application you choose as your default for the file type) and populate the spreadsheet for further viewing, editing and other tasks. Reports can also be created and saved as DOC, XML, TXT and many other ASCII formats.

For details on Customising Reports please see this FAQ.