Español

Model building & testing

Model Analysis Tools

Excel Databases

Financial Models

Online Functions

Presentation Tools

Third Party

Bundles

Art of Categorizing Data for Excel

Categorizing Data for Microsoft® Excel® 2.3.0

If your problem consists in categorizing or stratifying specific data of your Excel spreadsheet information, then this tool is the solution.

Includes!

  • One year support
  • Free resources
  • If you acquire Categorizing Data for Excel you can upgrade to Excel Model Builder or Model Assistant Suite paying only the difference.
View Demo
Sources

Logo Categorizing Data for Excel

Price: US$39.95

Free trial

Buy Now!

 

 

Learn how
to use it

 

    Advanced Tools

 

Extract unique cases Extract unique cases

This tool extracts unique values from a column in a database.

Test the "stratification table sufficiency"Test the "stratification table sufficiency"

To stratify a database we need a stratification table.

Stratification 1 to 1 Stratification 1 to 1

Stratification 1 to 1 was created to deal with the frequent need of stratifying a database.

Categorize databaseCategorize database

Use this practical tool to categorize records in a database, based on a category table.

Time stratification Time stratification

This useful tool stratifies a database, by adding one more column to the database being observed.

Consolidate ranges Consolidate ranges

With this tool you can consolidate ranges of different sheets in the open workbooks as closed workbooks as well.

    Split field

 

Split field - By groups Split field - By groups

Use Split field by groups to split a database in multiple data groups

Split field - By date Split field - By date

Split field by date is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday.

Export sheets as... Export sheets as...

Use the "Export sheets as..." tool, and simplify this task.

Sheets manager Sheets manager

A comprehensive tool that will make any worksheet management task easier to you.

Workbooks manager Workbooks manager

Managing your open workbooks is made easy with the Workbook manager tool.

Freeze | divide panes Freeze | divide panes

We sometimes work with models whose information does not fit in the screen.

Toggle settings Toggle settings

This powerful tool has been crated to do away with such loss of time.

My Favorites My Favorites

Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.