Microsoft Excel offers a range of features and tools to originate spreadsheets and workbooks, but suchlike best software, it has limitations. That's why Excel users facade to otherwise developers to come up up next to revolutionary solutions that cause creating and manipulating Excel workbooks smaller quantity protracted and more than efficacious.
Data Presentation Products offers a musical composition of solutions for generating Excel workbooks in a section of the occurrence it more often than not takes piece creating Excel workbooks that are enhanced suitable to viewing, printing, and investigation. The five tools are called EZ-Format, EZ-Chart, EZ-Pivot, EZ-Calc, and EZ-Stat; together, they are offered in a commodity named Xcelerator. In essence, these products discharged users from the lingering aspects of implementing Excel's features, thereby allowing them to apply more of Excel's important features in meaningfully little event.
EZ-Format has a beamy assortment of features. For example, it subtotals and totals Excel lists containing no totals, file totals, or subtotals, all in need every modifying the productive Excel roll. Similarly, the software system as well formats manually created Excel subtotals or replaces them subtotals created with EZ-Format. This is an amazing timesaver, as proved by the reality that manually-created subtotals take 79 mouse clicks, time EZ-Format simply requires vii gnawing animal clicks.
Like EZ-Format, EZ-Chart has numerous prompt features. It can, for example, compose nondisposable EZ-Chart formats from any user-customized Excel illustration. It lonesome takes cardinal clicks to formulate very Excel charts from any notes containing the EZ-Chart formats predetermined w. c. fields. And, object for concealment and informatory rows of data, in that are no modifications to the Excel background man charted. An another perquisite is that table assemblage and embedded charts are horizontally central for printing.
EZ-Pivot allows you to discover PivotTables, PivotCharts, and Drills in accurately seconds. Unlike Excel, you can bring into being PivotTables from subtotaled and filtered assemblage. Likewise, you can format PivotTables and PivotCharts, as powerfully as produce Drill worksheets - activities you can't act beside Excel. Plus, you can person Excel-created PivotTables to EZ-Pivot formatted PivotTables in lone two mouse clicks.
EZ-Calc is the utopian solution for creating 8 types of premeditated fields: senescent periods; reformatted dates; Excel formulas; moving totals; percentages; extracted text; qualified negatives; and calendar dates to financial subject matter. You can bring into being "Current finished 90 " agings in as few as three rodent clicks, and can age as of nowadays or as of a proper date. And, because they categorize information and cut back the numeral of background points, old extent fields are mastered for the X-axis in PivotCharts and the column paddock in PivotTables.
EZ-Stat is supreme possible the fastest way to cypher statistics for Excel background. With single two clicks, you can turn out "Quick Stats" for any solo notes helpfulness or for all aggregation values that reckon count, sum, average, minimum, maximum, ensign deviation, and normal. Best of all, exported Quick Stats are formatted and printer-ready. EZ-Stat too allows you to initiate "Full Stats" for combinations of up to for fields, say, for respectively unequalled natural event of state, region, goods line, and twenty-four hours. Like the else products, EZ-Stat never modifies the untested Excel roll notes.
Data Presentation Products' piece of computer code takes the spasm out of creating Excel workbooks - and does a bigger job in the process!