IBMi and AS400 Training


 
Microsoft Excel with the iSeries (EXLI)
Author: G. Wayne Hawks
$495


 
Add Microsoft Word with the iSeries and Save $100



Use Microsoft Word on your iSeries

Does not require ODBC configuration on the PC or other complicated steps. No software to buy. If you have an iSeries and Microsoft Excel, you are good to go!

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.

Here is what you will learn:
  • How to get any file into an Excel spreadsheet.

  • How to use Query/400 to "filter" what records to put into Excel.

  • How to use the AS/400 IFS to copy information into Excel.

  • How to call programs on the iSeries on your PC using RMTCMD.

  • How to use Visual Basic in Excel to run a program on the iSeries and open the results in Excel.

  • How to pass parameters to called programs on the iSeries right from Excel.

  • How to modify fonts, column widths, lock titles, set formatting and more... all automatically, once an iSeries file is opened in Excel.

  • How to build Query/400 queries and never have to change them again to select different date ranges.

  • How to click a button in Excel and open other PC programs, other spreadsheets, even websites.
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.

Skill Level: Some experience with computer programming and OS/400 DB2 database. Any RPG programmer with 1 or more years of experience will be able to successfully complete this course. Some Microsoft Office Suite experience a plus.  This course is not intended for end-users or for novice programmers.

Add Microsoft Word with the iSeries and Save $100
Microsoft Excel with the iSeries (EXLI)
Author: G. Wayne Hawks
$495


 
 
Copyright 2018, Rochester Initiative