Tools for Excel Tables  

 
Note:
If you have installed the antivirus Nod 32 is very probable that you need to do the following configuration as it is show in the next video:
Tools For Excel Tables - Nod 32
 
Use Tools for Excel Tables
 
Easy select Easy select
Select current region
Select visible cells
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
Extract unique casesList unique cases
Manager
    I - E
      Import From MSSQL
      Import From MYSQL
     Import From Csv/Text
     Import From Excel
Merge tablesMerge tables
   Split table
    Split field - By groups Split table - By groups
    Split field - By date Split table - By date
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
Complex formula's consolidation
Test the "stratification table sufficiency"Test the "stratification table sufficiency"
Time stratificationTime stratification
Stratification 1 to 1Stratification 1 to 1
   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
AutofilterAutofilter
SortSort
            Form
Viewer
GuidesGuides
Freeze | Divide PanesFreeze | divide panes
Arrange WindowsArrange Windows
Toggle Settings Toggle settings
Sheets ManagerSheets manager
Workbooks ManagerWorkbooks manager
Dinamic table

Pivot table wizard

ChartChart
            Table options
Refresh dataRefresh data
Refresh allRefresh all
Show field list Show field list
Show dinamic tables barShow dinamic tables bar
Bars
Show dinamic tables barShow dinamic tables bar
Show group & outline barShow group & outline bar
Show dinamic analysis barShow dinamic analysis bar
Show dinamic manager barShow dinamic manager bar
Show viewer barShow viewer bar