knowledge base
sample programs
white papers
texas DIR contract
Online Training Classes

Introduction to Xllerate® - The Basics (42 min)
Class reviews the Introduction to Xllerate® Basic Training Program manual. The class covers the Xllerate® environment, program worksheets, Xllerate® Help manual, TLC functions, first steps and several exercises. (Training consists of several lessons ranging from 1 min to 5 min each).

How to Schedule an Xllerate® Program (3 min)
Want an Xllerate® program to run unattended? This class will teach you how to use Task Scheduler to run Xllerate® programs at various intervals.

How to Use Xllerate® Memory Variables (6 min)
The Xllerate® memory variables are stored in named ranges and are available to you at runtime. This class will review how to use and the benefits of using Xllerate® memory variables.

How to Create an Xllerate® Program Loop (5 min)
Xllerate® was built to perform repetitive tasks. This may be accomplished through the use of a loop, which is a function that will allow the program to use the same code lines over and over.

How to use Formula Functions in an Xllerate® Program (34 min)
There are many Xllerate® and Excel formula functions which may make writing your programs easier. Learn about: ConvertNumberToWords, CreateDelimitedList, GetAlphaNumeric, GetFileExists, Indirect, Substitute and VLookUp. (Training consists of several lessons ranging from 4 to 6 min each).

How to Query an External Database (7 min)
Learn how to query information from a database (like Access, MySQL, SQL Server & Oracle).

privacy notice   conditions of use   site map   shipping and returns   contact us © 2008 Xllerate Consulting, LLC | Web Site by Mkreative Design Studio and Web Site Optimizers