Visyond Help Home
  1. Home /
  2. I would like to... /
  3. I am new to Visyond: Product Tour
I am new to Visyond: Product Tour

I am new to Visyond: Product Tour

Welcome to Visyond, a cloud-based secure Excel-compatible spreadsheet modeling, auditing, analysis and visualisation platform. It will carry out, in minutes, tasks that take now days of error-prone manual setups, will reduce costly accidental errors, and make decision making faster, more accurate and interactive. Anywhere you are, on any platform.

Decision making requires a combination of modeling, analytics, knowledge management, data visualization and reporting competencies and tools. Analysts, experts, clients, executives (CEOs, CFOs, etc.) must collaborate with strict requirements on data security and governance.

 

FAQs

Before getting into the tour, we would like to answer a few questions you may have.

How easy it is to start using Visyond?

Visyond is very easy to use  – it looks and feels like a general spreadsheet.

Visyond does not require installations or complex setups – it works in the browser. 

All you need to do is to create a free account and get started.

Can I work on my Excel projects?

Yes. We support Excel syntax and formulas so you can import most Excel files or create a project directly in Visyond using the same skill set you need to create an Excel file.

You can also export to Excel.

You can start from scratch in Visyond or import from Excel

How to learn Visyond?

We use a spreadsheet-like interface you are familiar with and it will take you a very short time to master the platform.

There are no menus to learn. Any action that can be carried out on a cell is listed in a context menu.

When you are on the project page, you will find a comprehensive Help & Training contextual menu and many tooltips:

  • TRAINING MODE will walk you through the features and workflows on the page (see below)
  • Do you need to contact us? Click on TALK TO US
  • You can look for helpdesk articles directly from the application by typing in the search bar

Below is an example of the Training Mode on the main spreadsheet page.

Intro
Training Mode

 

When you activate Training Mode on any module, you will see the few steps necessary to master that module.

Is Visyond secure?

Yes. We use industry-standard best practices to store data.

Can Visyond be deployed on premise?

Yes. We can install Visyond on premise so you control your servers.

How fast is Visyond?

Visyond is as fast as online leading platforms can be. It runs in the browser and its performance should be compared to Excel 365, Google Sheets and other online tools.

Install the latest version of your browser for the best user experience (we recommend Google Chrome).

Also, close unneeded applications, tabs and browser windows to free up memory.

Product Tour

Visyond is a comprehensive and versatile platform where all stakeholders can work and view or interact with only what they need.

This is to avoid sensitive data being unwillingly exposed, or simply to shield stakeholders from information overload and confusion (e.g., a decision maker may not want to locate the input cells to change for a what-if analysis, and an expert may only be concerned with entering assumptions).

Therefore, before starting the tour, you have to consider the most important aspects of your analytical decision making and reporting process, so you can explore the most relevant sections first.

You and your collaborators will work on the same project without overwriting one another, and all changes will be tracked

Visyond is a secure single source of truth enabling spreadsheet Governance and Data Tracking

No risk of overwriting someone else’s assumptions and analyses because, unlike other online spreadsheets (where the last edit overwrites the existing one), multiple inputs can coexist in a cell (you can switch between assumptions). Nobody, including the project owner, can modify data entered by others: Visyond protects data integrity and fosters accountability.

Multiple collaborators can work on the same project and Visyond will track and report who added assumptions or attached supporting documents inside the cell, when and why.

This prevents version chaos and the risk of exposing sensitive data while sharing via email or other channels.

No risk of multiple architectural changes while someone is working on the model, or that someone makes a decision based on an outdated version.

You will collaborate with your colleagues and consolidate data without the madness of going through email threads and attachments.

You can create charts and analyses and share them via interactive online slides that act as a virtual sandbox where collaborator can stress test the model in an intuitive and streamlined environment, without interacting with or risking to break the model.

 

You will share only specific worksheets and interactive reports with specific collaborators

Visyond is a secure spreadsheet collaboration and reporting platform with very granular sharing options

Besides the permission system (owner, editor, viewer), you can share specific worksheets and reports with specific collaborators in order to control information flow, improve data privacy and let everybody focus on their tasks.

You can share specific worksheets and Reports / Slides by setting permissions directly on the worksheet o report.

Click on the key icon of a worksheet or a report to select who can see it.

Or, use the general sharing panel on the top bar where you can manage collaborators; permissions, including what worksheets and slides they have access to.

Once you have built your model, gathered data from collaborators, run your what-if analyses, you want to be able to present or share reports with the insights of your work.

With Visyond this is done automatically: a summary of the input (values, attachments, comments), scenarios, and analyses can be visualised or printed as HTML or PowerPoint slides.

Interactive Presentations

Visyond Slides allow you to build interactive dashboards where you and your collaborators can test different assumptions without touching the spreadsheet.

You can share slides with people who do not need to see the spreadsheet but are only interested in testing a few input and output cells or looking at a sensitivity analysis.

Slides act as a calculator driven by the spreadsheet. Changing data on the slide  does not make changes to the spreadsheet. This ensures spreadsheet’s integrity even if many people are working on it through interactive slides.

You will visualize and understand spreadsheets’ structure, errors and anomalies as you type

Visyond is a spreadsheet auditing platform that highlights model structure, errors and potential anomalies in real time

Get immediate insights and save hours of tedious work tracing errors or looking for those typos or architectural errors that break the model’s integrity.

Audit mode and custom formatting

Visyond offers the possibility to auto format cells when you activate the Audit mode.

Cells will have a different format based on the type of data they contain and may display colored dots to indicate the presence of metadata.

In Audit mode, also trendlines for each row are shown.

Trendlines

In custom mode (when you toggle Audit mode off) you can format the cells in any way you wish. Ctrl / Command + f opens the formatting dialog.

Natural names

Unlike other spreadsheet software which use only cell references like C21, in Visyond you can use natural names like Revenue_growth[2016] as you create a formula. This makes the model extremely easy to understand and audit. You can switch back and forth between natural names and Excel notation.

 

You and your team will create and visually compare scenarios on the fly, during meetings or presentations 

Visyond is a collaborative scenario planning platform

Each cell in Visyond can contain multiple assumptions, comments and attachments from any collaborato.

Clicking on Cases in the context menu (or Ctrl / Command + k) brings up the Cases panel which contains your and/or your collaborators’ assumptions for that particular cell. As you work on your model you can switch between cases, and you can use the Report tab to visualize all cells with multiple cases, comments or attachments.

The Scenario Panel helps you manage different scenarios to run your model. Any collaborator can add scenarios to the model, and you can easily switch from one scenario to the next as you work on your model.

 

6. Scenario Panel 

You will visualize the impact of key drivers in minutes without exporting spreadsheet data to BI tools

Visyond is a secure and collaborative spreadsheet automation, business intelligence and data visualization platform

With Visyond you will build models and carry out, in minutes, analyses that skilled professionals prepare in hours or days using traditional spreadsheets and multiple business intelligence and data visualization tools.

You will do this in a fraction of the time and without worrying about deleting or changing your collaborators’ work or exporting the data set every time there is a change in the model.

For example, try running from the context menu Auto Analysis(Ctrl / Command + A) on any formula cell and see o fast you get insights that that would take you a long time and tedious manual setups to prepare.

Visyond was built with collaboration at its core and multiple collaborators can run and save different analysis they can always go back to. As usual, nobody but the owner of the analysis can edit or delete it.

Analysis Modules

Tornado Analysis

This modules shows you how an output cell is sensitive to all its drivers; it answers the question: ‘By what percentage the Output changes when the drivers, one by one, change by x% ?

Tornado
Tornado

 

Sensitivity Analysis

Once you know what the important inputs are, you can dig deeper on them by running a sensitivity analysis that shows you how an output varies when input(s) take certain values, either assigned manually, or over a defined range.

Sensitivity
Sensitivity

 

Scenario Analysis

You can easily create a variety of scenarios to compare and contrast .

Scenarios
Scenarios

 

Monte Carlo Simulation

Monte Carlo Simulation replaces the input(s) with random variables with a specified distribution; it shows the output cell (and its descriptive statistics) when the input(s) have the selected probability distributions.

Monte Carlo
Monte Carlo

 

Finally, you will be able to slice and dice data using Multidimensional Analysis (aka Cube / Pivot Tables).

Charts

Visyond has extensive data visualization capabilities. With Visyond you can create charts and tables, and present them to your colleagues or clients from inside the software instead of using a separate presentation tool.

Note how charts display the active scenario: no confusion on which assumptions were selected when the chart was printed.

You can easily group bars or create waterfall charts in a few clicks. All settings are at your fingertips: no need to guess where to right-click or which submenu to open.

 

 

Here’s how you view and use Charts .

 

10. Charts

 

You will easily find assumptions, supporting documents and conversations

Visyond is a knowledge management platform that stores and organizes anything collaborators share

You do not need to save support documents on different platforms or try to remember where something is or who provided certain assumptions.

No need to take notes: Visyond will document the model automatically as you and your collaborators work on it.

Visyond cells contain metadata. We have already seen the cases.

Collaborators can add Comments and Attachments (Ctrl / Command + i) in a cell.

The Report / Overview TAB will display all the key information contained in each cell.

You will generate pro-forma Financial Statements based on your spreadsheet model

Visyond creates forward looking predictive financial statements, driven by assumptions in your spreadsheet. Visyond’s statements can adapt to any reporting/accounting standard and automate the preparation of statements based on your settings.

Financial statement and key ratios will take shape as you select the spreadsheet rows that belong to certain categories (e.g., Revenues, COGS, OPEX, CAPES, etc.) and the columns of the time periods.

Depreciation, amortization, funding needs and ratios will be calculated automatically.

Visyond will also calculate the funding needs and the specific debt and equity needed to maintain a specific debt to equity ratio and cash amount on account.

Statements
Statements

 

 

how to
March 31, 2020

Was that post helpful?

Related Articles