Categorizing Data for Excel 2.4.1

Categorizing Data for Excel 2.4.1 is a good solution for categorizing or stratifying specific data of your Excel spreadsheet information,

It allows you:

• Categorizing records in a database, based on a category table.
• Extracting unique values from a column in a database and building another table with that data.
• Stratifying time by: years, months, weeks and inclusive days lapsed.
• Making stratification based in a correspondence one-to-one.
• Knowing if a particular table is well designed, using "stratification table sufficiency" tool. - Separating a column in its different parts o categories
• And more...
  

Categorizing Data for Excel is a part of Model Assistant Suite; wherefore, if you purchase this product you will obtain a special discounting for the rest of components.

Major Features:

1. Advanced Tools
   
   • Extract unique cases: This tool extracts unique values from a column in a database.
   • Test the "stratification table sufficiency": To stratify a database, need  a stratification table.
   • Stratification 1 to 1: Stratification 1 to 1 was created to deal with the frequent need of stratifying a database.
   • Categorize database: Use this practical tool to categorize records in a database, based on a category table.
   • Time stratification: This useful tool stratifies a database, by adding one more column to the database being observed.
   • Consolidate ranges: With this tool you can consolidate ranges of different sheets in the open workbooks as closed workbooks as well.
2. Split field
   
   • 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 is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday.
   • Export sheets as...: Use the "Export sheets as..." tool, and simplify this task.
   • Sheets manager: A comprehensive tool that will make any worksheet management task easier to you.
   • Workbooks manager: Managing your open workbooks is made easy with the Workbook manager tool
   • Freeze divide panes: Sometimes work with models whose information does not fit in the screen.
   • Toggle settings: This powerful tool has been crated to do away with such loss of time.
   • 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.

Enhancements:

• Added validations for sheets with spaces in the name

Requirements:

• Microsoft Excel 2000 or more.