MS Office Tools

 

Modeling

Others

Finance

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




Related Sponsors
 
  Conditional Formatting for Excel    
Conditional Formatting for Excel

Conditional Formatting for Microsoft Excel 2.2.4

Analyze your Microsoft Excel spreadsheets' information easily and swiftly, using "n" levels of Conditional Formatting available with this powerful tool.

Includes!

  • One year support
  • Free resources
  • If you acquire Conditional Formatting for Excel you can upgrade to Model Builder for Excel paying only the difference.
Conditional Formatting for Excel

Price: US$ 29.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.

 
   

Format

   

 

Specifying cellsSpecifying cells

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

Searching easily Searching easily

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

...By format...By format.

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

...By logic criteria...By logic criteria

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

...By text...By text

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.

Cell's math by format -ModelsCell's math by format -Models

After having entered the data required by the dialogue box, we can save this model for future needs. Thus, we will not need to enter the same data many times.

Cell's math by Logical criteriaCell's math by Logical criteria

After having entered the data required by the dialogue box, we can save this model for future needs. Thus, we will not need to enter the same data many times.

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

Saving modelsSaving models

You often happen to run the same models once and again, so the process of filling in the same information becomes repetitive.

Cell's math with selected cellsCell's math with selected cells

You may want to do some math only with selected cells in the active worksheet

Conditional TextConditional Text

Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified in the decision table.

Sumif & CountifSumif & Countif

This useful tool allows you to sum and count data regarding to conditions specified in a criteria table.

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.

 
   
   

Tools

   

Exporting sheets as...Export sheets as...

Do you only wish to export any sheets of your workbook? Use the "Export sheets as..." tool, and simplify this task.

Managing SheetsSheets Manager

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

Managing WorkbooksWorkbooks Manager

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

Freeze | dividing panesFreeze | dividing panes

We sometimes work with models whose information does not fit in the screen.

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.

My FavoritesMy Favorites

Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.

   
   
   

 

 

 
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.