Microsoft Excel with the iSeries

Quickly and easily modernize iSeries reporting with Microsoft Excel with the iSeries.

This is practical training developed in a real working environment and used on a daily basis. Learn to get any file into an Excel spreadsheet, to use Query/400 to "filter" what records to put into Excel, to use the AS/400 IFS to copy information into Excel, to call programs on the iSeries on your PC using RMTCMD, and to click a button in Excel and open other PC programs, other spreadsheets, even web-sites.

This course comes with an illustrated manual and a CD containing all the exercise source code, a complete Excel workbook with buttons to run queries and a sample user request workbook for creating clearly defined user requests that will make your job easier.

Media: Self-paced manual with source code CD. Estimated completion time: 12 hours.