Simon Hurst | AccountingWEB

Simon Hurst

 Simon Hurst continues his series exploring ways to improve reporting with a look at conditional formatting.

In a return to spreadsheet design and presentation techniques, Simon Hurst begins his exploration of report formats with a look at numbering conventions.

9

Having concentrated on exposing Excel Table shortcomings last time, Simon H

8

Excel Tables feature frequently in management reporting tutorials, but Simon Hurst knows that they aren’t perfect. This article offers solutions for some of the key problems.

9

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

1

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

2

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

4

Simon Hurst gets his teeth into the different characteristics of  Excel's aggregate and summary functions.

4

Pages