Add perspective to spreadsheets
The following Anbar abstracts are a review of the most pertinent recently published literature. They are selected for The Bottom Line from Anbar Management Intelligence,available by subscription from Anbar Electronic Intelligence.
Licenced copies of these articles are available at a cost of £6.00 (plus VAT in EU countries where applicable), US$11.00 per credit from Anbar Electronic Intelligence, 60/62 Toller Lane, Bradford, West Yorkshire BD8 9BY, UK. Prepayment for this service is required and, when ordering, please submit a cheque made payable to Anbar Electronic Intelligence. When ordering please quote the reference number and the credit level given at the foot of each abstract.
Add perspective to spreadsheets
J.F. Lacher in Journal of Accountancy (USA), Dec. 1998 Vol. 186 No. 6: p. 91 (6 pages)
Explains how the introduction of the Excel PivotTable function facilitates financial spreadsheet analysis and illustrates screens using it as a budget tool, a sales analyser and a database link. Gives step-by-step instructions for creating a PivotTable and three suggestions for improving PivotTable skills. Compares the analytical tools offered by Lotus 123 and Quattro Pro and describes the Excel improvements which will feature in the Microsoft Office 2000 suite when it is released.
Subject(s): Spreadsheets,Software development, Accountants
Style: Technical
Reference: 28AF047 (1 credit)
