Search

Categories

    • categories-img Jacket, Women
    • categories-img Woolend Jacket
    • categories-img Western denim
    • categories-img Mini Dresss
    • categories-img Jacket, Women
    • categories-img Woolend Jacket
    • categories-img Western denim
    • categories-img Mini Dresss
    • categories-img Jacket, Women
    • categories-img Woolend Jacket
    • categories-img Western denim
    • categories-img Mini Dresss
    • categories-img Jacket, Women
    • categories-img Woolend Jacket
    • categories-img Western denim
    • categories-img Mini Dresss
    • categories-img Jacket, Women
    • categories-img Woolend Jacket
    • categories-img Western denim
    • categories-img Mini Dresss

Filter By Price

$
-
$

Dietary Needs

Top Rated Product

product-img product-img

Modern Chair

$165.00
product-img product-img

Plastic Chair

$165.00
product-img product-img

Design Rooms

$165.00

Brands

  • Wooden
  • Chair
  • Modern
  • Fabric
  • Shoulder
  • Winter
  • Accessories
  • Dress

Welcome and thank you for visiting us. For any query call us on 0799 626 359 or Email [email protected]

Offcanvas Menu Open

Shopping Cart

Africa largest book store

Sub Total:

Search for any Title

Automated Data Analysis Using Excel (Chapman & Hall/CRC Data Mining and Knowledge Discovery Series)

By: Brian D. Bissett (Author)

Manufacture on Demand

Ksh 41,800.00

Format: Hardback or Cased Book

ISBN-10: 0367509318

ISBN-13: 9780367509316

Collection / Series: Chapman & Hall/CRC Data Mining and Knowledge Discovery Series

Collection Type: Publisher collection

Edition Number: 2

Publisher: Taylor & Francis Ltd

Imprint: Chapman & Hall/CRC

Country of Manufacture: GB

Country of Publication: GB

Publication Date: Aug 19th, 2020

Publication Status: Active

Product extent: 592 Pages

Weight: 453.00 grams

Product Classification / Subject(s): Excel
Data capture & analysis

Choose your Location

Shipping & Delivery

Door Delivery

Delivery fee

Delivery in 10 to 14 days

  • Description

  • Reviews

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 guranteed only at Werezi Africa largest book ecommerce store. The book was published by Taylor & Francis Ltd and it has pages. Enjoy Shopping Best Offers & Deals on books Online from Werezi - Receive at your doorstep - Fast Delivery - Secure mode of Payment

    Customer Reviews

    Based on 0 reviews

    Mind, Body, & Spirit