How to generate Cognos Analytics Report for Excel

When you see the report in your list, click on the More (...) menu.
You will see an option to 'Run as'.  Then you can select Excel, etc.
(See snapshots below)
Excel Options: 
  • 'Excel Data' has NO formatting, this is raw data with column headers, which is preferred by third parties for importing. 
  • 'Excel'  has formatting for ease of viewing especially if you have subtotal and total rows.

See also:
On > SMS > 20.4 Training Documentation > in the Cognos section if you pull the Cognos Analytics Training Guide, instructions for this item begin on page 14.
On > FMS >  Financial Management System - 5.2 Cognos Analytics Training Documentation, instructions for this item begin on page 23.