training
FAQ
knowledge base
sample programs
white papers
texas DIR contract
Sample Programs

Beginner
WelcomeToTheXllerateWizard
Introduction to the Wizard and description of navigation Panels. Program will demonstrate how to write your first Xllerate® program using the Wizard programming method.
FUNCTIONS HIGHLIGHTED: Format_Sheet|Copy; Data_Sort; Insert_Rows; Insert_Text



WriteYourFirstXllerateProgram
Program will demonstrate step by step, how to write your first Xllerate® program using the Spreadsheet programming method.
FUNCTIONS HIGHLIGHTED: Data_Sort; Data_Subtotal; Format_Cells



Prg_SubtotalSample.xls
Program will demonstrate how to Sort, Subtotal and Format data into a new report from an existing worksheet. Creates and saves a new workbook from the report worksheet.
FUNCTIONS HIGHLIGHTED: Data_Sort; Data_Subtotal; Format_Cells



Prg_CreateTableofContents.xls
Allows users to create an alphabetical list of all worksheets within a designated workbook. Inserts a hyperlink for each worksheet and places the links on a Table_Of_Contents tab. Program focus may be changed to create a Table of Contents in another Xllerate® Workbook or any Excel File.
FUNCTIONS HIGHLIGHTED: Tools_CreateList | Worksheet; Format_Sheet | Order



Prg_SendBirthdayWish.xls
This program opens an existing workbook containing employee information. Filters for individuals with birthdays in the current month and sends an email with a birthday card attachment to those individuals.
FUNCTIONS HIGHLIGHTED: File_MultiFunction | Open; Data_Filter; Apps_Outlook | Send; Prg_Loop



Intermediate
Prg_CreateAccessDatabase.xls
Learn how to create new Access database and tables. Load records from an existing worksheet into designated tables. Query for specific records using Xllerate®’s Criteria Table Assistant.
FUNCTIONS HIGHLIGHTED: Apps_AccessDatabase



Prg_PublishCharts.xls
This program will create a unique list of Salespersons. Copy & Paste Pending Sales Information for each Salesperson to a pre-defined Pivot Chart Template. Publish a workbook for each Salesperson in an html format.
FUNCTIONS HIGHLIGHTED: Data_Filter; Edit_CopyPaste; Data_Refresh; File_MultiFunction | Publish



Advanced
Prg_SQLLoopSample.xls
Discover how to retrieve data using a dynamic SQL Statement. Create a unique list of items to be used in conjunction with a Loop. Generate a new file containing worksheets for each unique item.
FUNCTIONS HIGHLIGHTED: Data_Query_ExternalDatabase; Prg_Loop; Data_Filter | Unique Filter






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