Скачать или смотреть EASILY understand and debug EXCEL FORMULAS

Debugging a multiple-nested IF in the Excel Formula Bar can be a nightmare of matching different colors of parenthesis… FormulaDesk greatly simplifies the formula editing process with its 3 tools.

Navigator, Math, FormulaSpy add powerful and unique features to Excel that will help you in your work. These apps are great for viewing complex formulas, seeing what cells are used and the results of the functions it, it's an excellent tool for troubleshooting formulas.

The founder behind this, Gareth HAYTER, is very ncie and responsive to requests for assistance, I met him on Facebook so feel free to contact him there or at [email protected]

Still available exclusively here : 30% off using coupon: BF2022 ###
Go to →→→ http://formuladesk.sjv.io/spy ←←← ###

Features :

Instantly understand and troubleshoot complex Excel formulas

See formulas steps and caluclations : You can also expand and collapse the formula parts. The vertical view displays a formula as a tree. Explore the cells that the formula uses, visit them and see their formulas, then drill into their references to gain a deep understanding of the entire calculation chain.

Pinpoint errors instantly : Excel tells you when a formula has an error, but that’s it. Long formulas are even worse...where do you even start to track down the problem? FormulaSpy will pinpoint EXACTLY where the error is – no more guessing or wasting hours of your precious time.

Workbook Detective finds issues quickly. All *errors**, **comments**, **external links**, **data connections* and **invalid data**…all in one place…in a treeview that is easy to navigate.

Live editor with instant feedback : Format the formula at any time by clicking the 'Format'' button. This will auto-indent the formula to make it easier to read.

Good / bad indicator : As you edit the formula, the border will turn green or red to indicate whether the formula is valid or not, making it very easy to check your formula for completeness.

Focus : Click the 'Focus' button to syntax highlight only the formula that contains the cursor - color all other parts of the formula a light gray.

Style Map : The Style Map visually shows where a style is being used

Define allowed styles :will Cell explorer Select the styles you want, and find all instances of cells that have or don’t have it.

Create custom functions (Lambda) from existing formulas as templates without VBA

Convert an existing formula into a custom function by clicking on the parts that you want to convert into variables.

Find and rewrite and rewrite and update formulas that can be enhanced to use the new custom function....with just a few clicks.


I hope you liked it ! Have a great day !
Diane