Navigation: FXLV4_Manager >

Formula Explorer Pro Overview

 

 

 

Formula Explorer Pro Overview

Explorer Pro combines and extends Excel’s Evaluate Formula and Trace Precedents tools to give you improved ways of viewing, validating, editing and debugging formulas:

Modeless and resizable Form – select and modify cells whilst Explorer Pro is showing

Explore Cell formulas, Conditional Format Formulas, Data Validation Formulas and Named Formulas

Forwards and Backwards debug using your arrow keys

View, filter and select the results of array expressions and ranges in both Normal and Debug modes.

Toggle between Expressions, Precedents and Dependents view

oPrecedents include INDIRECT, OFFSET, INDEX and source cells

oClick a reference or function to select its precedents both within and across worksheets.

oSee which precedents are formulas.

oDependents view shows the formulas in the dependent cells

oDrilldown from references to their formulas using right-click (Windows) or Shift-Click (Mac)

Show the source cells that functions like VLOOKUP, SUMIFS, MAX etc. are pulling from

See the results of individual criteria’s in SUMIFS, COUNTIFS etc.

Show the result of IF, CHOOSE, IFS, SWITCH functions

Show filtered results from the arguments of functions like SUMPRODUCT

Indented formula view shows how the parts of your formula fit together, simplifies bracket forests

Auto-scroll to show selected cells

Show formulas and functions in English or local language.

Contract/expand the Treeview of sub-expressions and results

Extensive keyboard shortcuts

Highly customisable user interface

Handles Dynamic Arrays, Linked Data Types, Structured References, 3D references, Named Ranges, Dynamic Ranges, Intersect, Union, Complex References, Whole Column ranges, Used-Range intersection, Constant Arrays and more.

Use the Tooltips, Online help and PDF User guide for a fast understanding of Explorer Pro

 

 

 Clicking this button on the FastExcel Manager Ribbon, or using Control-Shift-M will launch Explorer Pro for the formula in the active cell.

 

The Explorer Pro Userform
The explorer form is modeless and resizable. Because the form is modeless you can interact with the workbook in all the usual ways with the mouse and keyboard whilst keeping the form visible, and switch the focus between the worksheet and the form by clicking with the mouse.

The Indented Formula, Array Results, Expressions /Precedents and Source/Reference Boxes show views of the formula and its results.

The Array Results Box and the Array Results Filter only show when the Filter button is toggled on and the selected expression results in an array of values.

Drag a splitter bar to change the amount of space used by the 4 display boxes within the overall form, or drag the resize button to change the size of the form

Explorer Pro Command Buttons

 

The command buttons give easy access to common tasks. Formula Explorer also has a large number of keyboard shortcuts.

 

 

 

 

 

 

Copyright © 2020 Decision Models Ltd