In this new version 1.1 of Tools for Excel Tables: Smart Consolidator tool has been improved, now it is called: Multi sheet/database consolidator. Also, a new tool has been added: "Complex formula's consolidation".

Tools for Excel Tables is a part of Model Assistant Suite (which will be released soon); whereby, if you purchase this product you will obtain a special discount for the rest of components.

• Easy select
• Select current region
• Select visible cells
• Analysis
  - Specific cells
  - Easy search
  - Easy search - By text
  - Easy search - By format
  - Easy search - By logic criteria
• Cell's math By format
• Categorize database
• Multiple conditional analysis & formatting
• Sumif & Countif
• Sumif
• Countif
• Duplicates
• Breaches
• List unique cases
• Manager I - E
  - Import
  - Export
• Merge tables
• Split table S
  - Split table - By groups
  - Split table - By date
• Change to text - number
• Concatenate cells
• Multiple conditional data extractor
• Extract unique records
• Multi sheet / database consolidator
• Complex formula's consolidation
• Test the "stratification table sufficiency"
• Time stratification
• Stratification 1 to 1

• Delete
  - Delete rows empty
  - Delete rows hidden
  - Delete rows visible
  - Delete columns empty
  - Delete columns hidden
  - Delete columns visible
• Autofilter
• Sort
• Form
• Viewer
  - Guides
  - Freeze | divide panes
  - Arrange Windows
  - Toggle settings
  - Sheets manager
  - Workbooks manager
• Dinamic table
  - Pivot table wizard
  - Chart
  - Table options
  - Refresh data
  - Refresh all
  - Show field list
  - Show dinamic tables bar
• Bars
  - Show group & outline bar
  - Show dinamic analysis bar
  - Show dinamic manager bar
  - Show viewer bar
  - Show dinamic tables bar

• Multiple conditional data extractor

• Split table by groups

• Stratifying data by time