Tools for Excel Tables

  

 
 
Use Tools for Excel Tables
 
Import/Export
     Import From MSSQL
     Import From MYSQL
     Import From Csv/Text
     Import From Excel
 
Select cells
Easy select Easy select
Select current region
Select visible cells
 
Manage data
Change to text - numberChange to text - number
Concatenate cellsConcatenate cells
Multiple conditional data extractorMultiple conditional data extractor
Unique recordsExtract unique records
Multi sheet / database consolidator
AutofilterAutofilter
Complex formula's consolidation
Test the "stratification table sufficiency"Test the "stratification table sufficiency"
Time stratificationTime stratification
Stratification 1 to 1Stratification 1 to 1
Extract unique casesList unique cases
SortSort
SortExtract row
Merge tablesMerge tables
            Form
   Split
    Split field - By groups Split table - By groups
    Split field - By date Split table - By date
   Delete
Delete rows emptyDelete rows empty
Delete rows hiddenDelete rows hidden
Delete rows visibleDelete rows visible
Delete columns emptyDelete columns empty
Delete columns hiddenDelete columns hidden
Delete columns visibleDelete columns visible
 
Data Analysis
Specific cells
Easy searchEasy search
    Easy search - By text
    Easy search - By format
    Easy search - By logic criteria
Cell's math By formatCell's math by format / by logical criteria
Categorize databaseCategorize database
Multiple conditional analysis & formattingMultiple conditional analysis & formatting
Consolidate ranges
Conditional text
Sumif & CountifSumif & Countif
    Sumif
    Countif
DuplicatesDuplicates
            Breaches
        Outline
        Data Tools
 
Insert heat Maps
Insert Heat Maps
  Options
Delete Icons
Images
Refresh
Manage models
 
 
View
GuidesGuides
Freeze | Divide PanesFreeze | divide panes
Sheets ManagerSheets manager
Arrange WindowsArrange Windows
Workbooks ManagerWorkbooks manager
Toggle Settings Toggle settings
 
Jabsoft
Help
Tip of the day
Conditions of use
More interesting products
Web Shortcuts
Go to Model Advisor
Check upgrades / updates
Register Tools for Excel Tables