tutorial | AccountingWEB

tutorial

This excerpt from David Ringstrom’s High Impact Excel series on our US sister site shows how you can apply conditiona

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

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

Pages