Automated Data Analysis Using Excel
eBook - PDF

Automated Data Analysis Using Excel

Brian D. Bissett

  1. 480 pages
  2. English
  3. PDF
  4. Available on iOS & Android
eBook - PDF

Automated Data Analysis Using Excel

Brian D. Bissett

Book details
Table of contents
Citations

About This Book

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

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Automated Data Analysis Using Excel by Brian D. Bissett in PDF and/or ePUB format, as well as other popular books in Computer Science & Programming Games. We have over one million books available in our catalogue for you to explore.

Information

Publisher
Chapman and Hall/CRC
Year
2007
ISBN
9781584888864
Edition
1
Topic
Computer Science
Subtopic
Programming Games
Index
Computer Science

Table of contents

  1. Front cover
  2. Table of Contents
  3. Preface
  4. The Author
  5. Acknowledgments
  6. Introduction
  7. Chapter 1. Accessing Data in Excel: A Macro Writer’s Perspective
  8. Chapter 2. Methods of Loading and Saving Data in Excel
  9. Chapter 3. Control and Manipulation of Worksheet Data
  10. Chapter 4. Utilizing Functions in Excel
  11. Chapter 5. Data Mining in Excel
  12. Chapter 6. Creating Custom Report Worksheets
  13. Chapter 7. Introduction to Microsoft Access
  14. Chapter 8. From Excel to Access and Back Again
  15. Chapter 9. Analyses Via External Applications
  16. Chapter 10. An Example ADA Application That Generates a Report
  17. Appendix A: Option Explicit
  18. Appendix B: Excel Developer Tip
  19. Appendix C: Regression Analysis and Best Fit Lines (XE0124)
  20. Appendix D: Built-in Constants in Visual Basic for Applications (WC0993)
  21. Appendix E: xlodbc.exe Add-In
  22. Appendix F: XL: Scope of Variables in Visual Basic for Applications
  23. Appendix G: How to Convert Hexadecimal Numbers to Long Integer
  24. Appendix H: SendKeys Statement
  25. Index
  26. Back cover