Automated data analysis using Excel /
By: Bissett, Brian
Material type:
BookPublisher: Boca Raton : Chapman & Hall/CRC, c2007.Description: 442 p. : ill. ; 26 cm. 1 CD-ROM.ISBN: 9781584888857; 1584888857 (alk. paper)Subject(s): Computer software -- Development | Decision making -- Computer programsDDC classification: 005.3 BI AU Online resources: Location Map | Item type | Home library | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|
| REGULAR | University of Wollongong in Dubai Main Collection | 005.3 BI AU (Browse shelf) | Available | T0055671 |
, Shelving location: Main Collection Close shelf browser
|
|
|
|
|
|
|
||
| 005.3 AP PS Apps management and e-commerce transactions in real-time | 005.3 AT BU Building progressive web apps : | 005.3 BE PL Planning extreme programming / | 005.3 BI AU Automated data analysis using Excel / | 005.3 BR CO Computer systems : | 005.3 DE RE Reactive application development | 005.3 EL CO Computer systems : |
Includes index.
Includes bibliographical references and index.
Ch. 1. Accessing data in Excel : a macro writer's perspective
Ch. 2. Methods of loading and saving data in Excel
Ch. 3. Control and manipulation of worksheet data
Ch. 4. Utilizing functions in Excel
Ch. 5. Data mining in Excel
Ch. 6. Creating custom report worksheets
Ch. 7. Introduction to Microsoft Access
Ch. 8. From Excel to access and back again
Ch. 9. Analyses via external applications
Ch. 10. An example ADA application that generates a report
App. A. Option explicit
App. B. Excel developer tip
App. C. Regression analysis and best fit lines (XE0124)
App. D. Built-in constants in Visual Basic for applications (WC0993)
App. E. xlodbc.exe add-in
App. F. XL : scope of variables in Visual Basic for applications
App. G. How to convert hexadecimal numbers to long integer
App. H. SendKeys statement.
Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to minimize user intervention, automate parameter setup, obtain consistency in both analysis and reporting, and save time through automation. Focusing on the built-in Visual Basic for Applications (VBA) scripting language of Excel, the book shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings.