Automated Data Analysis Using Excel
来源:互联网 发布:怎么查看php源代码 编辑:程序博客网 时间:2024/05/22 13:04
版权声明:原创作品,允许转载,转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/topmvp - topmvp
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.
http://rapidshare.com/files/48414138/1584888857.zip
http://depositfiles.com/files/1483728
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.
http://rapidshare.com/files/48414138/1584888857.zip
http://depositfiles.com/files/1483728
- Automated Data Analysis Using Excel
- Data Analysis Using SQL and Excel
- Data Analysis Using SQL and Excel (Paperback), Oct.2007.eBook-BBL
- Social Data and Log Analysis Using MongoDB
- Data Analysis Using SAS EG Syllabus
- Dynamics AX 2009: Ad hoc Analysis using Excel 2007 to get data from an AX OLAP Cube
- Excel 2007 Data Analysis For Dummies
- An Overview of Survival Analysis using Complex Sample Data
- Easy, Real-Time Big Data Analysis Using Storm
- 学习Introduction to Data Analysis using R系列
- export excel file with using data table
- Writing Data to Excel using C#
- Legacy Data Transfer Using MicrosoftÒ Excel
- data analysis
- Data Analysis
- Using SQLMap for Automated Vulnerability Assessment
- Automated ad hoc builds using Xcode 4
- Automated Installation Methods Using Response Files
- abstract与interface的区别
- Office 2007 Bible
- 作团队感悟(17)----小结一下我的作团队感悟
- operator new抛出异常的处理
- PKU 3041 Asteroids - 行列的二分图模型 最小点覆盖
- Automated Data Analysis Using Excel
- 网页弹出对话框
- Google SketchUp For Dummies
- 奇虎周鸿祎:互联网公司应主动"锻炼"积极"过冬"
- 作团队感悟(18)----如何引进开发方式
- Foundation Flash CS3 for Designers
- sql *net 没有完全安装的解决方案
- SAS For Dummies
- Rhythmbox乱码的解决办法