If you have an error, try #IFERROR
It is not uncommon to complete a spreadsheet model for expected values only to find that some user inputs are not what you expected result in errors. Depending upon the details, you simply what to stop that error behaviour cropping up in your reporting -...
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...
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 other...
Before Modelling …
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...
EQUS now allows you to easily copy the visualisations
EQUS, the spreadsheet visualisation tool, now allows you to easily make copies. For educators and other spreadhseet users the visualisation EQUS makes is helpful because it shows the structure of any formula and also the values used. Teachers like it. Some have asked...
Excel Tips & Tricks – Top Advice from the Best Blogs & Websites
Whether you are a spreadsheet beginner or a data ninja, you can always learn, so here we signpost great MS Excel tips and tricks from some of the best blogs and websites in this field. Find advice for the latest Excel version in 2020 within Microsoft Office 365, as...
Strict & Unstrict Functions in Excel – AVERAGE, PRODUCT & IF Examples
Here we look at strict vs unstrict functions in Microsoft Excel. We show examples with AVERAGE, PRODUCT and IF functions, plus vizualisations in EQUS.