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...

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...

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 ... ...

Visualize & Check Formulae in Excel:

Share This