Detail How To Link to Web Data   Oleh:  Woodroof, Jon Jenis: Article from Bulletin/Magazine Dalam koleksi: Journal of Accountancy vol. 187 no. 3 (1999), page 55-60. Topik: WEB DATABASES; web data Ketersediaan Perpustakaan Pusat (Semanggi) Nomor Panggil: JJ85.8 Non-tandon: 1 (dapat dipinjam: 0) Tandon: tidak ada     Lihat Detail Induk Isi artikel Would you like to download financial, sales or stock market information from a Web site and then plug it directly into a spreadsheet on your computer ? Better yet, would you like all the data refreshed automatically every time you open the spreadsheet file ? Just a year or so ago, you would have had to go through a series of tedious steps to perform such downloads. (See Taking Stock on the Internet, JofA, Jan. 97.) But now, with the Web Query function in Excel 97, a built - in wizard will walk you through the entire setup. Why, you may ask, would you want to do that ? There are many reasons. Consider just a few of them. Up - to - date corporate financial statements or other financial data often can be found on a Web site, so anyone wishing to analyze that information in greater depth conveniently can download the data into an instantly updated spreadsheet. Employees who travel or work at home can access their companies Web pages loaded with data such as sales and financial and inventory information and download the fully formatted data directly into spreadsheet files for in - depth analysis. Suppliers and their customers that need to keep in close touch can access each others delivery, sales and inventory data as a way to synchronize records and the transfer of goods. Publicly held businesses can track the market value of securities they hold automatically. The posting of the securities market value is required under FASB Statement no. 115, Accounting for Certain Investments in Debt and Equity Securities. Tracking the information manually is tedious, but this computer tool can do it with a few mouse clicks. Individual investors can keep track of their portfolios by downloading the latest stock prices into spreadsheets for analysis. Currency exchange and money market rates, which are in constant flux, can be fed directly into formulas or charts and refreshed to keep spreadsheets updated automatically. Opini Anda Klik untuk menuliskan opini Anda tentang koleksi ini! Kembali

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