by Chris Roast | Jul 5, 2021 | Excel, Mathematics, Teaching, Tools
Put yourself in the position of a learner … You are following a workbook exercise using Excel. You’ve put the formula in, and entered the data. But something is wrong the number you’ve got is different to the workbook. Option 1: You put your hand up....
by Chris Roast | Jul 1, 2021 | Excel, Teaching, Tools
Normally we use EQUS to demonstrate numeric computations but here is a nice example with textual data. Inspired by some a tweet from @ddalgleish here is a short video showing JOINTEXT visualised using the EQUS add-in https://youtu.be/g7vaSAlwLkI
by Chris Roast | Jun 30, 2021 | Excel, Mathematics, Teaching
Numerical reasoning is often a challenge, especially when percentages are involved. To start with “%” is very simple, but of course its use in context often makes things harder. Here we show how putting percentage expressions in Excel and seeing them...
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 | Jul 9, 2020 | Excel, Mathematics, Teaching, Tips, Training
Developing spreadsheets involves is a balancing act between how much you express in formulae within a single cell and how much you break-up formulae across a number of cells. In many cases a single formula captures much of what needs to be computed, but it is so...