Ebook: Automated Data Analysis Using Excel

This guide shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings. It features numerous real-world examples and includes a CD-ROM with sample workbooks, worksheets, and source code. The book begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use ExcelR to obtain data from non-native sources, such as databases and third-party calculation tools, and explains how to automate manipulations and calculations on the acquired data sources. The final chapter demonstrates from beginning to end how to create a cohesive, robust application.