Simon Hurst

Last time we looked at some Excel options that could be very useful


Setting your Excel options correctly can make a positive contribution to how efficiently you work with spreadsheets.


In a recent Any Answers question, Rikos asked for help with the follo

This sequence of tutorials has looked at different Excel functions and features that can be used for adding up and otherwise evaluating values:

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.


Simon Hurst, one of the members who worked to assemble the publication, examines ICAEW's 20 principles for good spreadsheet practice.


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.

In the previous instalment in this series we looked in some detail at the Power View add-in