Data Presentation Products
 
Microsoft Excel Tools  
 
Microsoft Excel Add-ins  

   

 
  HOME > PRODUCTS > EZ-Format
 

 
EZ-Format for Microsoft ® Excel ®

Six of eight EZ-Calc fields are included in EZ-Format

Create these Excel Formula Fields when formatting data with EZ-Format
and save for automatic recreation in Reusable Worksheet Formats.
Click links below to watch Calculated Field "How-to" Videos.

After watching click "Back" or Alt+"Left-Arrow" to return to this page.

Aged Date      Reformatted Date      Excel Formula

Running Total      Percent of Total      Conditional Negative

15-Day EZ-Format Trial      EZ-Calc Product Page



EZ-Format
Better Formatting, Analysis and Increased Productivity!

Format and Manipulate Data in Ways that are Manually Impossible!
Quickly Format Data Using Excel's Most Popular Features!
Create Reusable Formats for Completely Automatic Formatting!


New!  Selectively exclude columns when Splitting Worksheet Data.

Mouse-over Ribbon for Tooltips and Click to
Watch "How-to" Video on Highlighted EZ-Format Feature.

After watching Video on YouTube, click "Back" (or Alt+"Left-Arrow") to return to this page.
Videos cover all versions of Excel.  Descriptions and Times of all Videos are on the New EZ-Format Movie Page.

EZ-Format Menu - No Video EZ-Format Settings Menu - No Video Delete EZ-Format Formatted Worksheet Automatic 'Default' Formatting of New Data Sort and Subtotal Stats Menu (below) - Quick Stats Video Format for Printing and Print Preview - No Video Standard Print Dialog - No Video Maintain Column Totals Turn Subtotals Off and On, and Remove Subtotals Export Visible Rows - No Video Split Sheet Menu (below) - Split Worksheet Video View Excel Subtotal Outline Levels Select Reusable Worksheet Format Save / Delete Reusable Worksheet Formats - No Video Formula Field Menu (below) - Add Formula Field Video EZ-Format's 8 Excel Style Features Create Excel Conditional Format Sort and Subtotal Field Order Rank / Resort Subtotaled Data Set Field Widths and Wrap Data Drag Reference Data to Subtotal Rows Hide Fields and View Hidden Fields Clear Data Filters and Show Non-Hidden Columns Show Data and Subtotals one Filter Value at a Time Select 'Full Stats' Break Field for Walking - No Video Bold and Shade Subtotal Rows View only Break, Subtotaled and Dragged Fields Filter Views Menu and Reapply Simple Data Filter - No Video Set Break Field 1 Subtotal Row Height

Ribbon and Toolbar Menus with 10 Videos for Major Features.

  Toolbar Icon for 'Stats' Menu
Stats Menu
Choose the Quick Stats video below. Quick Stats Video Range Stats
Video Coming Soon Full Stats
Video Coming Soon Export & Format Full Stats
Video Coming Soon Export Full Stats List
Video Coming Soon Export Full Stats Snapshot
Video Coming Soon Modify Q-Stat Chart Format
Video Coming Soon Restore Q-Stat Chart Default
Video Coming Soon
Quick Stats Video

Toolbar Icon for 'Split Sheet' Menu
Split Sheet Menu
Choose from the three videos below. Split Worksheet by Single Values Video Split Selected Worksheets to New Workbooks Video Split Selected Values to New Worksheet Video Open Split Workbook Folder
Video Coming Soon Set Split Workbook Folder
Video Coming Soon Set Last Title Row
Video Coming Soon Delete All Split Workbooks
Video Coming Soon
Three 'Split Sheet' Videos

Toolbar Icon for 'Formula Field' Menu Formula Field Menu
Choose from the six videos below. Add Formula Field Video Add Reformatted Date Field Video Add Aged Date Field Video Add Conditional Negative Field Video Add Running Total Field Video Add Percent of Total Field Video Modify Formula Field Description
Video Coming Soon Apply Formula to All Detail Rows
Video Coming Soon Delete Formula Field
Video Coming Soon
Six 'Formula Field' Videos
 

Access the Identical Features from the EZ-Format Toolbar in Excel 2000, XP and 2003.

The EZ-Format Excel Toolbar

EZ-Format is the Only Add-in For Excel to Automatically
Create Identically Formatted User-Defined Worksheets.


After quickly formatting data, create Re-Usable Worksheet Formats to identically format new data for the same set of fields.



Download 15-Day Trial     Purchase for $49.95

Latest update 01/14/2012

Installs and Completely Uninstalls in Seconds.  Securely Purchase from inside Excel.
Use with Excel 2000, XP, 2003, 2007 & 2010 on Windows® 2000, XP, Vista® & Windows 7®.
We recommend running Windows Update for Windows and Office® before installing EZ-Format.


Exclusive Time Saving, Productivity Enhancing Features:

Quick and Easy Formatting Using Excel's Most Popular Features.

User Designed Reusable Formats for 100% Automatic Formatting.

Create Five Custom Fields and User-Defined Excel Formula Fields.

Better Formatted Subtotals are Easy to Create, Modify and Manipulate.

Subtotal Rows are exposed when Excel Data Filters are set.

Resort or Rank Subtotaled Data by the Subtotal Amounts.

Split Column-Totaled and Subtotaled Data by Values in any Field.

New!  Selectively exclude columns from split worksheets / workbooks.

Export Visible Worksheet Rows retaining All Formatting.

Export Subtotals for any Break Field to Create Excel Charts.

Instantly Analyze Data using Excel's 29 Standard Formulas.

Use EZ-Format with manually maintained data,
database exports, Site Server exports,
Dynamics GP SmartList exports ... all Excel data.


Licensed by User and by Enterprise Versions of Office.