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.

Learn more about EQUS

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

LEFT, RIGHT and FIND

Strings and things Think spreadsheets and you normally think numbers. However they are good at many processing tasks including text processing. Here we use a simple example from by Sumit Bansal in trumpexcel.com, extracting the first word from a cell. The article...

Looking up …

Looking up and extracting data from tables of numbers and strings is one of those things that most serious data analysts need to do on a regular basis. If you're familiar with Excel, you may have come across VLOOKUP and HLOOKUP and more recently XLOOKUP. Each of these...

EQUS in action … XOR and IFERROR

@msexcel regularly remind the Excel community of some of the useful functions and formula that help with finance, business analysis, data analysis and all the other jobs that Excel gets used for. Here we've a few illustrations inspired by @msexcel. One or the other...