Xcelerator never modifies the original data being formatted.
Unless the original data is being maintained inside an Xcelerator created workbook, Xcelerator will always create a new workbook separate from the workbook containing the data being formatted.
An automatic copy of the original data is made prior to formatting and is included in the Xcelerator created workbook in a hidden worksheet.
|
Xcelerator automatically substitutes user-defined output field descriptions as part of the formatting process - the input field descriptions of the original data are not changed.
|
Xcelerator automatically sets the Excel number format (text, date, number, currency ...) and alignment of each field when formatting a set of fields for the first time.
This information is used to create and assign Excel Styles for each field in the first "Default" Xcelerator workbook and workbook format for a new set of fields.
Users can initially set and subsequently maintain the default number format, alignment and output description of each field.
|
"Quick Stats" instantly calculates Sum, Minimum, Maximum, Average, Median, Count, StdDev and StdDevp, for one or more numeric fields, for all data rows or for only the data rows for one selected non-numeric value.
|
Xcelerator automatically creates user-customized embedded and separate Excel Charts from Chart Data automatically summarized and assigned by Xcelerator.
|
Xcelerator automatically creates better formatted Excel PivotTables and PivotCharts with each PivotTable having its' own user-defined "Drill" worksheet format.
|
For Drills: hide columns, reorder columns, total columns (Sum or Count), Sort, set Print Orientation, and modify each field's automatically created and assigned Excel Style.
Export all columns or only visible columns of any Drill worksheet to a new workbook.
|
Use Xcelerator's "Date Aging" and "Reformatted Date" custom Excel Formula Fields in Charts and PivotTables.
|
Split one worksheet into multiple worksheets, into one new workbook or into multiple new workbooks, for all values or for only selected values in any non-numeric field.
Reapply subtotals when splitting an Xcelerator created and formatted data worksheet.
|
Export data from Microsoft Dynamics GP SmartList at speeds over 100 times faster than the standard SmartList export, and automatically format the data with Xcelerator.
|
Use Xcelerator's "Conditional Negative" custom Excel Formula Field to conditionally change the sign of the numeric data in one column to negative based on the values in a corresponding cell in another column.
|
For each field create and automatically apply Excel Conditional Formats to "Data" cells and to "Subtotal" cells at each subtotal break level.
Conditional Formats can be toggled on and off in real-time.
|
"Bold" and "Gradient" shade subtotal rows that can contain a mix of Sums, Counts (any of the 11 standard Excel subtotal types) and Excel formulas.
Mixing Excel subtotal types and using Excel formulas (for percent and average fields) in every subtotal row is not possible using only Excel.
Mixing reduces the number of subtotal outline levels / subtotal rows by at least 50%.
|
When you request Xcelerator format an entire set of fields, Xcelerator automatically finds and displays a list of user-created workbook formats from which to choose.
When you request Xcelerator format fewer than all the fields in the data, Xcelerator automatically finds and displays the groups of fields for which formats already exist.
You can select to format one of the existing groups of fields for which formats exist or you can select a new subset of fields to format for the first time.
|
Xcelerator relies exclusively on the use of Excel Styles to format every cell.
An Excel Style is automatically created for each field.
Xcelerator automatically assigns the appropriate Excel Styles to the data throughout the Xcelerator created workbook.
In Xcelerator created workbooks always modify the Excel Style of the data using the Xcelerator "Excel Style" option on the right-click menu in the "Formatted Data" worksheet.
In Xcelerator created workbooks do not use the Excel cell formatiing features found on the Excel "Formatting" toolbar, "Edit" menu and "Cell" right-click menu.
|
Xcelerator corrects Excel Subtotaling Bugs in the last Subtotal and Grand Total Rows.
|
Xcelerator can re-sort / rank subtotaled data by the subtotals of any field.
For example, if your were to create "Sales Amount" subtotals by Salesman Name and Product Line, you can resort the subtotaled data by the "Sales Amount" subtotals in descending order to show Salesmen from highest to lowest "Sales Amount" and within Salesmen Product Lines from highest to lowest "Sales Amount".
|
Xcelerator created workbooks are "Pure" Excel workbooks that could be manually created with very considerable time and effort.
Xcelerator created workbooks can be shared with non-Xcelerator Excel Users.
To non-Xcelerator users Xcelerator workbooks are like any other Excel workbook.
Xcelerator created workbooks can be shared with other Xcelerator users.
When an Xcelerator formatted workbook is opened on another computer having Xcelerator, the Xcelerator workbook format is automtically absorbed into Xcelerator on the new system.
|
To maximize the benefits of Xcelerator minimize making manual changes to the data you want Xcelerator to format.
Use Xcelerator to select fewer fields to format.
Use Xcelerator to automatically change field descriptions.
Use Xcelerator to create all Excel formula fields.
Do not use Excel cell formatting tools; change the Xcelerator created Excel Styles to change the format of all similar cells as a group.
Use the Xcelerator provided dialogs and methods for: Subtotaling, Sorting, Conditional Formats, hiding columns, re-ordering columns, changing field descriptions, maintaining Excel Styles, creating Charts, creating PivotTables, creating PivotCharts and creating PivotTable Drills.
Xcelerator dialogs and methods are wrapped in code to allow changes to be immediately implemented and to be saved for subsequent re-use.
|
Watch the movies and experiment with Xcelerator.
Suggestion: To save time when creating new Xcelerator workbook formats use small record sets instead of thousands of records.
|
PRODUCTS