ABSTRACT

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 m

chapter 3|28 pages

Control and Manipulation of Worksheet Data

chapter 4|44 pages

Utilizing Functions in Excel

chapter 5|64 pages

Data Mining in Excel

chapter 6|26 pages

Creating Custom Report Worksheets

chapter 7|32 pages

Introduction to Microsoft Access

chapter 8|34 pages

From Excel to Access and Back Again

chapter 9|60 pages

Analyses Via External Applications