IBMi and AS400 Training


 
Microsoft Word and Excel with the iSeries Bundle (WOEX)
Author: G. Wayne Hawks
$890

Temporary Price Reduction $690
(That's $200 off the published price!)


 


Get Microsoft WORD and EXCEL on your iSeries!

Get both courses for just $690 (That's $200 off the published price!) here.

Microsoft WORD with the iSeries

Talk about smiling managers and happy users! Now you can create better looking, easier to read and understand RPG report printouts with graphics, fonts, underlines, and bolding using Microsoft Word with the iSeries!

Within a few short hours, you will tap into the power of Microsoft Word on the iSeries. Our self-paced training comes with a source code CD and easy to follow step-by-step instructions.
  • Create Microsoft Word templates that contain graphics, fonts, bold text, and underlined text that can be saved to the Integrated File System (IFS) on your iSeries and copied directly into OS/400 files.

  • Create and use RPG programs to modify the contents of those files, merge information from other files into the appropriate documents (based on your organization's rules), and then store them in appropriate folders on your IFS.

  • Create the merged documents at a pre-set date and time from the job scheduler or on-demand by choosing an iSeries menu option.

  • Create buttons in Word that will print all the Word documents in specific folders and then clean up the folders.

  • Create better looking, easier to read and understand RPG report printouts with fonts, underlines, bolding, and graphics.

  • Use your iSeries to start PC programs that select menu options, including opening Word documents and automating the compression of files using Winzip.

Get Microsoft Word with the iSeries for only $395
If ordering only Word click here


Microsoft Word and Excel with the iSeries Bundle (WOEX)
Author: G. Wayne Hawks
$890

Temporary Price Reduction $690
(That's $200 off the published price!)



Microsoft EXCEL with the iSeries

Now you can quickly and easily modernize your iSeries reports with Microsoft Excel with the iSeries. This hands-on training shows you the work-a-day techniques that will save you time and keep your users happy and productive.

It 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.

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.

Get Microsoft Excel with the iSeries for only $495
If ordering only Excel click here


KILLER DEAL: Get both courses for just $690 (That's $200 off the published price!) here.

This is cool stuff! Your managers and users will stand up and applaud! Discover the power and functionality of Microsoft WORD and EXCEL on the iSeries for just $690.



Microsoft Word and Excel with the iSeries Bundle (WOEX)
Author: G. Wayne Hawks
$890

Temporary Price Reduction $690
(That's $200 off the published price!)


 
 
Copyright 2018, Rochester Initiative