A professional data analyst meets EQUS
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 ... ...
Before Modelling …
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 now allows you to easily copy the visualisations
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...
Excel Tips & Tricks – Top Advice from the Best Blogs & Websites
Whether you are a spreadsheet beginner or a data ninja, you can always learn, so here we signpost great MS Excel tips and tricks from some of the best blogs and websites in this field. Find advice for the latest Excel version in 2020 within Microsoft Office 365, as...
DataViz and Data Science Culture, Excel Tips, AI and Seaweed…
In this round-up we look at Microsoft Excel tips to make your numbers more manageable, how to create a dataviz and data science culture in your organisation, how seaweed could help fight climate change and more.
Excel Forecasting, Global Energy Sources, AI Trends, A/B Testing…
In our latest round-up, we look at objective forecasting in Excel, visualisations of global energy sources, Data & AI Trends, A/B Testing and more.
Excel Issues & Courses, Interactive Storytelling, Best Dog Breeds & more – a Month in Data
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.
Strict & Unstrict Functions in Excel – AVERAGE, PRODUCT & IF Examples
Here we look at strict vs unstrict functions in Microsoft Excel. We show examples with AVERAGE, PRODUCT and IF functions, plus vizualisations in EQUS.
Big Data for Healthcare, Spreadsheet Validation & Finding Aliens – a Month in Data
In our latest round up of useful or interesting news and articles we've seen over the last month, we signpost stories related to analytics for healthcare, validating your Excel spreadsheets, Indexical Visualization, and calculating your chance of meeting an alien....
Diversity Stats, GDPR, Outliers & Cyber Security – a Month in Data
In our latest roundup of data related stories and visualisations we've seen over the last 30 days, there are a couple of interesting articles related to racial and socioeconomic diversity, a true sporting outlier, and issues around spreadsheets, GDPR and cyber...