CNET Editors' review
The power and features that make Microsoft's Excel spreadsheet the business world's standard can be daunting to new and infrequent users. EZ-Format for Excel makes Excel easy by separating data formatting, maintenance, and analysis tasks. It automates the task of formatting worksheets, enables improved, modifiable totaling, and simplifies common tasks such as splitting worksheets and applying row color. The program bundles the maker's EZ-Subtotal and EZ-Split add-ins as well, and it includes the functionality of the EZ-Stat statistical analysis software.
EZ-Format for Excel integrates seamlessly with Excel, appearing in the Add-Ins Ribbon on the Toolbar. An extensive welcome page includes links to six automated demos covering the program's main features, such as Formatting and Subtotaling. Step-by-step documentation is amply illustrated with screen shots. The program does its thing on an automatic copy of your Excel data. You begin by creating a Default Formatted Worksheet. A new time-saving feature we like is the ability to save and reuse worksheet formats.
EZ-Format for Excel can help make you a power user in no time. You can finish tasks in less time it would take to just set things up in Excel, and its analysis tools will help you get more out of your data, too. It behaves perfectly in Vista, and it uninstalls cleanly should you opt not to keep it. The 15-day trial version has some features disabled, but the full version comes with free lifetime updates. We recommend it for all users.
Publisher's Description
From Data Presentation Products:
Save time creating better formatted worksheets utilizing dozens of features too time consuming to implement using only Excel. In seconds turn unformatted data into a feature-rich, printer-ready formatted worksheet. Create subtotals mixing counts, sums, and Excel formulas on every subtotal row. Mixing subtotal types reduces the number of Excel subtotal outline levels and improves readability. Subtotals are completely bolded, shaded and correctly display when Excel data filters are set. Change sorts, break fields, subtotaled fields and subtotal types without having to remove and recreate subtotals. Temporarily turn subtotals off and then back on. Drag reference data, like phone numbers, to subtotal rows. Resort worksheets by subtotals to rank subtotaled data. For example, resort subtotaled Customer data by each Customer's Total Sales. Quickly create column totals that adjust to Excel data filters. Easily create re-usable worksheet formats and automatically and identically format new or updated data in seconds. Re-usable formats save even more time by automatically re-creating Excel formula fields. Create standard Excel formulas and EZ-Format's custom Aged Date, Reformatted Date, Conditional Negative, Percent of Total and Running Total formula fields. Easily view only the records and subtotals for each unique value in any field, and export only the visible data and subtotals to a new worksheet in a single click. Includes both a Ribbon and a toolbar for use with Excel 2010, Excel 2007, and with earlier versions of Excel. EZ-Splits three major splitting features are built-in for free use with EZ-Format.
What's new in this version: Version 9.1 improves worksheet splitting including automatic copying of worksheets referenced in the worksheet data being split. Includes fixes, enhancements and improved install for Excel 2007 / 2010.
More Popular Spreadsheet Software downloads
- Microsoft Office Excel 2010
4,284 downloads
- Microsoft Excel 2003
3,023 downloads
- Excel Calendar Template
1,397 downloads
- Kingsoft Spreadsheets
682 downloads
- Classic Menu for Excel 2007
670 downloads
-
All versions:
3.7 starsout of 3 votes
-
Current version:
0 stars Be the first to review this product -
My rating:
Write review
Results 1-3 of 3
-
"EZ-Total is very good"
Version: EZ-Format for Excel 2.1
Pros
I liked the step by step instructions and the movie, which helped me go through each of the features quickly. The sample book demonstrated how easy everything was, and when I used EZTotal on my own stuff--it worked perfectly even though I had a very large data sheet (about 8000 rows). Great performance!!
-
"EZ-Total formats and exports any Excel List easily"
Version: EZ-Format for Excel 2.1
Pros
The simplicity of the interface and the completeness of the documentation makes for learning this product in about the time that the authors predict (15-30 minutes). The real beauty of this product is that it can be used by virtually all Excel users, since everybody at some time or another is faced with an unformatted list of data that a) they want to format or b) they want to analyze or both. One should also check out their EZ-Chart and EZ-Calc products too. This is really cool stuff!
-
"not working"
Version: EZ-Format for Excel 2.1
Pros
nothing
Cons
program is not working
Add Your Review
Submit your reply
E-mail this review
Report offensive content
See more CNET content tagged:
Previous Versions:
