VeryViz for Data, Spreadsheets & Analytics
Welcome to VeryViz – the website for data integrity, visualization, analytics, spreadsheets and more.
DID YOU KNOW – “NEARLY 9 OUT
OF 10 SPREADSHEETS (88%)
CONTAIN ERRORS” – SALESFORCE
And these errors – many of which are serious – have cost companies large and small up to several billion dollars – each!
It is this issue that VeryViz aims to address with expert advice and a suite of innovative software solutions.
Spreadsheet Data Analysis Tools
Microsoft Excel is a powerful data analysis tool in its own right. With a wide range of Excel add-ins available from the Microsoft Office website and many 3rd party publishers, you can make your spreadsheets even more useful.
Read our post on Excel Add-Ins for Data Analysis.
EQUS for Data Integrity
EQUS stands for Enhancing the Quality and Usability of Spreadsheets. With so many spreadsheets containing (often costly) errors, EQUS is a new tool developed by Sheffield Hallam University and Learning Light Ltd to help people visualize, check and understand their formulae.
Spreadsheet Tips & Advice
Expert advice on using spreadsheets effectively to organise, visualize, analyse and understand your data. We’ll include tips and tricks for using popular desktop and cloud-based software and databases, including Microsoft Excel, SQL and Google Sheets.
Read our post on Excel Tips & Tricks from some of the best blogs and websites.
Learn more - About VeryViz
Spreadsheets at the best of times can be hard to read. Sometimes it is simply hard to see what they are up to. Here's a short video of a professional data analyst seeing EQUS for the first time while working with one of his spreadsheets. A very rewarding reaction ... ...
Developing spreadsheets involves is a balancing act between how much you express in formulae within a single cell and how much you break-up formulae across a number of cells. In many cases a single formula captures much of what needs to be computed, but it is so...
EQUS, the spreadsheet visualisation tool, now allows you to easily make copies. For educators and other spreadhseet users the visualisation EQUS makes is helpful because it shows the structure of any formula and also the values used. Teachers like it. Some have asked...