Exploring the core areas of automation, report preparation, data acquisition, and data analysis, Automated Data Analysis Using Excel describes how to minimize user intervention, automatic 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, this book shows step-by-step how to build useful applications that automatically analyzes the data for both industrial and academic settings. Collect all the concepts previously discussed in this book, the last chapter shows from start to finish how to create applications, strong cohesive. By understanding this book, the reader should be able to build applications that can import data from various sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.