Trending Bestseller

Automated Data Analysis Using Excel

Brian D. Bissett

No reviews yet Write a Review
Hardback
19 August 2020
$424.00
Ships in 3-5 business days
Hurry up! Current stock:

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
  • This product hasn't received any reviews yet. Be the first to review this product!

    $424.00
    Ships in 3-5 business days
    Hurry up! Current stock:

    Automated Data Analysis Using Excel

    $424.00

    Description

    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
    • Customers Also Viewed

      Buy Books Online at BookLoop

      Discover your next great read at BookLoop, Australiand online bookstore offering a vast selection of titles across various genres and interests. Whether you're curious about what's trending or searching for graphic novels that captivate, thrilling crime and mystery fiction, or exhilarating action and adventure stories, our curated collections have something for every reader. Delve into imaginative fantasy worlds or explore the realms of science fiction that challenge the boundaries of reality. Fans of contemporary narratives will find compelling stories in our contemporary fiction section. Embark on epic journeys with our fantasy and science fiction titles,

      Shop Trending Books and New Releases

      Explore our new releases for the most recent additions in romance books, fantasy books, graphic novels, crime and mystery books, science fiction books as well as biographies, cookbooks, self help books, tarot cards, fortunetelling and much more. With titles covering current trends, booktok and bookstagram recommendations, and emerging authors, BookLoop remains your go-to local australian bookstore for buying books online across all book genres.

      Shop Best Books By Collection

      Stay updated with the literary world by browsing our trending books, featuring the latest bestsellers and critically acclaimed works. Explore titles from popular brands like Minecraft, Pokemon, Star Wars, Bluey, Lonely Planet, ABIA award winners, Peppa Pig, and our specialised collection of ADHD books. At BookLoop, we are committed to providing a diverse and enriching reading experience for all.