Advanced Tools |
|
|
This tool allows us to make graphical comparisons In a twinkle, about data series, using charts. |
Execute all models we may have previously saved with any of the following tools:
Spreadsheet goal seeker
Consolidator ... |
|
Do you wish to consolidate data come from many sheets contained in more than one ... |
The cell or range that you want to change is called: Define the cell/range to change . This item must always contains a formula or a function... |
|
This useful tool allows you to make in a simple way, many arithmetic operations at the same time between ... |
Let's build a breakeven (no earnings nor losses) of a specific business.
e.g. We want to calculate how many units of each product we need to sell in order to ... |
|
This useful tool detects whenever one enters data that will cause an error in the formula. |
This tool copies the selected sheets from each chosen workbook to a existent workbook or to a new workbook. Afterwards, it consolidates the same range from each sheet in a ... |
|
This useful tool makes easy the process of to consolidate information proceeding from ... |
Multiple conditional analysis & formatting is the tool suitable to format cells in a database based on a criterion previously specified in the decision table... |
|
This type of consolidation is appropriated if you want to see the detail along with the totals Let's illustrate this ... |
This useful tool performs mathematical calculations (adding, counting, finding highest, etc.), using cells that meet a given criteria (greater than, less than, equal to, etc.).... |
|
Conditional Text is the tool suitable to format cells in a range/database based on a criterion previously specified... |
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.
The following database will be ...
|
|
With this tool you can consolidate information of precedent ranges from different sheets in only one range. |
|
Auditing |
|
|
This useful tool allows you to perform a variety of operations with the external and internal links with a ...
|
This tool allows you to perform a series of operations with the named ranges.
Many times workbooks have erroneous names ... |
|
This tool enables us to view formulas in a different, friendlier manner.
It is a great help, since there are many times when we ... |
This tool allows you to quickly and safely search for special cells in your models.
Internal Links, External Links, Constants in a formula, Validation, Array formulas, etc... |
|
This tool will allow you to quickly search for cells with formulas involving elements
used in analysis, such as Array Formulas, cells with validation and ... |
This auditing tool will help you to quickly detect cells with various types of problems, whether deliberate, or otherwise, problems, which, without the use of advanced tools ... |
|
With this tool you will be able to make comparison of formulas and values of the datas of a range. |
|
Reference Analyzer |
|
|
This versatile tool allows you to navigate between the cells which originate and/or depend on a ... |
This tool was designed to track circular references.
In other words, Many times, in our models there are circular references which we do not know where they came from. |
|
This tool is meant to make up for the errors of Excel's Trace Error tool.
Excel has a tool called Trace Error, which, to ... |
This utility as it´s name indicates, allows us to analize in a specific range, a group of formulas and all the precedence/dependence connections between them. |
|
This tool shows all origin links which may exist between formulas of a selected range.
To use this tool, do as follows ... |
This option removes all arrows indicating origin links in the selected range.
Simply select the desired range and ... |
|
This tool shows any and all dependence links which may exist between formulas of a selected range... |
This option removes all arrows indicating origin links in the selected range... |
|
This tool bar option erases all origin and/or dependence link arrows from the active sheet... |
|
Formula Tools |
|
|
This tool allows you to interchange data contained in two ranges, in a simple manner... |
This tool transposes the data selected in the indicated range.
Have a look at the example ... |
|
This useful tool allows you to paste a cell range to get linked to the original range.
When Excel pastes ... |
This interesting tool permits the interchanging of values of a selected range.
In other words, the value of the first cell is positioned ... |
|
Whenever we apply the percentage format to a range, using the tool available in Excel, we notice that the ... |
It is often the case that we wish to convert numeric values into text, to then perform certain calculations using the same values which have been converted to text.
|
|
This useful tool converts all formulas of a selected range into values, in the simplest possible way: a single click. |
Can you imagine how useful it would be to have a dialogue box that would allow you to perform on the spot calculations? |
|
With this tool you will be able to modify in your formula the references towards a determined
cell by references towards other specific cell. |
|
Wizards |
|
|
Have you ever tried to build a formula containing several embedded IFs? Complicated, right?
We know that too But ... |
This practical tool allows you to find the weighted average of a set of values.
Let us see the following |
|
This useful tool detects whenever one enters data that will cause an error in the formula... |
This useful tool allows you to sum and count data regarding to conditions specified in a criteria table... |
|
Wizard intersect is the tool that searches for a table's intersections.
There are two cases with regard to intersections ... |
This tool is very useful to create cells in a snap. So, we don't need to build complex formulas; In other words, "Get cell's value" let us to build formulas that indirectly, reference to ... |
|
Do you wish to join text of many cells to a single cell?
Simply do this... |
|
Quick Edition Tools |
|
|
Many times we wish to change or add a formula to a value or to a cell, or part of another formula... |
This useful tool allows you to change the sign of a range or cell containing formulas or values. |
|
Do you need to copy exact formulas from one range to another?
Excel, when copying formulas, does it with ... |
This tool copies all values / formulas, from one column, towards the right... Until it finds the first empty cell in the cell above. |
|
This tool copies all values / formulas, from one row, going down... Until it finds the first empty cell in the cell below to the left... |
This tool quickly fills a selected range with the data found in the first row / column / cell, respectively...
|
|
This function copies formulas from one range to another.
Let us look at the following example ... |
This tool quickly fills a selected range with the data found in the first row / column / cell, respectively. Let us see how it works ... |
Model Navigation |
|
|
Your workbooks have so many sheets you find it hard to manage them?
Use Sheet Manager - A comprehensive tool that ... |
Managing your open workbooks is made easy with the Workbook manager tool.
With this tool you can: ... |
|
Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all. |
Do you need to select important cells in your model?
Use this powerful tool to select and manage them ... |
|
This useful tool allows you to manage any pending tasks related to a given workbook that may be key to your projects, in an ordered manner ... |
With this tool you will be able to check the progress of your projects.
The accomplishment of a project usually means to work with the same... |
|
Use Password list (manager) to view/add/delete/edit your password for MS Excel and MS Word files. If you open a file with a password ... |
|
Tools |
|
|
Remove text from the left or the right. Also you could add text from the beginning ot the end. |
Use the Add Text as Number Format to have numbers with letters combinations. |
|
Customize cell alignment to right or to the left with this tool |
Get exponents written with this tool, either at the beginning or at the end of a stream of characters. |
|
We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook ... |
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 ... |
|
We sometimes work with models whose information does not fit in the screen. And we may get lost as we navigate throughout the ... |
Do you wish to browse several workbooks at the same time?
Or better yet: do you want to check different parts of a workbook at the same time? |
|
The selected range is automatically detected as the search range.
If that is not the range to be searched, you may choose another ... |
1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar ... |
|
Click on the Easy Search button in the toolbar.
The selected range is automatically detected as the search range ... |
This tool selects cells of a given range, but only taking into account those with a given format. Consider the following example ... |
|
Quick fill is the tool that allows you to fill ranges with consecutive values, in a simple manner. Let us see an illustrative example ... |
|
Other Useful Functions |
|
|
There are two option buttons in the Camera Tools frame: Excel's image and Dynamic. Choose any. Then ... |
This tool makes printing and previewing Areas, Charts, Views easier ... |
|
Use Set alarm to receive a reminder if you have a meeting or need to do something special. |
This useful arithmetical calculator, in addition to performing the most common calculations, makes it possible for us to copy data from a cell in the active ... |
|
You can copy the customized colors from another open book.
Then select the wished book in the window that ... |
This tool will allow you to change Excel's color palette, making it possible for you to have fresh colors with a more professional and personalized tone ... |
|
If you are using MS Excel, you add the document to the recent MS Excel list ... |
Select the options you want to clear and press the OK button. Clean History is available using the Fast Close ... |
|
Use the Fast close Button to save/close open workbooks with a single click. Save your work if you have a meeting immediately!!! |
|
| |
|
Tools Bars |
|
|
|
