Goal Seek runs on formula cells that do not contain errors
External Sources
Named Ranges
Bar
Line
Area
Spline
Area-Spline
Step
Area-Step
None
Linear
Exponential
Logarithmic
Polynomial
Order:
Power
Duplicate
Rename
Delete
Color
X
Values of
In Scenarios
Value
Author
Scenarios
Manage
Name
Author
Precedents & dependents of
See 'Dependencies TAB' for a larger view and to change drivers' percentage change
Error root cause analysis of
If you are not already in AUDIT Mode, we are activating it for you and showing which is the first precedent cell causing error in this one.
Scenario recording
Cells edited in recording mode automatically create new cases in the cell and link them to the scenario.
After recording, you can rename the scenario and its cases.
Scenarios
Charts
Financial Statements
Select periods, items, and settings on the Settings Panel.
The interest rate is applied to the avarage of current and previous period's outstanding debt.
Visyond can calculate the funding needs automatically or you can set equity and debt manually.
Hover on the items in the Settings Panel or take the page tour (click on Help / Guided Tour) to learn more.
Ratios and KPIs
Income Statement
Balance Sheet
Cash Flow Statement
Refresh project with Excel file
Find and replace
Cells
Replace in all worksheets
Cell
Value
Scenario names
Replace all scenarios
Assign names to rows (e.g. "Revenues") and columns (e.g. "2020") and you will be able to write formulas like "RowName[ColumnName]" (e.g. "Revenues[2020]")Learn more
Audit mode highlights cells by type (e.g. number, formulae, dates, etc.)
Learn more
Audit
Names
Auto Calc
Cycles
Enable Iterations
Maximum Iterations
Apply
Detected cycles. Click on the cells to find them in the spreadsheet.
Import Notes
These cells are different from the imported file. This can be due to unsupported function.