| Insert Heat Maps and Traffic Lights |
Insert HeatmapsA heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, etc. |
Heatmaps MultidimensionalCreate Heatmaps combining Image, Font, color, backcolor Cell, Text & font type.... |
Rules TableWith this function you can insert an example that you can re-use or edit according to you convenience to make the categorization from your data. |
RefreshThis option refresh all saved models in your active workbook as modified at the data base. |
Manage ModelsThrough this functionality you will be able to manage in a simple way the refreshing of data. |
Options - Delete ImagesFrom this page you can insert images from the dialog box, simply, choose one cell and select the image you wish. |
Options - Delete IconsWith this function you can delete inserted icons inside the selected range. |
|
| Categorize Databases |
Extract unique casesThis tool extracts unique values from a column in a database. |
Time stratificationThis useful tool stratifies a database, by adding one more column to the database being observed. |
Test the "stratification table sufficiency"To stratify a database we need a stratification table. |
Consolidate rangesWith this tool you can consolidate ranges of different sheets in the open workbooks as closed workbooks as well. |
Stratification 1 to 1Stratification 1 to 1 was created to deal with the frequent need of stratifying a database. |
Conditional textSome times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish. |
Extract recordSome times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish. |
Split field - By groupsUse Split field by groups to split a database in multiple data groups |
Split field - By dateSplit field by date is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday. |
|
| Tools |
Toggle settingsThis powerful tool has been crated to do away with such loss of time. |
Freeze | divide panesWe sometimes work with models whose information does not fit in the screen. |
Sheets managerA comprehensive tool that will make any worksheet management task easier to you. |
Export sheets as...Use the "Export sheets as..." tool, and simplify this task. |
Workbooks managerManaging your open workbooks is made easy with the Workbook manager tool. |
My FavoritesDo you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all. |