Stimulus Package Special
Instructor Led Public Web-Based Training
Features
Smaller time investment than standard courses, only three day sessions (4 hour block per session) are required.
Additional 50 minute private session per trainee. Each trainee also receives a free 50 minute one-on-one training session to work on a topic or project of their choice, after the class. No other training company provides this additional service.
Learn just what you need to know to implement IDEA immediately.
Lower cost than on-site training, based upon demand and comparable costs of other providers.
Zero employee travel cost. Provides training for employees at different locations -- no need to travel to one central location.
No schedule interruptions, you train at your desk or your training room. No need to go out of town or disrupt your family life.
Small class size, 8 maximum.
Download a Printable Version (PDF) of the Public Web Based Curriculum
Process
Web Based Training, Instructor Led. The training is delivered via Office Live Meeting in three 4-hour Sessions, 8:30 am-12:30pm (Eastern) with an additional one-on-one 50 minute session optional. All trainees are provided with a full manual and exercise files. This is a very interactive course hands-on course, it is NOT a webinar.
Maximum of 8 trainees.
Fee: $600 per trainee; fee is due at least 21 days before class date.
Requirements
High speed Internet connection.
IDEA 7.0 or above.
Prerequisites: None
Goals
Gain experience and skills with both hands-on exercises and instructor lead discussions.
Learn and practice key data elements such as importing, reconciling, sampling, indexing/sorting, extracting, stratifying, summarizing, aging, gap detecting, relating databases and analyzing.
Master key software features such as Report Reader, Equation Editor, @functions, and analysis / reporting tools. By the end of this course, the novice user will return to the office and hit the ground running; the seasoned user will gain a deeper understanding of core competencies and maximize their daily performance.
Topics
Day One: Mine Data using the Import Assistant and Report Reader.
Explore Working Folder benefits.
Conquer Data Imports: Excel, Access, ASCII Delimited/Fixed, EBCDIC, dBase, Quickbooks, AS400.
Learn time-saving Record Definition techniques.
Demystify Report Reader.
Apply and understand both simple and complex trapping: alpha, numeric, space, non-blank, floating.
Unpeel layers: basic, append, floating and their components (anchor line, field editor, field anchor).
Tackle tricky data samples: wrapped text, multiple line, columns, headers, suppressed text, filters.
Discover the importance of Field Order.
Find out when to exclude lines, apply a filter and the purpose of using the previous value.
Day Two: Import, Manipulate and Present Data.
Prerequisite: Knowledge of Day One material.
Verify data integrity using Control Totals, Field Statistics, Summarizations and Sampling.
Understand the Indexing and Sorting differences.
Maneuver through data quickly with record grouping, go to, find, filtering, extracting, filtering.
Merge disparate databases correctly choosing join, append or compare.
Export data, reports and results.
Utilize powerful and time-saving @ functions with Equation Editor.
Assess data with summarizing, aging, detecting gaps/duplicates, stratifying, extracting and filtering.
Change data types, appearances, orders, field manipulation including adding columns.
Display results graphically: tables, charts, graphs.
Class Exercises
Frequent exercises engage you in challenging missions that solidify learning in an open, easy and fun environment. We include more file types so our students understand the big picture, gain valuable experience, identify alternative resolutions and then apply their knowledge to any situation, such as: sales history, general ledger, aging, vendors/terms of sale, fees billed/paid, properties, sales and profit, database, error logs.
|
