 |
|
|
|
|
|
 |
|
 |
WelcomeToTheXllerateWizard |
|
|
FUNCTIONS HIGHLIGHTED: Format_Sheet|Copy; Data_Sort; Insert_Rows; Insert_Text
Introduction to the Wizard and description of navigation Panels. Program will demonstrate how to write your first Xllerate® program using the Wizard programming method. |
|
|
|
|
|
|
|
|
|
|
|
|
WriteYourFirstXllerateProgram |
|
|
FUNCTIONS HIGHLIGHTED: Data_Sort; Data_Subtotal; Format_Cells
Program will demonstrate step by step, how to write your first Xllerate® program using the Spreadsheet programming method. |
|
|
|
|
|
|
|
|
|
|
|
|
Prg_SubtotalSample.xls |
|
|
FUNCTIONS HIGHLIGHTED: Data_Sort; Data_Subtotal; Format_Cells
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. |
|
|
|
|
|
|
|
|
|
|
|
|
Prg_CreateTableofContents.xls |
|
|
FUNCTIONS HIGHLIGHTED: Tools_CreateList | Worksheet; Format_Sheet | Order
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. |
|
|
|
|
|
|
|
|
|
|
|
|
Prg_SendBirthdayWish.xls |
|
|
FUNCTIONS HIGHLIGHTED: File_MultiFunction | Open; Data_Filter; Apps_Outlook | Send; Prg_Loop
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. |
|
|
|
|
|
|
|
|
|
 |
|
|
Prg_CreateAccessDatabase.xls |
|
|
FUNCTIONS HIGHLIGHTED: Apps_AccessDatabase
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. |
|
|
|
|
|
|
|
|
|
|
|
|
Prg_PublishCharts.xls |
|
|
FUNCTIONS HIGHLIGHTED: Data_Filter; Edit_CopyPaste; Data_Refresh; File_MultiFunction | Publish
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. |
|
|
|
|
|
|
|
|
|
 |
|
|
Prg_SQLLoopSample.xls |
|
|
FUNCTIONS HIGHLIGHTED: Data_Query_ExternalDatabase; Prg_Loop; Data_Filter | Unique Filter
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. |
|
|
|
FREE TRIAL
