Automated Data Analysis Using Excel

ISBN-13: 9780367509316 / Angielski / Twarda / 2020 / 592 str.

Brian D. Bissett

Opis

This new edition includes some key topics relating to the latest version of MS Office, including use of the ribbon, current Excel file types, Dashboard, and basic Sharepoint integration. It shows how to automate operations, such as curve fitting, sorting, filtering, and analyzing data from a variety of sources. 

Spis treści

Preface. About the Author. Acknowledgments. Introduction. Chapter 1 Customizing Excel’s Ribbon Interface. Chapter 2 Accessing Data in Excel: A VBA Macro Writer’s Perspective. Chapter 3 Methods of Loading and Saving Data in Excel. Chapter 4 Control and Manipulation of Worksheet Data. Chapter 5 Utilizing Functions in Excel. Chapter 6 Data Mining in Excel. Chapter 7 Creating Custom Report Worksheets. Chapter 8 Introduction to Microsoft Access. Chapter 9 From Excel to Access and Back Again. Chapter 10 Analyses Via External Applications. Chapter 11 An Example ADA Application. Index.