Can you use this visualisation?
Data visualisation is one of those fantastic ideas where data is presented in a format that allows us to see what is going on. From a good visualisation we can drawn conclusions about a data set easily. We can interpret the numbers with the effort of doing any number...
For world refugee day … seeing now people have moved
Visualisations are brilliant at summarising important information so we can quickly see what's going on. Here is an informative visualisation for world refugee day. Some surprises when compared with how the movement of people is often reported. Consider the forces at...
Free EQUS download for a limited period
For a short period we are enabling free access to EQUS Expert. This is so you can experience the full functionality of EQUS and put it through its paces. We welcome your feedback on it. EQUS provides an easy to use means of showing how Excel computations are...
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...
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 ... ...
Biology, Fraud Detection, GQL and the Falling Cost of Green Energy – a Month in Data
Here we look at how data can be used for credit card fraud detection, GQL as an official database query language, the falling cost of green energy and more.
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.