David Carter's first tutorial on pivot tables was the most visited part of AccountingWEB last year (AccountingWeb is one of our parallel professional communities), proving the value of an in-depth knowledge of this indispensable Excel tool.

His second guide looks at importing sales data in a Text file format using the software's Import wizard. As before, the tutorial will give you practical tips on how you can use pivot tables on a daily basis.

Simply follow the instructions to fully understand the power of the pivot. Tell your friends and colleagues about our excellent guide - and watch out for future tutorials both on AccountingWeb and TrainingZone. We plan to develop an extensive programme of online learning, as well as our present series of online workshops. Watch this space for more details.