Detail The Automated Spreadsheet   Oleh:  Rose, Anna M. ; Rose, Jacob M. Jenis: Article from Bulletin/Magazine Dalam koleksi: Journal of Accountancy vol. 191 no. 4 (2001), page 33-42. Topik: ELECTRONIC SPREADSHEETS; automated spreadsheet Ketersediaan Perpustakaan Pusat (Semanggi) Nomor Panggil: JJ85.12 Non-tandon: 1 (dapat dipinjam: 0) Tandon: tidak ada     Lihat Detail Induk Isi artikel You’re about to leave on a business trip. You’ve packed your laptop, Palm personal digital assistant, e -m ail pager and cell phone. Yet despite all of this high - tech equipment, you feel disconnected from your office even before you board the plane. After all, you realize that being on the road significantly increases the possibility you won’t be able to adequately monitor your business even if you can remotely connect to the Internet. What if you had a function that could robotically perform some of the monitoring for you - automatically, 24 hours a day, seven days a week - and alert you when it’s appropriate ? Well, you probably already have that power - Excel - in your briefcase. But to use it you need a computer that’s linked to the Internet. This article will show you how to use Excel to search for the data you need and then, when certain preset criteria are met, alert you to take action - wherever you are. Here are some of the things the Excel function can do : - Track stock market activity. Excel can import current stock market data from the Internet and alert you by e-mail to critical market changes that require immediate action. - Monitor information in your organization’s database that requires a rapid response. For example, alerts can be triggered by significant overtime on an engagement, unusually large sales, orders from your largest customers, receipt of an important shipment, failure to deliver products at specified times, unexpected changes in production quality or quantity, spending in excess of budgeted limits and unusual ratio fluctuations. You can program Excel to send e - mails to selected people in response to an alert. - Keep a corps of business travelers current on key market or inventory information. Excel can automatically activate e - mails to those out of the office, notifying them of changes in service or product prices, product availability, special discount offering - and each person will receive only personally relevant information. Now let’s learn how to create these automated messages. Opini Anda Klik untuk menuliskan opini Anda tentang koleksi ini! Kembali

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