Detail Simplify Your Future with Rolling Charts   Oleh:  Weisel, James A. Jenis: Article from Bulletin/Magazine Dalam koleksi: Journal of Accountancy vol. 214 no. 1 (Jul. 2012), page 36-41. Topik: Spreadsheets; Sales Presentations; Accounting Firms Ketersediaan Perpustakaan Pusat (Semanggi) Nomor Panggil: JJ85.33 Non-tandon: 1 (dapat dipinjam: 0) Tandon: tidak ada     Lihat Detail Induk Isi artikel You have prepared a presentation using 12 months of sales data for your client, Dynamo Co. After everyone is gathered, the client's CEO says she has more recent sales figures available and asks whether they can be included in the chart while eliminating some of the old data. It's well known that Excel charts automatically reflect changes to existing data. Including new data in an existing chart requires manually revising the chart references -- a tedious process and one prone to error. Excel has accommodated real-time chart creation for years. A four-step process can create charts that automatically reflect additions to the data set. These include: 1. Select an empty cell somewhere in the worksheet to identify the number of columns to be used. 2. Create the first range name. Play with the chart you created in the Exercise worksheet. Opini Anda Klik untuk menuliskan opini Anda tentang koleksi ini! Kembali

Copyright © 2006, 2007 Unika Atma Jaya, all rights reserved