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
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 / by logical criteria
Categorize database
Multiple conditional analysis & formatting
Consolidate ranges
Conditional text
Sumif & Countif
Sumif
Countif
Duplicates
Breaches
List unique cases
Manager
I - E
From MSSQL
From MYSQL
From Csv/Text
From Excel
Merge tables
Split table
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 dinamic tables bar
Show group & outline bar
Show dinamic analysis bar
Show dinamic manager bar
Show viewer bar