Automated Data Analysis Using Excel (Paperback)

by Brian D. Bissett (Author)
Key Phrases: advanced browse, maximum row value, module sheet, End Sub, Automated Data Analysis Using Excel, Select Case (more...)

Editorial Reviews

Product Description
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. It begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use Excel to obtain data from non-native sources, such as databases and third-party calculation tools. After providing the means to access any required information, the book explains how to automate manipulations and calculations on the acquired data sources. Collecting all of the concepts previously discussed in the book, the final chapter demonstrates from beginning to end how to create a cohesive, robust application. With an understanding of this book, readers should be able to construct applications that can import data from a variety of sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.

About the Author
Pfizer Global Research and Development, Groton, Connecticut,

Product Details

• Paperback: 480 pages
• Publisher: Chapman & Hall/CRC (June 15, 2007)
• Language: English
• ISBN-10: 1584888857
• ISBN-13: 978-1584888857
• Product Dimensions: 9.8 x 7 x 1.1 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars See all reviews (2 customer reviews)
• Amazon.com Sales Rank: #524,598 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

2 of 2 people found the following review helpful:

5.0 out of 5 stars Great Book especially for those with some Exposure, March 6, 2009

By	Information Technology Professional "Informat... (New England, USA) - See all my reviews

This text is the only one of its kind that provides the level of detail required, and the necessary coding structures and constructs to perform very complex tasks in Excel. The book will provide the most benefit for people who have a strong knowledge of object oriented programming and VBA.
The book contains ready made coded modules that can be incorporated as black boxes into projects to perform complicated tasks such as curve fitting and plotting. It is clear the intention of this text is not teach the user to how code in Excel VBA, but to provide a framework to enable mid to high level programmers to accomplish more robust tasks.

3 of 6 people found the following review helpful:

2.0 out of 5 stars Another amateur book from Chapman & Hall, November 10, 2008

By	Dimitri Shvorob (Nashville, Tennessee) - See all my reviews (REAL NAME)

A Pfizer researcher writes a book about VBA, offering a collection of macros - most general-purpose, some specific to interaction with an ODBC source like Microsoft Access. (There is a small bit on calling Matlab from Excel, in absence of Excel Link or Builder for Excel, and a longer discussion of software called Origin). How is the book going to compete against Excel books already out there, most written by Excel professionals? I would recommend not spending your money to find out, and going for a real Excel/VBA reference.