آنالیز خودکار اطلاعات با اکسل

Automated Data Analysis Using Excel

Brian Bissett
Chapman & Hall/CRC | ISBN 1584888857 | June 15, 2007 | 512 Pages | PDF | 14.2MB

Demonstrates automation operations such as regression, windowing, linear and nonlinear mapping, sorting, filtering, and analyzing data from a variety of sources

Provides generic, flexible methods and numerous real-world examples that can be applied to many different industrial and academic fields

Explores direct database manipulation from Excel using DAO, SQL, ODBC, and dynamic data pointers

Shows how to interface Excel with other applications by using ActiveX servers, DDE, and COM

Includes a CD-ROM that features sample workbooks, worksheets, and source code