Data Presentation Products
 
Microsoft Excel Tools  
 
Microsoft Excel Add-ins  

   

 
  HOME > MOVIES - ALL ADD-INS > Movies - EZ-Format
 

 
"How-to" Videos on Using EZ-Format Features
for Quickly Formatting Excel Worksheet Data,
Automatically Formatting Excel Worksheet Data,
Manipulating and Analyzing Worksheet Data
and Summarizing Data for Creating Charts.


 
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.
These videos cover all versions of Excel.  Descriptions and Times of all Videos are listed below.

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

  "How-to" HD Video Title on YouTube Runtime
Released
 


31. Splitting Selected Worksheets to New Workbooks
3:25


   
12/15/2010



30. Splitting Multiple Data Values to a New Worksheet
2:42


   
12/15/2010



29. Creating an Aged Date Formula Field
6:18


   
12/08/2010



28. Creating a Reformatted Date Formula Field
3:12


   
12/03/2010



27. Creating a Running Total Formula Field
2:45


   
12/03/2010



26. Creating a Percent of Total Formula Field
3:07


   
12/02/2010



25. Creating a Conditional Negative Formula Field
4:55


   
12/02/2010



24. Calculating Quick Stats for Excel Data
4:56


   
11/14/2010



23. Selecting a Reusable Worksheet Format
2:26


   
11/02/2010



22. Viewing Data at Subtotal Outline Levels
4:42


   
11/01/2010



21. Creating Workbooks for Individual Values
1:30


   
11/01/2010



20. Creating Workbooks for ... Values (EZ-Split)
1:26


   
10/31/2010



19. Ranking Subtotaled Data by Subtotal Amounts
2:00


   
10/31/2010



18. Default Formatting Worksheet Data
3:45


   
10/31/2010



17. Creating Fixed Width Fields and Wrapping Data
3:46


   
10/30/2010



16. Reordering Worksheet Columns / Fields
1:24


   
10/28/2010



15. Clearing Data Filters and Redisplaying Fields
2:30


   
10/28/2010



14. Turning Subtotals On and Off & Removing
2:07


   
10/27/2010



13. Deleting an EZ-Format Formatted Worksheet
2:35


   
10/27/2010



12. Viewing Only Subtotal Related Fields & Data
2:37


   
10/26/2010



11. Hiding and Unhiding Worksheet Fields
3:04


   
10/23/2010



10. Bolding and Shading Subtotal Rows
2:42


   
10/22/2010



09. Changing the Row Height of Break Field 1
2:45


   
10/22/2010



08. Displaying Data & Subtotals one Value at a Time
3:00


   
10/22/2010



07. Double-Clicking to Set and Unset Data Filters
3:47


   
10/21/2010



06. Dragging Non-Subtotal Data to Subtotal Rows
2:40


   
10/19/2010



05. Eight Features for Maintaining Excel Styles
4:30


   
10/18/2010



04. Creating Excel Conditional Formats
3:44


   
10/18/2010



03. Creating User-Defined Excel Formula Fields
5:29


   
10/16/2010



02. Sorting and Subtotaling Excel Data
3:17


   
10/13/2010



01. Creating Adjustable Column Totals for Excel Data
4:35


   
10/12/2010


 
All videos were created in high-definition using Techsmith's Camtasia Studio.

If you have suggestions for new EZ-Format Videos, comments about these Videos, or questions about our EZ-Format Add-in for Microsoft Excel please email them to: sales@datapresentation.com