MS Office Tools

 

Modeling

Others

Finance

 
MODEL ADVISOR Business Software for Everyone  
Why Buy with Us
Check Out
 
Advanced Search
 




Related Sponsors
 
  Tools for Excel Tables    
Tools for Excel Tables

Tools for Excel Tables 4.0.4

Excel tables & Data Management

Essential tools for advanced data analysis and tables management for novice and advanced Microsoft Excel users.

Includes!

  • One year support
  • Free resources
  • Acquire Tools for Excel Tables, you will obtain a 50% special discounting to buy Spreadsheet Presenter software.
Tools for Excel Tables

Price: US$ 44.95

Free trial

Buy Now!

 

Insert Heat Maps and Traffic Lights

   

Insert HeatmapsInsert Heatmaps

A heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, etc.

Heatmaps MultidimensionalHeatmaps Multidimensional

Create Heatmaps combining Image, Font, color, backcolor Cell, Text & font type....

Rules TableRules Table

With 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.

RefreshRefresh

This option refresh all saved models in your active workbook as modified at the data base.

Manage ModelsManage Models

Through this functionality you will be able to manage in a simple way the refreshing of data.

Options - Delete ImagesOptions - Delete Images

From this page you can insert images from the dialog box, simply, choose one cell and select the image you wish.

Options - Delete IconsOptions - Delete Icons

With this function you can delete inserted icons inside the selected range.

 
   

Import/Export

   

 

From ExcelFrom MSSQL

This tool allows you to recuperate data from a database to an Excel sheet, in an easy and friendly way.

From MYSQLFrom MYSQL

This tool allows you to recuperate data from a database to an Excel sheet, in an easy and friendly way.

From Csv/TextFrom Csv/Text

Never was importing a document that easy. This tool makes the importing files a child's play.

From ExcelFrom Excel

Use this practical tool to save a range in or the worksheet or an entire sheet in other file type, i.e. in CSV or TXT format.

     

Select cells

   

Easy select Easy select

Some 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.

Select current regionSelect current region

Suppose you have a database with 60000 records and 250 fields, and want to copy this database in other sheet.

Select visible cellsSelect visible cells

This tool selects all visible cells of a selected range or the entire active sheet. If no range is selected, the entire worksheet becomes the work area.

 
   

   

 

Manager Data

   

Change to text - numberChange to text - number

Some 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.

Concatenate cellsConcatenate cells

Do you wish to join text of many cells to a single cell?
Simply do this:
1. Select the cells of a row that you desire to concatenate....

Multiple conditional data extractorMultiple conditional data extractor

This tool allow to perform filters in a data base. Excel only allows to apply filters that involve a single condition per field.

Extract unique recordsExtract unique records

Use this versatile tool to group records in a database, meeting the rigorousness you will usually need for a given operation.

Multi sheet / database consolidatorMulti sheet / database consolidator

Do you wish to consolidate data come from many sheets contained in more than one workbook and the records are disordered? Then, this tool will make it for you.

AutofilterAutofilter

Use this advantageous tool to filter a database based on specific criteria.

Complex formula's consolidationComplex formula's consolidation

This useful tool allows you to make in a simple way, many arithmetic operations at the same time between spreadsheets.

Test the "stratification table sufficiency"Test the "stratification table sufficiency"

To stratify a database we need a stratification table. It means if the stratification table does not consider all possible cases a given field may take?

Time stratificationTime stratification

This useful tool stratifies a database, by adding one more column to the database being observed.

Stratification 1 to 1Stratification 1 to 1

Stratification 1 to 1 was created to deal with the frequent need of stratifying a database, but stating a 1-to-1 correspondence....

List unique casesList unique cases

Some 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.

SortSort

Sorts an Excel database according to criteria defined for specific field(s)

Extract rowExtract row

Some 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.

Merge tablesMerge tables

Use this valuable tool to merge two databases based on a common field.

FormForm

Analyze a database, record by record, with this valuable tool.

 
   
   

Split Tables

   

Split table - By groupsSplit table - By groups

Use Split field by groups to split a database in multiple data groups, according to repeated values in the selected field.

Split table - By dateSplit table - By date

Split field by date is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday.

   
   

Delete

   

Delete rows emptyDelete rows empty

This tool is especially useful when there are empty cells in a database and we need to delete them all.

Delete rows hiddenDelete rows hidden

Delete hidden records in a database with this practical tool. It is especially hepful when we have grouped our database and hidden repeated records.

Delete rows visibleDelete rows visible

Apply this tool to delete visible columns in a selection. It does not delete columns hidden columns in that selection.

Delete columns emptyDelete columns empty

Use this advantageous tool to delete empy columns in a selection.

Delete columns hiddenDelete columns hidden

Use this convenient tool to delete hidden cells in a selection.

Delete columns visibleDelete columns visible

Apply this tool to delete visible columns in a selection. It does not delete columns hidden columns in that selection.

   

 

Data Analysis

   

Specific cellsSpecific cells

This tool selects cells of a given range, but only taking into account those with a given format.

Easy searchEasy search

This is a useful tool that has been designed to make searching in a data range both simple and efficient.

Easy search - By textEasy search - By text

Steps:
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Easy search - By formatEasy search - By format

Steps:
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Easy search - By logic criteriaEasy search - By logic criteria

Steps:
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.

Cell's math By formatCell's math By format

Use this gainful tool to search all cells in a specific range with a particular background color and to do some math with the results.

Multiple conditional analysis & formattingMultiple conditional analysis & formatting

Multiple conditional analysis & formatting is the tool suitable to format cells in a database based on a criterion previously specified in the decision table.

Consolidate ranges Consolidate ranges

Some 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.

Conditional text Conditional text

Some 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.

SumifSumif

In order to understand the SUMIF option functionality, Think about the following situation...

CountifCountif

In this case, we have a table with the names and the score of each one of them, also a criteria table.

DuplicatesDuplicates

This tool looks for values (or dates) duplicates in a specific column of a selected data base.

BreachesBreaches

If you wish to look for missing records in a data base through a field that contains a sequence (either numeric or date values) this tool will do it for you.

 
   

Viewer

   

GuidesGuides

This tool is specially convenient if you want to navigate throughout databases with records or fields stretching beyond the screen.

Freeze | divide panesFreeze | divide panes

We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the spreadsheet as the headings of our model would no longer be visible.

Sheets managerSheets manager

Use Sheet Manager –a comprehensive tool that will make any worksheet management task easier to you.

Arrange WindowsArrange Windows

We have created a useful tool that will allow you to sort and display all open workbooks on the screen; furthermore, you can view different areas of a workbook.

Workbooks managerWorkbooks manager

Managing your open workbooks is made easy with the Workbook manager tool.

Toggle settingsToggle settings

We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook, we will have to do it one at a time.

   
 

Tools for Excel Tables Bar 2003

   

Tool bar

This tool bar is of 2003

.Tools for Excel Tables Bar 2003

 
   
   

 

 

 
Related Sponsors
 
Our Sponsors



Related Sponsors
 

 
Help, Comments, Suggestions? Tell Us at: webmaster@modeladvisor.com

©2003-2012 MODEL ADVISOR is a registered trademark of JABS All rights reserved.
Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation.