EZ-Format for Excel 5.1

EZ-Format for Excel 5.1 Screenshot Automates dozens of Excel features too time consuming and difficult to manually implement.

Developer:   Data Presentation Products
      software by Data Presentation Products →
Price:  39.00  buy →
License:   Trial
File size:   0K
Language:   
OS:   Windows Vista (?)
Rating:   0 /5 (0 votes)

Automates dozens of Excel features too time consuming and difficult to manually implement.

Quickly turn unformatted data into feature-rich printer-ready formatted worksheets.

With better subtotaling and automatically created Excel Styles. With counts and sums mixed on bolded and shaded subtotal rows, Excel data filters that work with subtotaled data, reference data dragged to subtotal rows, re-sorting subtotaled data from highest to lowest by the subtotals of any field. Easily view and export subsets of data.

Select values from any field and split data into separate worksheets. Includes over two dozen exclusive time-saving formatting and analysis features.

The 'Features' video and Getting Started Tour show how to use each feature. Use with EZ-Chart, EZ-Pivot and EZ-Calc to create better charts, PivotTables and calculated fields.

Here are some key features of "EZ Format for Excel":

  • Subtotals and Totals Microsoft® Excel® Lists containing no totals, column totals or subtotals
  • Never modifies the original Microsoft Excel List
  • Formats manually created Microsoft Excel subtotals or replaces with EZ-Format created subtotals
  • Saves time. Manually created Subtotals requiring 79 clicks require 7 clicks with EZ-Format
  • Optionally ranks subtotaled data by re-sorting all break field groups by the subtotals of any field
  • Subtotal rows are completely bolded and lightly shaded for easier viewing
  • Subtotal shading uses six light gray scale colors
  • Allows mixing of subtotal types such as sums, counts and percents at each subtotal break
  • For percent and average subtotals uses the same formula used for calculating the percents and averages of the data rows
  • Suppresses the display of Microsoft Excel #Errors for data formula subtotals and two other subtotal types
  • Higher level break field values are dragged to all lower level subtotal rows
  • Microsoft Excel Styles are created for all fields and assigned to all data
  • Create a Statistical snapshot that includes the sum, average, minimum, maximum, standard deviation and optionally the mean for each field being totaled or subtotaled for any selected data value in any field
  • Worksheets are printer-ready
  • Print orientation is automatically set
  • Page format includes Company, User, Title, Subtitle, workbook, worksheet and page numbers
  • Page formats can include a user specified graphic when using Microsoft Excel XP / 2003
  • Set default margins for all EZ-Format created worksheets
  • Field descriptions can be wrapped for best fit and smallest overall column width
  • Subtotaled data is automatically sorted by the subtotal break fields
  • Optionally and automatically move subtotal break fields to the left-most columns in break field order
  • Add, modify and delete subtotal fields in 2 clicks when subtotals already exist
  • Drag non-break field data to subtotal rows for display with the subtotal outline level
  • Set columns to hidden in two clicks
  • Set columns to un-hidden in two clicks
  • Toggle viewing and hiding of all columns designated as hidden
  • Toggle subtotal bolding on and off
  • Toggle subtotal shading on and off
  • Toggle hiding and viewing of empty columns at each subtotal outline level
  • Change the order of multiple columns at one time
  • Microsoft Excel data filters are always created and correctly expose subtotal rows when set
  • Double clicking sets and unsets data filters and correctly exposes subtotal rows
  • Select a starting data value and walk the data filter values in any field
  • Set a data filter to select subtotal groups and then show all data within just those groups
  • Set subtotal row height to 1, 1.25,1.5,1.75 or 2 times the data row height
  • Set the default subtotal row height multiplier
  • Turn view gridlines off and on
  • Turn print gridlines off and on
  • Set the initial on / off state of view and print gridlines
  • Export only visible rows in 2 clicks to create workbooks for emailing and reporting
  • Select one or more or all values in any field and create separate worksheets of only the data for each selected value
  • Display and export only detail records without having to remove subtotals
  • Display and export the subtotal records for any single subtotal break level; un-bolded and un-shaded with empty columns hidden and dragged reference data visible
  • Display and export the subtotal row records at and above any subtotal level; with empty columns hidden, dragged reference data visible and the lowest subtotal level rows un-bolded and un-shaded so as to appear as though they are detail data
  • Conditionally format entire rows based upon the conditional formatting in any one column
  • Adds the EZ-Format menu to the Excel Menu bar
  • Adds the EZ-Format tool bar for accessing frequently used features
  • Right-click menus in EZ-Format worksheets re-configure to reflect available EZ-Format features
  • Includes a Sample Workbook containing instructions for quickly learning EZ-Format features
  • Works with Microsoft Excel 2 / XP / 2003 on Microsoft® Windows® 2 / XP / 2003 Server
  • Use EZ-Calc to create eight useful types of calculated fields including Accounting-Type "Date Aging" and "Re-formatted Date" fields
  • All products install in seconds, and completely uninstall as separate products
  • EZ-Format, EZ-Chart, EZ-Pivot and EZ-Calc are included in the EZ-Deluxe product
  • EZ-Deluxe is the economical way to purchase all four EZ products
  • Upgrade to EZ-Deluxe from any one EZ product without a price penalty
  • All products self-register upon purchase if software is currently installed or is subsequently installed
  • All products include life-time free updates for product enhancements and bug fixes

    Limitations
  • 15-day trial

    Requirements
  • Microsoft Excel

    tags microsoft excel  subtotal rows  any field  the data  subtotal break  and export  subtotaled data  break field  the subtotal  bolded and  empty columns  data filters  reference data  

    EZ-Format for Excel 5.1 screenshot


    Download EZ-Format for Excel 5.1

     Download EZ-Format for Excel 5.1

    Purchase:  Buy EZ-Format for Excel 5.1


    Similar software

    EZ-Format for Excel 5.1 EZ-Format for Excel 5.1
    Data Presentation Products

    Automates dozens of Excel features too time consuming and difficult to manually implement.

    EZ-Pivot for Excel 5.1 EZ-Pivot for Excel 5.1
    Data Presentation Products

    Create PivotTables and PivotCharts in seconds.

    Pivot Table Helper 1.0 Pivot Table Helper 1.0
    Afalina Co., Ltd.

    Pivot Table Helper makes working with pivot tables comfortable and fast.

    EZ-Stat for Excel 2.1 EZ-Stat for Excel 2.1
    Data Presentation Products

    EZ-Stat creates commonly used Excel Statistics for the requested numeric fields.

    SQL Converter for Excel 2.0 SQL Converter for Excel 2.0
    Peachtree Communication Systems

    SQL Converter 2 for Excel is an easy-to-use tool that quickly converts your worksheets to real SQL database tables.

    DigDB for Excel 7.1.3 DigDB for Excel 7.1.3
    Excel Add-ins

    Empower Excel for difficult query and data manipulation, delete duplicates and fix links.

    Tools for Excel Tables 1.2 Tools for Excel Tables 1.2
    Jabsoft

    Tools for Excel Tables is a useful and reliable addin which combines the functionalities of Microsoft Excel in order to create more robust functionalities which let you extracting multiple conditional data, splitting tables, smart consolidation, merging tables, categorizing databases, extracting unique records, stratifying data and much more.

    AutoFormat XL for Pivot Tables 1.5 AutoFormat XL for Pivot Tables 1.5
    Afalina Co., Ltd.

    Pivot Table AutoFormat XL allows you to save pivot table formatting and to use it as a format template for your future pivot tables.

    Merge Tables Wizard for Microsoft Excel 3.1.4 Merge Tables Wizard for Microsoft Excel 3.1.4
    Add-in Express Ltd.

    You have two separate Microsoft Excel worksheets with common columns e.

    Excel Merge (Combine) Cells, Columns, Rows & Data Software 1.1 Excel Merge (Combine) Cells, Columns, Rows & Data Software 1.1
    Sobolsoft

    Excel Merge (Combine) Cells, Columns, Rows & Data Software is an application that will help you combine cells in Excel.