Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Tools for Excel Tables

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Excel: Time Stratification

BUY | Tools for Excel Tables Start

Time Stratification

This useful tool stratifies a database, by adding one more column to the database being analysed.  To use this tool you need at least one date-type field in your database, then you have to choose the type of stratification (yearly, monthly, etc..)

The next example shows a yearly criterion:

The result is shown below:

If you wish you check the pivot table checkbox and a pivot table of your results will be created.

You will note that the dialog enlarges and provides us with the option to choose the field to be analyzed and the mathematical operation to be done.

Notice that the Year option has been added, because we chose a yearly stratification.

In addition, this tool has the option of stratifying a table with a more sophisticated criterion, * By number of days elapsed.

This option works as follows:

Let's see the example:

The result is the following:

If applicable, the corresponding pivot table would have been created. You may modify the table created by dragging and dropping the appropriate fields.

Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

See Also: Excel Add-ins Index & Excel Training Index & Excel Templates Index & Neural Network Software Index Trading Software Index & Charting Software Index Or, All Software

Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft