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
In this data round-up, we look at how ITV’s Cleaning Up raised much debate about Microsoft Excel, interactive storytelling for presentations, the most popular and the best dog breeds to own (according to the numbers) and more.
Here we look at strict vs unstrict functions in Microsoft Excel. We show examples with AVERAGE, PRODUCT and IF functions, plus vizualisations in EQUS.
This post explains associativity in mathematics / arithmetic operators, with a simple example and visualization. It also shows how it’s easy to make errors if you don’t remember your arithmetic rules (BODMAS).