by Chris Roast | Jun 22, 2021 | Data Analysis, Excel, Mathematics, News & Insights, Teaching
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...
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 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...