Install the Excel Plug-in by following these steps:
Notes:
This tool combines the functionality of the Microsoft Office toolkit with financial and qualitative information from S&P Capital IQ. You can quickly populate and update your spreadsheets with financial, market, transaction, macroeconomic, and company data.Utilize over 150 customizable Quick Key commands to help you build and format models more efficiently.
Manuals and documentation can be found by logging into S&P Capital IQ and clicking on Help at the top right of the screen.
Then search e.g. for: excel plug-in
(Note that the current version of Excel Plug-in is version 9.4x - but still you can find help in the guides on the earlier versions of the Excel Plug-in)