by Chris Roast | Sep 2, 2020 | Data Analysis, Excel, Teaching, Tips
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...
by Chris Roast | Aug 20, 2020 | Uncategorized
Much of excitement about big data and visualisation bridges two ends of a complex problem, first get the data and make sense of it and then visualise it! Sourcing and combining the data is one challenge, but once you see what visualisation is when you start to realise...
by Chris Roast | Aug 14, 2020 | Data Analysis, Excel, Tips
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...
by Chris Roast | Aug 14, 2020 | Data Analysis, Excel, Mathematics, Tips
@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...
by Chris Roast | Aug 11, 2020 | Excel, Tools
We have done a little theorising on complexity of working with a simple functional language. Although not necessarily famed for being a functional language, we are looking at spreadsheets and applying a classical model of human performance known as the Keystroke Level...
