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