In the second instalment of his overview of Excel’s summary functions, Simon Hurst delves further into the different capabilities of SUMIF, SUMIFS and array formulae for creating conditional su
Simon Hurst gets his teeth into the different characteristics of Excel's aggregate and summary functions.
As well as numerical data, text often finds its way into spreadsheets. Simon Hurst explains different ways you can deal with it.
Simon Hurst turns his attention to standard Excel functions such as SUMIF and SUMPRODUCT that make it easier to produce summary totals.
David Ringstrom says that building complex spreadsheets without using VLOOKUP is like putting a screw in the wall with a hammer.
AccountingWEB’s trans-Atlantic Excel trainer David H Ringstrom continues his series with a look at techniques to improve the integrity of the AutoSum function.
AccountingWEB.com contributor David Ringstrom steps through some shortcuts to deal with a common Excel irritation, where the spreadsheet won’t recognise figu
Continuing his exploration of the latest version of Excel, Simon Hurst delves into some of the new functions that may be useful for accountants.
In our latest trans-Atlantic Excel tip, David Ringstrom shows how the LARGE and SMALL functions can take some of the drudgery out of finding high/low values in your data.