1 1

Brian D. Bissett

Automated Data Analysis Using Excel

Automated Data Analysis Using Excel

£59.79 GBP
£64.99 GBP £59.79 GBP
8% OFF Sold out
Tax included. Shipping calculated at checkout.

YOU SAVE £5.20

  • Condition: Brand new
  • UK Delivery times: Usually arrives within 2 - 3 working days
  • UK Shipping: Fee starts at £2.39. Subject to product weight & dimension
Trustpilot 4.5 stars rating  Excellent
We're rated excellent on Trustpilot.
  • More about Automated Data Analysis Using Excel

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.

Format: Paperback / softback
Length: 592 pages
Publication date: 19 August 2020
Publisher: Apple Academic Press Inc.

This new edition covers some of the key topics relating to the latest version of MS Office through Excel 2019, including the creation of custom ribbons by injecting XML code into Excel Workbooks and how to link Excel VBA macros to customize ribbon objects. It now also provides examples in using ADO, DAO, and SQL queries to retrieve data from databases for analysis. Operations such as fully automated linear and non-linear curve fitting, linear and non-linear mapping, charting, plotting, sorting, and filtering of data have been updated to leverage the newest Excel VBA object models. The text provides examples on automated data analysis and the preparation of custom reports suitable for legal archiving and dissemination.

Functionality Demonstrated in This Edition Includes:

  • Find and extract information raw data files

  • Format data in color (conditional formatting)

  • Perform non-linear and linear regressions on data

  • Create custom functions for specific applications

  • Generate datasets for regressions and functions

  • Create custom reports for regulatory agencies

  • Leverage email to send generated reports

  • Return data to Excel using ADO, DAO, and SQL queries

  • Create database files for processed data

  • Create tables, records, and fields in databases

  • Add data to databases in fields or records

  • Leverage external computational engines

  • Call functions in MATLAB® and Origin® from Excel

Weight: 1092g
Dimension: 179 x 253 x 39 (mm)
ISBN-13: 9781482250138
Edition number: 2 New edition

This item can be found in:

UK and International shipping information

UK Delivery and returns information:

  • Delivery within 2 - 3 days when ordering in the UK.
  • Shipping fee for UK customers from £2.39. Fully tracked shipping service available.
  • Returns policy: Return within 30 days of receipt for full refund.

International deliveries:

Shulph Ink now ships to Australia, Belgium, Canada, France, Germany, Ireland, Italy, India, Luxembourg Saudi Arabia, Singapore, Spain, Netherlands, New Zealand, United Arab Emirates, United States of America.

  • Delivery times: within 5 - 10 days for international orders.
  • Shipping fee: charges vary for overseas orders. Only tracked services are available for most international orders. Some countries have untracked shipping options.
  • Customs charges: If ordering to addresses outside the United Kingdom, you may or may not incur additional customs and duties fees during local delivery.
View full details