Formula Explorer Pro 6.1
If your workbook has complex formulas or Lambdas, you need Formula Explorer Pro 6.1.
- Understand and Explore formulas, Debug, Change/Save, View Precedents and Dependents.
- Drill Down forwards and backwards to Precedents and Dependents.
- Includes Name Manager Pro to create and manage Named Lambdas.
- Use the LET-LAMBDA Wizard to easily create and modify LET and LAMBDA formulas
- Auto-Indent cell formulas
- Debug Lambdas and Recursive Named Formulas
- Share Named Lambdas and Formulas using Import and Export to an external .txt file.
- Supports Formulas in 21 Languages
- Supports all the new Excel Functions (PIVOTBY, TRIMRANGE, REGEX ...)
- Click the purple components to expand a Named Lambda to its formula, or click the light green component to contract an expanded Named Lambda.
- Watch a short Highlight Video of Explorer 6 including the Let-Lambda wizard and Lambda Export-Import
Explorer Pro changes in 6.1
- Major rewrite of Explorer Pro. Improvements include
- Simplified and improved User Interface/Experience
- Save As to Grid or Name Manager Pro
- Let/Lambda Wizard to build Lambdas and Lets from precedents
- Support of new Excel functions: PIVOTBY, GROUPBY, REGEX etc.
- Supports ETA functions, Trimrange and .:. syntax
- Helper Funcs (SCAN, REDUCE, MAP, BYCOL, BYROW, PIVOTBY ...) show intermediate results
- Tighter Integration with Name Manager Pro
- Works with both spilled cells and parent formulas
- Results Box rewritten to improve formatting, drill-down and performance
- Improved and faster coloring system
- Drill-down to precedents and dependents with undo-redo and bread-crumb trail
- Simplified access to frequently used settings
- Improved ability to explore and debug complex formulas
- Many small improvements and fixes
- Download the 10-day full-featured Trial version of Explorer 6 for Windows
- Explorer Pro requires Excel Dynamic Array support: Excel 365 or Excel 2021 or later
- Latest build is 980.725
- Buy your Explorer 6 License Here
- Add Feedback, Requests and Bugs Here
- Request your Explorer Pro trial License Here
|
