Categorizing Data for Excel
Categorizing Data for Excel can categorize or stratify specific data of your Excel spreadsheet information.
Categorizing Data for Excel is an addin for Microsoft Excel that, 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...
Now, with Categorizing Data for Excel you can insert Heatmaps. A Heatmap is a graphical representation of data where the values
taken by a variable, in a two-dimensional (or more) map, are represented as colors, size, background, etc.
With Heatmaps you can analyze your data with up to 5 dimensions, using: 1. Font Size. 2. Font Color. 3. Font Type. 4. Background
Color. 5. Inserting Images.
- Windows ME/2000/XP/2003/2008/Vista/7
- Excel 2000 or more
- 128 MB RAM
|License:||Free to try, $49.95 to buy|
Key Features of Categorizing Data for Excel:
- 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 we 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.
- 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
We 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.
| RELATED SOFTWARE DOWNLOADS FOR CATEGORIZING DATA FOR EXCEL
- SQL Image Viewer
can retrieve, view, convert and export images from your database.
- blueshell Data Guy Professional
ADO-based editor for all types of databases.
- Merge Tables Wizard for Excel
Lookups and merges matching data in Excel worksheets.
- D-Softs Database Comparer
is a database schema and data comparison tool.
- Tools for Excel Tables
Excel data analysis and tables management software.
- SQL Server Comparison Expert
is a powerful MS SQL database comparison and synchronization tool for automating data migrations, analyzing corrupted data and restoring data from backups.
- NetFlow2SQL Collector
can be used to receive NetFlow packets from Cisco and other routing devices and store their contents into databases on Microsoft SQL Servers or/and MySQL servers for later retrieval and analysis.
- OmniForm Premium
can convert paper forms to digital, design from scratch and manage the data collection digitally with no programming experience.