DPPI Excel Add-ins
Loading...
44
subscribers
128,164
video views
Uploaded videos
1-10 of 55-
Splitting Selected Worksheets to New Workbooks
ClintEJr
270 views
Demonstration of spliting all or selected worksheets in the active workbook to new individual workbooks.
-
Splitting Multiple Data Values to a New Worksheet
ClintEJr
103 views
Demonstration of splitting multiple values from any field in a non-subtotaled worksheet to a new worksheet in a memory workbook. Optionally create a new separate worksheet...
-
Creating an Aged Date Formula Field
ClintEJr
159 views
Demonstration of EZ-Formats 'Add Aged Date Formula Field' featurefor creating 'Aged Date Fields' by day, week, month and two accounting type agings. All options for creati...
-
Creating a Reformatted Date Formula Field
ClintEJr
91 views
Demonstration of EZ-Formats Reformatted Excel Formula Field. Quickly and easily create any of twelve different reformatted date formats in non-subtotaled and subtotaled EZ...
-
Creating a Running Total Formula Field
ClintEJr
253 views
Demonstration of EZ-Formats Running Total Excel Formula Field. See how to quickly create a running total Excel formula field in both non-subtotaled and subtotaled EZ-Forma...
-
Creating a Percent of Total Formula Field
ClintEJr
1,371 views
Demonstration of EZ-Formats Percent of Total Excel Formula Field. The Percent of Total formula field calculates each amounts percent of the Grand Total for numeric fields ...
-
Creating a Conditional Negative Formula Field
ClintEJr
70 views
Demonstration of EZ-Formats Conditional Negative Field for selectively changing positive amounts to negative amounts based on the values in a second field. This custom Exc...
-
Calculating Quick Stats for Excel Data
ClintEJr
53 views
Demonstration of EZ-Formats Quick Stats Feature.
-
Selecting a Reusable Worksheet Format
ClintEJr
149 views
Demonstration of EZ-Formats Select Format Feature for automatically formatting a new or updated set of original data identical to the selected worksheet format.
-
Creating Workbooks for Individual Values
ClintEJr
68 views
Demonstration of Splitting a Worksheet by Selected Values using EZ-Format.
Advertisement
About DPPI Excel Add-ins
Time Saving Excel Add-ins for formatting worksheets, workbooks, charts, PivotTables, PivotCharts and PivotTable Drill sorksheets.
The only Excel add-ins to automatically format data to create 100% identically formatted worksheets and workbooks incorporating Excel's major formatting features.
less
Time Saving Excel Add-ins for formatting worksheets, workbooks, charts, PivotTables, PivotCharts and PivotTable Drill sorksheets.
The only Excel add-ins to automatically format data to create 100% identically formatted worksheets and workbooks in...
more
more
less
Play all(55)