tutorial

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

3

As well as numerical data, text often finds its way into spreadsheets. Simon Hurst explains different ways you can deal with it.

1

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

Transatlantic trainer David H Ringstrom shows how to expand your formatting repertoire from cell colours and shades to include number formats.

1

David H Ringstrom continues his series of productivity suggestions with a tutorial explaining how to make Excel’s data validation facility work even more smoothly.

4

In his latest contribution from across the Atlantic David H Ringstrom explores some of the lesser known capabilities of that little rectangle at the top left of ev

1

AccountingWEB.com contributor David Ringstrom steps through some shortcuts to deal with a common Excel irritation, where the spreadsheet won’t recognise figu

4

The next instalment of David H Ringstrom’s trans-Atlantic series of Excel tips tackles the pesky problem of  #VALUE! alerts.

1

This is the fifth part of our series looking at new tools for  

Pages