AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage


IBMi and AS400 Training
HOME >> Training Catalog >> Microsoft Word and Excel with the iSeries Bundle

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

Temporary Price Reduction $690




Get Microsoft WORD and EXCEL on your iSeries!
For a two minute overview of this training click play.

Power and Functionality:

Microsoft WORD with the iSeries 


Microsoft Word Magic!

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. 

You will learn how to:

  •  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 Now 

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

Temporary Price Reduction $690


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.


Microsoft Excel Magic!

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 Now 


KILLER DEAL: Get both courses for just $690 (That's $200 off the published price!) 
 
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
$790

Temporary Price Reduction $690



Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2