Werezi Books
Cart 0
Automated Data Analysis Using Excel
Click to zoom

Share this book

Automated Data Analysis Using Excel

by Brian D. Bissett

Book Details

Format Hardback or Cased Book
Book Series Chapman & Hall/CRC Data Mining and Knowledge Discovery Series
ISBN-10 0367509318
ISBN-13 9780367509316
Publisher Taylor & Francis Ltd
Imprint Chapman & Hall/CRC
Country of Manufacture GB
Country of Publication GB
Publication Date Aug 19th, 2020
Print length 592 Pages
Weight 453 grams
Product Classification: ExcelData capture & analysis
Ksh 31,500.00
Werezi Extended Catalogue Delivery in 28 days

Delivery Location

Delivery fee: Select location

Delivery in 28 days

Secure
Quality
Fast
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.

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

    • Get Automated Data Analysis Using Excel by at the best price and quality guaranteed only at Werezi Africa's largest book ecommerce store. The book was published by Taylor & Francis Ltd and it has pages.

    Mind, Body, & Spirit

    The Mamba Mentality

    The Mamba Mentality

    Price

    Ksh 31,500.00

    Shopping Cart

    Africa largest book store

    Sub Total:
    Ebooks

    Digital Library
    Coming Soon

    Our digital collection is currently being curated to ensure the best possible reading experience on Werezi. We'll be launching our Ebooks platform shortly.